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 workplace 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.

📌 QA Lead /Senior QA Engineer DTH / DataHub Cloud Migration (Pune)
🏢 Delivery Centric Technologies
📍 Pune