Vartika Raj
Lucknow
Summary
Detail-oriented Data Engineer with extensive experience in developing ETL workflows and generating insightful reports. Successfully led data migration initiatives, enhancing data integrity and operational efficiency across diverse domains.
Overview
6
6
years of professional experience
6
6
Certifications
Work History
Assistant Manager
Ernst & Young
Noida
04.2022 - Current
- UK Compensation Cleansing - Data Engineer - Developed parameterized tax compensation reports by transforming source data from Excel files into SQL tables and publishing the processed data through SSRS reports, ensuring compliance with client requirements.
- UK Tax Dashboard– Data Engineer - Provided operational support by monitoring Azure Data Factory (ADF) pipelines, diagnosing issues, and resolving client-reported errors and bugs to maintain seamless data workflows.
- Enstar Management– Senior Database Developer – Associated with the client for around 3 years & responsible for end-to-end SQL development, issue debugging, and performance optimization. Led data migration initiatives during source system transitions, ensuring seamless integration and data integrity. Automated data reconciliation processes to improve accuracy and reduce manual effort. Acted as the sole developer managing and resolving issues across multiple client processes. Designed and implemented ETL workflows to process data from SQL tables and generate extracts for downstream consumption.
- US-Global Tax Platform IT- Lead Database Developer - Managed database performance tuning and optimization efforts. Collaborated with cross-functional teams to align database solutions with business needs, as per Agile methodology. Supervised a team of database developers and administrators to ensure project deadlines.
Data Engineer
Tata Consultancy Services
Mumbai
07.2019 - 04.2022
- Worked in the MSBI stack and SQL Server as an SSIS Developer and Support Engineer.
- Designed and implemented data pipelines for extraction, transformation, and reporting through SSRS, and led ETL migrations involving source system transitions, code refactoring, and process optimization to ensure data integrity and reliability.
- Worked in diverse domains, including Finance, Manufacturing, and Claims.
Education
Bachelor of Technology - Computer Science
Ajay Kumar Garg Engineering College
Ghaziabad05-2019
Skills
- Cloud computing: Azure Data Factory
- Databases and ETL: MS SQL Server, SSIS, ETL programming
- Reporting tools: SSRS, MS Excel
- DevOps tools: Azure DevOps, GitHub
- Other tools – ServiceNow, Visual Studio
Certification
Hackerrank Advanced SQL
Timeline
Assistant Manager
Ernst & Young
04.2022 - Current
Data Engineer
Tata Consultancy Services
07.2019 - 04.2022
Bachelor of Technology - Computer Science
Ajay Kumar Garg Engineering College