Data Migration Test Analyst

Remote Work; Bengaluru, Karnataka, India. Chennai, Tamil Nadu, IndiaContract

Salary125,000 INR per year

Apply NowOpens the employer's application page

Job Details

Required Skills: PostgreSQLETLMicrosoft SQL ServerOracleSnowflakeJiraAzure DevOps

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

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
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
Test Informatica CDI mappings, taskflows, schedules, and dependencies
Log, track, and retest defects using defect tracking tools (e.g., Jira, Azure DevOps)
Create and maintain test artifacts, including test cases, test results, data validation reports, and sign-off documents

View Full Description & ApplyYou'll be redirected to the employer's site