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: Bachelors degree in computer science, Software Engineering, MIS or equivalent combination

of education and experience