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 :

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