Job Description

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

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 Power Center 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





- Solid 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 Power Center 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.

Requirements
**Mandatory Skills:** Informatica Power Center, Power Center Workflows, Sessions, Mappings, Worklets, Mapplets, Parameter Files, Workflow Variables, Lookup, Joiner, Aggregator, Router, Expression, Update Strategy, Sequence Generator, Stored Procedure Transformation, Informatica Repository Metadata, Power Center Runtime/Session Troubleshooting, ETL/Data Integration, Power Center Migration/Modernization, Migration Assessment, Workload Complexity Assessment, Batch Scheduling, Dependencies, Restart/Recovery, Data Reconciliation, Cloud Data Integration, Snowflake/Cloud Data Platform Exposure

📌 Data Migration Test Automation Engineer (India)
🏢 Latent Bridge
📍 India