Data Migration Test Analyst

Job Title: Data Migration Test Analyst
Location: Remote Work
Type: 12 weeks
Notice: Immediate joiner or 15 Days Notice
Salary: 1.25 lakhs per month

Job Summary

We are seeking an experienced Data Migration Test Analyst to support and validate the migration of ETL workflows from Pentaho Data Integration to Informatica Cloud Data Integration (CDI). This role is responsible for ensuring data accuracy transformation integrity and functional parity between legacy Pentaho jobs and newly developed Informatica CDI pipelines with a strong emphasis on SQL-based validation and scripting.

Key Responsibilities

Migration Testing & Validation

Design and execute test strategies test plans and test cases for data migration from Pentaho to Informatica CDI

Validate end-to-end data flows including source-to-target mappings transformations aggregations and business rules

Ensure migrated Informatica CDI jobs deliver functional equivalence or improvement over existing Pentaho workflows

Data Reconciliation & SQL Validation

Develop and execute complex SQL queries to validate row counts aggregations joins filters and transformations

Perform data reconciliation between legacy Pentaho outputs and Informatica CDI target tables

Identify analyze and document data discrepancies and root causes

ETL & Workflow Testing

Test Informatica CDI mappings taskflows schedules and dependencies

Validate exception handling error logging and restartability of pipelines

Ensure performance and scalability meet or exceed legacy standards

Defect Management & Collaboration

Log track and retest defects using defect tracking tools (e.g. Jira Azure DevOps)

Collaborate with ETL developers data engineers DBAs and business stakeholders

Provide clear actionable feedback to development teams

Documentation & Reporting

Create and maintain test artifacts including test cases test results data validation reports and sign-off documents

Provide regular status updates and testing metrics to project leadership

Technical Skills

Strong experience testing ETL / ELT and data warehouse solutions

Hands-on testing experience with Pentaho Data Integration (PDI) and/or Informatica Cloud Data Integration (CDI)

Advanced SQL scripting skills (joins subqueries window functions aggregates)

Experience validating data across relational databases (e.g. Oracle SQL Server PostgreSQL Snowflake etc.)

Understanding of data integration concepts: source-to-target mapping transformations lookups slowly changing dimensions

Note: If interested please send your updated resume to

Please include your rate/Salary requirement along with your contact details with a suitable time when we can reach you.

Referrals are welcome

Required Experience:

IC