ETL / Datawarehouse QA

Job Title

Responsibilities

1. QA Strategy and Planning

Define QA strategy for a hybrid ETL stack involving Informatica, and dbt for transformation / modeling.

Analyze STTMs (Source-to-Target Mapping documents), business rules, and dbt model definitions to derive test scope.

Plan and manage test phases across Program Increments (PIs) or releases : unit testing support, system testing, and regression testing.

Collaborate with data engineers, data scientists, and product managers to understand data flows and requirements.

Develop and maintain test plans, test cases, and test scripts for data quality and ETL processes.

Conduct data validation and verification to ensure data integrity and accuracy.

Identify and report data quality issues and work with cross-functional teams to resolve them.