Sr. ETL Test Engineer

Job Title: Sr. ETL Test Engineer

Experience Required: Minimum 8 years

Location: Gurgaon/ Noida/ Pune (WFO)

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

5+ 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.