Data Migration Test Automation Engineer

This is a remote position.

Its a contractual role for 6 months

Role Purpose

We are looking for a data-focused test automation engineer who can build repeatable validation and reconciliation capabilities for workloads migrated from Informatica PowerCenter.

The objective is to reduce manual regression effort while maintaining confidence that migrated workloads produce functionally equivalent results.

Key Responsibilities

• Define migration testing and reconciliation strategy.

• Analyze existing PowerCenter workload outputs and expected results.

• Build automated source-versus-target validation.

• Automate:

• Row-count validation

• Schema validation

• Data-type validation

• Aggregate comparison

• Record-level reconciliation

• Null/default handling validation

• Duplicate detection

• Transformation-rule verification

• Create reusable migration test harnesses.

• Support regression testing across migration waves.

• Generate migration test evidence and exception reports.

• Support performance and batch-window validation.

• Identify opportunities to use AI/LLM capabilities to accelerate:

• test-case generation,

• mapping interpretation,

• reconciliation-rule generation,

• and exception analysis.

• Integrate automated validation into CI/CD where practical.

Required Skills

• Strong data testing and ETL testing experience.
• SQL.
• Python.
• Automated data reconciliation.
• ETL/data migration validation.
• Database and file comparison.
• Test automation frameworks.
• Understanding of batch-processing validation.
• Experience testing high-volume data pipelines.

Strongly Preferred

• Informatica PowerCenter testing experience.
• Snowflake testing experience.
• dbt testing.
• Experience developing migration reconciliation frameworks.
• Experience applying GenAI/LLMs to software or data testing.
• CI/CD experience.

Experience Level

6-10 years in data/ETL testing and automation.