Senior Data Migration Test Engineer
NTT DATA Global Delivery Services Ltd
Work from Office
Full Time
Min. 8 yearsJob Description
Senior BA / QA
Senior BA / QA
Role Overview
The Senior Test Engineer serves as the quality owner for the Informatica-to-dbt migration, responsible for defining and overseeing the end-to-end testing strategy across Extract, Load, and Transform layers. This role ensures data is landed accurately from source systems using Python-based ingestion and that dbt transformations meet functional equivalence with legacy Informatica outputs. The Senior Test Engineer provides test leadership across multiple migration waves and parallel business units (SWP and IMS), while mentoring Test Engineers and coordinating closely with Technical Leads and SMEs.
Key Responsibilities
Define the overall test strategy, test approach, and validation framework for EL and dbt Transform components.
Establish testing standards, reusable test cases, and automation patterns where applicable.
Validate Python-based extract/load processes for:
Row counts
Schema alignment
Data completeness
Data type consistency
Oversee dbt transformation validation, including:
Pre- vs post-migration data reconciliation
Aggregation and business rule validation
Incremental and full-load behavior
Review and approve test execution results and defect triage.
Coordinate testing activities across SWP and IMS migration waves.
Partner with Informatica SMEs to understand legacy validation logic and expected outputs.
Support SIT, UAT cycles, and production release readiness.
Provide reporting on test progress, defect trends, and release quality metrics.
Required Skills & Experience
8+ years of data testing experience in large-scale data migration or ETL programs
Strong SQL skills (Oracle, SQL Server, or similar RDBMS)
Experience validating ETL/ELT pipelines and transformations
Familiarity with dbt testing concepts (schema tests, data tests preferred)
Experience testing Python-based data pipelines
Strong understanding of reconciliation techniques and data validation frameworks
Prior experience working in offshore delivery models
Experience Level
Senior LevelJob role
Job requirements
About company
Similar jobs you can apply for
Civil Engineer / ArchitectCivil Design Engineer
Annciya EstatesWork from OfficeFull TimeMin. 1 year
Good (Intermediate / Advanced) EnglishQA / QC Executive
Sidra Tech SolutionsWork from OfficeFull TimeMin. 1 yearGood (Intermediate / Advanced) EnglishFiber Field Engineer
Airtel
Field JobFull TimeAny experienceNo English RequiredDesign Engineer
Pentagon El - Mech Solutions Private LimitedWork from OfficeFull TimeMin. 1 yearBasic EnglishMechanical Design Engineer
Sri Bhuvan EnterprisesWork from OfficeFull TimeMin. 1 yearBasic English
Senior Project Manager
Shree Bhalchandra ServicesField JobFull TimeMin. 2 yearsBasic EnglishYou can expect a minimum salary of 0 INR. The salary offered will depend on your skills, experience and performance in the interview.
The candidate should have completed the required education and people who have 8 to 31 years are eligible to apply for this job. You can apply for more jobs in Bengaluru/Bangalore to get hired quickly.
The candidate should have sound communication skills and sound communication skills for this job.
Both Male and Female candidates can apply for this job.
No, it's not a work from home job and can't be done online. You can explore and apply for other work from home jobs in Bengaluru/Bangalore at apna.
No work-related deposit needs to be made during your employment with the company.
Go to the apna app and apply for this job. Click on the apply button and call HR directly to schedule your interview.
The last date to apply for this job is . For more details, download apna app and find Full Time jobs in Bengaluru/Bangalore . Through apna, you can find jobs in 64 cities across India. Join NOW!