Headline

Lead Associate at EY | Ex - PwC | Grad from University of Calcutta| Ex-Intern at Yokohama Off-Highway Tires|

About

ETL Automation Tester with strong hands-on experience in validating complex data pipelines, automating data quality checks, and ensuring accurate, reliable data delivery across enterprise systems. Skilled in Python, PySpark, Pytest, SQL, Power BI, Alteryx, Azure Databricks, Azure Synapse, Azure DevOps, and Microsoft Excel, with expertise in end-to-end ETL testing, data validation, automation framework development, and defect analysis. Experienced in designing and executing automated test scenarios for large-scale data transformations, validating source-to-target mappings, performing reconciliation and data integrity checks, and identifying data quality issues across cloud-based data platforms. Proficient in leveraging PySpark and Python for data validation and test automation, Pytest for automation frameworks and Azure Databricks and Azure Synapse for cloud-based data processing and validation. Known for strong analytical and problem-solving skills, attention to detail, and effective collaboration with cross-functional teams. Experienced in using Azure DevOps for test management, defect tracking, and CI/CD-aligned testing processes, along with Power BI, Alteryx, and Excel for reporting, data analysis, and validation. Open to opportunities in ETL Automation Testing, Data Quality Engineering, Data Engineering Testing, BI Testing, and Cloud Data Testing.

Location

Kolkata

AI stack

claude

openai

Work experience

Lead Associate at EY, May 2026 - Present · 7 mos

Associate at PwC, Aug 2022 - May 2026 · 3 yrs 10 mos, Kolkata, West Bengal, India, Worked as an ETL Tester for Shell, primarily handling SQL and Power BI-based testing and reporting activities. Key responsibilities included ETL data validation, report verification, and ensuring data accuracy across dashboards and workflows. Previously worked on Alteryx workflow designing, where multiple workflows were developed and customized based on client-provided EIB requirements. Also worked for the client ABB in a data migration project, where source data was transformed into Workday-compatible formats using SQL, Power BI, and XML. Contributed to successful project delivery by performing exhaustive, regression, and smoke testing to ensure data integrity and system reliability.

Intern at Yokohama Off-Highway Tires, Nov 2021 - Dec 2021 · 2 mos

Education

Bachelor of Technology - BTech, Plastics and Polymer Engineering Technology/Technician, University of Calcutta