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 PySpark

▪ 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