Data Migration Test Analyst

TWO95 International, Inc; India; On-site; INR 1,116,000 - 1,674,000; Full time

Job summary

TWO95 International, Inc is seeking a Data Migration Test Analyst to support the migration of ETL workflows from Pentaho to Informatica CDI. The analyst will ensure data accuracy and transformation integrity throughout the process, using advanced SQL scripting for validation. This remote contract position of 12 weeks may extend based on project needs. Ideal candidates will have strong ETL testing experience and familiarity with data integration concepts across various relational databases.

Qualifications

• Strong experience testing ETL / ELT solutions.
• Hands-on experience with Pentaho and/or Informatica.
• Advanced SQL scripting skills for data validation.

Responsibilities

• Support and validate migration of ETL workflows.
• Ensure data accuracy and transformation integrity.
• Validate functional parity between legacy and new pipelines.

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

Experience validating data across relational databases

Understanding of data integration concepts

Job description

Data Migration Test Analyst – Pentaho to Informatica CDI

Job Title: Data Migration Test Analyst – Pentaho to Informatica CDI

Location: Remote Work

Type: Contract (12 weeks possibly longer bc they could roll into another of our clients when the first client project is complete )

Salary: 1-1.5lakhs

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.

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