- 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.