Data Engineer Senior Consultant

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 new waves are onboarded.
. Collaborate with Data Engineers to clarify expected outputs and resolve issues.