About Shikha
I bring 4+ years of hands-on experience designing and implementing robust data pipelines that turn messy data into valuable business insights. I specialize in building end-to-end ETL workflows using SQL and Python, optimizing performance, and delivering clean, analytics-ready data.
English
Native or bilingual
Remote only
Primarily works remotely
Experience
- CitibankData EngineerMay 2022 - August 2023 (1 year and 3 months)Pune, Maharashtra, India• Built and maintained robust ETL/ELT pipelines using Python and SQL for ingesting and transforming data into AWS S3.• Optimized data workflows and implemented data validation frameworks, improving data accuracy and pipeline reliability.• Developed scalable data transformations using PETL and integrated Airflow for task orchestration and monitoring.• Designed data models and schemas aligned with business logic for efficient data access and reporting.• Partnered with analysts and engineering teams to support data requirements, enhancing reporting turnaround by 15%.
- Guardian Life Insurance Company of AmericaData EngineerNovember 2019 - April 2022 (2 years and 5 months)Gurugram, Haryana, India• Designed and implemented ETL pipelines using Syncsort and integrated data from Oracle, Mainframe, and SQL Server into AWS S3, increasing data availability by 25%.• Automated data ingestion pipelines using PySpark, improving batch processing speeds by 35% and reducing manual overhead by 60%.• Worked on data modeling and schema design for BI reporting and analytics systems.• Collaborated with product and analytics teams to support data-driven initiatives and improve forecast accuracy through predictive modeling.• Ensured data quality via automated validation and unit testing frameworks.
- RxlogixPL/SQL InternJanuary 2019 - May 2019 (4 months)Noida, Uttar Pradesh, India• Developed and optimized PL/SQL procedures, views, and database objects, improving system performance by 15%.• Performed query optimization and assisted in production issue resolution, reducing query run time by 25%.• Developed automated testing frameworks for database procedures, significantly reducing manual testing efforts and improving code quality assurance.
Recommendations
Be the first to recommend Shikha
Help this freelancer shine by sharing your experience working together.
These freelancer profiles also match your criteria
Agatha Frydrych
Backend Java Software Engineer
4.7
(3)
2
Baptiste Duhen
Fullstack developer
4.6
(4)
5
Amed Hamou
Senior Lead Developer
4
(2)
7
Audrey Champion
Web developer
4.3
(3)
4
Education
- "Introduction to Data Science"Cisco Networking Academy"Introduction to Data Science"
- "SQL Intermediate Certified"HackerRank(Verified)"SQL Intermediate Certified"