QA Engineer – ETL & Data Warehouse Testing

Location: Pune / Hybrid

Experience: 4–7 Years

Relevant Experience: 3+ Years in ETL / Data Warehouse Testing

Industry: SaaS / Product Engineering

Availability: Immediate Joiners Preferred

Role Overview

We are looking for a QA Engineer with strong ETL and Data Warehouse Testing experience to validate data accuracy, transformation, and quality across source systems, ETL pipelines, data warehouses, and reporting layers.

Key Responsibilities

Perform ETL and Data Warehouse testing across source, staging, and warehouse layers.
Write and execute complex SQL queries for data validation and reconciliation.
Validate data accuracy, completeness, duplicates, nulls, transformations, and business rules.
Test Fact/Dimension tables and SCD Type 1/2/3.
Validate full, incremental, Delta/CDC data loads.
Perform source-to-target mapping and reconciliation.
Validate BI reports/dashboards against warehouse data.
Create test cases, track defects, and perform retesting in Jira.
Support automation/data validation using Python or scripting.

Mandatory Skills

4–7 years QA experience, with 3+ years in ETL/DWH Testing.
Strong SQL skills – Joins, CTEs, Subqueries, Aggregations.
Strong understanding of Data Warehousing, Facts, Dimensions, and SCD.
Hands-on experience with at least one ETL tool – Informatica, SSIS, Talend, or ADF.
Experience with data validation and reconciliation.
Good understanding of STLC and Agile/Scrum.

Good to Have

Snowflake / Redshift / BigQuery / Databricks.
Python / Pytest / Pandas.
Power BI / Tableau testing.
Jenkins / Azure DevOps / Git.
BFSI, Healthcare, Retail, or Telecom domain experience.

Preferred Candidate: Strong hands-on QA professional with solid ETL + Data Warehouse + SQL experience.