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.