Senior ETL Test Engineer

Job Title: Sr. ETL Test Engineer

Experience Required: Minimum 8 years

Location: Gurgaon/ Noida/ Pune (WFO)

About the Role

We are seeking an experienced ETL Test Engineer with strong expertise in cloud-based ETL tools, Azure ecosystem, and advanced SQL skills. The ideal candidate will have a proven track record in validating complex data pipelines, ensuring data integrity, and collaborating with cross-functional teams in an Agile environment.

Key Responsibilities

* Design, develop, and execute ETL test plans, test cases, and test scripts for cloud-based data pipelines.

* Perform data validation, transformation, and reconciliation between source and target systems.

* Work extensively with Azure Data Factory, Azure Synapse Analytics, Azure SQL Database, and related Azure services.

* Develop and run complex SQL queries for data extraction, analysis, and validation.

* Collaborate with developers, business analysts, and product owners to clarify requirements and ensure comprehensive test coverage.

* Perform regression, functional, and performance testing of ETL processes.

* Identify defects, log them, and work with development teams to ensure timely resolution.

* Participate in Agile ceremonies (daily stand-ups, sprint planning, retrospectives) and contribute to continuous improvement.

* Ensure adherence to data quality and compliance standards.

Required Skills & Experience

* 8+ years of experience in ETL testing, preferably with cloud-based ETL tools.

* Strong hands-on experience with Azure Data Factory, Azure Synapse Analytics, and Azure SQL.

* Advanced SQL query writing and performance tuning skills.

* Strong understanding of data warehousing concepts, data models, and data governance.

* Experience with Agile methodologies and working in a Scrum team.

* Excellent communication and stakeholder management skills.

* Strong problem-solving skills and attention to detail.

Preferred Skills

* Experience with Python, PySpark, or automation frameworks for ETL testing.

* Exposure to CI/CD pipelines in Azure DevOps or similar tools.

* Knowledge of data security, compliance, and privacy regulations.