ETL​/Data Warehouse Tester

Position: ETL/ Data Warehouse Tester
Role:
Lead QA Engineer – ETL & Data Warehouse Testing

Experience:

8+ Years

Location:

Pune, Gurgaon, Noida, Bangalore, Hyderabad
Work Mode:
Hybrid

Summary:

We are seeking an experienced Lead QA Engineer – ETL & Data Warehouse Testing with strong expertise in AWS-based data platforms. The candidate will be responsible for leading QA strategy, ensuring data accuracy, integrity, and reliability across enterprise-scale data pipelines and analytics systems.

Key

Role and Responsibilities:

▪ Lead end-to-end ETL and Data Warehouse testing activities
▪ Define and implement QA strategies, test plans, and test cases
▪ Perform functional, integration, regression, and system testing
▪ Validate data ingestion, transformation, and aggregation processes
▪ Execute complex SQL queries to reconcile source and target data
▪ Develop and execute automated data validation using Python and Py Spark
▪ Collaborate with data engineers, architects, and business stakeholders
▪ Track defects, manage test cycles, and report quality metrics using Jira
▪ Ensure compliance with data quality standards and best practices
▪ Mentor QA team members and provide technical leadership

Technical Proficiency:
▪ Strong experience in ETL & Data Warehouse Testing
▪ Solid understanding of Functional Testing methodologies
▪ Hands-on experience with AWS Services (mandatory)
▪ Advanced proficiency in SQL
▪ Python + PySpark – Intermediate level
▪ Experience using Jira for defect tracking and test management
▪ Understanding of data modeling concepts (fact/dimension tables, star/snowflake schemas)
▪ Strong analytical and problem-solving skills

Education:

Bachelor’s degree in computer science, Software Engineering, MIS or equivalent combination
of education and experience