Datawarehouse ETL Tester Lead (Azure)

EXL; Pune District; On-site; INR 1,800,000 - 3,200,000; Full time

Job summary

A leading data service company in Pune is seeking a QA Lead to oversee the QA strategy for ETL and Data Warehouse testing on Azure. The role involves designing and executing test cases, implementing automated testing using Python and PySpark, and validating data accuracy with SQL queries. Candidates should have strong experience in functional, integration, and regression testing and be capable of mentoring QA team members. Competitive compensation and opportunities for continuous improvement in QA processes are offered.

Qualifications

• Experience with ETL and Data Warehouse testing on Azure.
• Proficient in writing advanced SQL queries for data validation.
• Strong background in automated testing using Python and PySpark.
• Hands-on testing of data ingestion, transformation, and storage pipelines.
• Experience with Python-based testing and PySpark automation.
• Mentor and guide QA team members; collaborate with data engineers.

Responsibilities

• Lead QA strategy for ETL and Data Warehouse testing on Azure.
• Design and execute test cases for data ingestion, transformation, and storage.
• Perform functional, integration, and regression testing.
• Validate data accuracy and reconciliation.
• Implement automated data testing.
• Collaborate with cross-functional teams.
• Drive continuous improvement in QA processes.
• Develop automated data testing with Python and PySpark.
• Test pipelines on Azure Databricks.
• Manage defects, test execution, reporting.
• Drive QA process improvements and automation.
• Mentor QA team members.

Skills

ETL and Data Warehouse testing

Advanced SQL queries

Python

PySpark

Azure Databricks

Python

PySpark

Databricks

Mentoring

Cross-functional collaboration

Tools

Azure Databricks

Job description

• Lead QA strategy for ETL and Data Warehouse testing on Azure
• Design and execute test cases for data ingestion, transformation, and storage
• Perform functional, integration, and regression testing
• Validate data accuracy and reconciliation using advanced SQL queries
• Implement automated data testing using Python and PySpark
• Perform hands‑on testing for pipelines built on Azure Databricks
• Collaborate with cross‑functional teams including data engineers and product owners
• Manage defects, test execution, and reporting activities
• Drive continuous improvement in QA processes and automation
• Provide mentoring and technical guidance to QA team members