QA Lead /Senior QA Engineer DTH / DataHub Cloud Migration

QA Lead / Senior QA Engineer DTH / DataHub Cloud Migration

Application: DTH / DataHub

Program: Enterprise Cloud Migration Initiative

Duration: Project Based (Migration Program)

Primary Skill Anchor: Informatica IICS / IDMC, ETL and data warehouse testing, SQL reconciliation, AWS data pipeline validation

Role Summary

Lead end-to-end quality assurance for the DTH cloud migration. The role will define the testing approach and validate functional parity, data integrity, batch stability, performance and operational readiness across Informatica-driven data pipelines and dependent systems.

Key Responsibilities

Test Strategy and Planning

• Develop the DTH migration test strategy, detailed test plan, quality gates and entry/exit criteria.
• Define functional, integration, regression, performance, data reconciliation, UAT and cutover validation approaches.
• Map test coverage to impacted Informatica domains, taskflows, connectors, batch schedules and downstream consumers.

ETL, Functional and Regression Testing

• Validate migrated IICS / IDMC taskflows, workflows and critical batch business processes.
• Validate business logic implemented within IICS / IDMC taskflows, workflows
• Perform impact analysis for connector, Secure Agent, configuration and environment changes.
• Execute smoke, functional, regression and restart/recovery scenarios.

Data Validation and Reconciliation

• Perform source-to-target comparisons across files, staging layers and downstream stores.
• Validate record counts, control totals, reference data, transformations, exceptions and data quality rules.
• Produce reconciliation evidence and track discrepancies through closure.

Integration and Non-Functional Testing

• Validate upstream/downstream interfaces, file transfers, schedules, Airflow orchestration and Redshift consumption.
• Coordinate test execution with application, platform, infrastructure and Oracle teams.
• Validate batch completion windows, SLA compliance, stability and processing bottlenecks.

Defect, Cutover and Hypercare Management

• Co-ordinate with Development Team for tracking and triaging of defects, risk reporting, quality metrics and release-readiness recommendations.
• Participate in dress rehearsals, production cutover and post-migration smoke validation.
• Support stabilization and co-ordination with Development Team for issue resolution during hypercare.

Required Skills and Experience

• 8+ years of QA / Test Engineering experience, including leadership of complex data-platform or cloud-migration testing.
• Strong hands-on experience in ETL and data warehouse testing.
• Hands-on Informatica IICS / IDMC testing experience.
• Advanced SQL skills for data reconciliation, exception analysis and database validation.
• Experience testing batch pipelines, taskflows, workflows, APIs and file-based integrations.
• Experience with functional, integration, regression, performance and UAT testing.
• Experience using defect/test management tools such as JIRA, ALM or Azure DevOps.
• Strong stakeholder communication, status reporting and risk-management skills.

Preferred Skills

• AWS exposure including EC2, S3 and cloud connectivity concepts.
• Informatica Secure Agent / EC2 Secure Agent migration experience.
• Airflow DAG/workflow validation and Redshift testing exposure.
• API testing using Postman or SoapUI.
• Performance testing using JMeter or LoadRunner.
• Financial services or asset management domain experience.

Key Deliverables

• Test Strategy, detailed Test Plan and requirements traceability matrix.
• Migration, regression, reconciliation, performance and cutover test packs.
• Daily/weekly test status, quality metrics and defect dashboard.
• Data Reconciliation Report and unresolved variance assessment.
• UAT sign-off support, Go-Live Readiness Assessment and Post-Migration Validation Report.

Success Criteria

• Zero open Sev-1 defects at go-live.
• 100% execution of agreed critical business process test cases.
• Successful reconciliation of in-scope migrated data, with all exceptions dispositioned.
• No critical batch or integration failures after cutover.

Business and stakeholder sign-off for DTH migration.