Data Migration Test Analyst

1 month 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

Senior QA Engineer - AI/ML

Finite State 51-250 Internet Software & Services

Finite State is hiring a Singapore-based QA Engineer / Senior QA Engineer to validate an AI-powered SaaS platform for product security teams, with a focus on improving the quality, reliability, security, and release confidence of complex full-stack workflows.

CI/CD Cybersecurity Cypress Docker Git JavaScript Machine Learning Playwright Postman Pytest Python REST API Selenium TypeScript
2 hours, 15 minutes ago

Performance Analyst

Ibility 1-10 Professional Services

Ibility is seeking a remote Performance Analyst to support federal healthcare technology testing by translating user performance needs into testable system requirements and documenting testing outcomes for stakeholders.

Agile Azure CI/CD JIRA
2 hours, 31 minutes ago

Quality Assurance Engineer (Manual)

Emerging Travel Group 251-1K Consumer Services

QA Engineer role on the Extranet team at a company building direct hotel connectivity services and a partner management panel, focused on maintaining quality for identity verification, virtual credit card payments, and two-factor authentication features.

Microservices Postman Python Selenium SQL Unix
2 hours, 31 minutes ago

Quality Assurance Monitoring and Testing Analyst

BHG Financial 1K-5K Diversified Financial Services

CCMR3 is hiring a remote Quality Assurance Monitoring and Testing Analyst to evaluate operational controls, support compliance oversight, and drive process improvement within its debt recovery operations.

2 hours, 31 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