Data Migration Test Analyst

Two95 International Inc.

Bengaluru, Karnataka, India Remote contract

Posted: May 8, 2026

Required Skills

Job Description

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

Requirements:
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 [email protected].

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

Referrals are welcome

Why Apply Through MisuJob?

AI-Powered Job Matching: MisuJob uses advanced artificial intelligence to analyze your skills, experience, and career goals. Our matching algorithm compares your profile against thousands of job requirements to find positions where you have the highest chance of success. This saves you hours of manual job searching and ensures you only see relevant opportunities.

One-Click Applications: Once you create your profile, applying to jobs is effortless. Your resume and cover letter are automatically tailored to highlight the most relevant experience for each position. You can apply to multiple jobs in minutes, not hours.

Career Intelligence: Beyond job matching, MisuJob provides valuable career insights. See how your skills compare to market demands, identify skill gaps to address, and understand salary benchmarks for your experience level. Make data-driven decisions about your career path.

Frequently Asked Questions

How do I apply for this position?

Click the "Register to Apply" button above to create a free MisuJob account. Once registered, you can apply with one click and track your application status in your dashboard.

Is MisuJob free for job seekers?

Yes, MisuJob is completely free for job seekers. Create your profile, get matched with jobs, and apply without any cost. We help you find your dream job without any hidden fees.

How does AI matching work?

Our AI analyzes your resume, skills, and experience to understand your professional profile. It then compares this against job requirements using natural language processing to calculate a match percentage. Higher matches mean better fit for the role.

Can I apply to jobs in other countries?

Absolutely. MisuJob features jobs from companies worldwide, including remote positions. Filter by location or look for remote opportunities to find jobs that match your preferences.

Ready to Apply?

Join thousands of job seekers using MisuJob's AI to find and apply to their dream jobs automatically.