Key Responsibilities
Execute test cases for Python-based extract/load processes, validating:
o Record counts o Field-level data accuracy o Schema and data type consistency
Perform dbt transformation validation using SQL-based reconciliation queries.
Compare legacy Informatica outputs with dbt-generated results based on agreed criteria.
Log, track, and re-test defects through resolution.
Support SIT and UAT test cycles across multiple migration waves.
Maintain test artifacts, evidence, and execution logs.
Assist in regression testing as current waves are onboarded.
Collaborate with Data Engineers to clarify expected outputs and resolve issues.