Data Migration Test Analyst

49 minutes ago
Contract
Senior
Data Science and Analytics
TWO95 International

TWO95 International

TWO95 International is a global technology firm that specializes in providing comprehensive enterprise solutions, including BPM, Mobility, Cloud, Analytics, E-commerce, and Social Business, while also focusing on emerging technologies such as Generativ...

Internet Software & Services
51-250
Founded 2009

Description

  • 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.
  • 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.
  • Test Informatica CDI mappings, taskflows, schedules, and dependencies.
  • Validate exception handling, error logging, and restartability of pipelines.
  • Log, track, and retest defects using defect tracking tools such as Jira or Azure DevOps.
  • Collaborate with ETL developers, data engineers, DBAs, and business stakeholders.
  • 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.

Requirements

  • 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, including joins, subqueries, window functions, and aggregates.
  • Experience validating data across relational databases such as Oracle, SQL Server, PostgreSQL, or Snowflake.
  • Understanding of data integration concepts, including source-to-target mapping, transformations, lookups, and slowly changing dimensions.
  • Experience working with defect tracking tools such as Jira or Azure DevOps is preferred.
  • Ability to support an immediate joiner or join within 15 days.
  • Availability for a 12-week remote engagement.
  • Salary expectation of 1.25 lakhs per month.
  • Updated resume, contact details, and salary/rate requirement must be shared for consideration.

Benefits

  • Remote work arrangement.
  • 12-week contract engagement.
  • Salary of 1.25 lakhs per month.
  • Immediate joining or short notice period considered.

Interested in this position?

Apply directly on the company website

Apply Now

Similar Roles

Perceived Quality (PQ) Visualization Assessor

ALTEN Technology 251-1K Construction & Engineering

ALTEN Technology USA is seeking a PQ Visualization Assessor to create photo-realistic vehicle visualizations that support perceived quality assessments and cross-functional design reviews throughout the product lifecycle.

4 minutes ago

QC Manager, Home Textiles

Quince 51-250 Textiles, Apparel & Luxury Goods

Quince is hiring a QC Manager, Home Textiles to oversee quality control operations for home textile products across a global manufacturing supply chain.

4 minutes ago

QC Manager, Hardlines

Quince 51-250 Textiles, Apparel & Luxury Goods

Quince is hiring a QC Manager, Hardlines to oversee factory audits, inspections, and quality standards for hardgoods across its global supply chain.

19 minutes ago

Instrumentation Analyst

Rush Street Interactive 251-1K Hotels, Restaurants & Leisure

Rush Street Interactive is hiring an Instrumentation Analyst to define, govern, and validate client-side event tracking across its web and mobile gaming products, ensuring reliable data for measurement, reporting, and activation.

34 minutes ago

You're on a roll! Sign up now to keep applying.

Sign Up

Already have an account? Log in

Used by 14,729+ remote workers