Role & seniority: Offshore Test Engineer (mid-level, 3–5 years in data/ETL testing)

Stack/tools: Python-based ETL pipelines; dbt transformation validation; SQL for reconciliation; data pipelines and Informatica output comparison; agile/wave-based delivery

Top 3 responsibilities

Execute test cases for Python-based extract/load processes; validate record counts, field-level data accuracy, schema/data-type consistency
Perform dbt validation via SQL reconciliation queries; compare legacy Informatica outputs with dbt results
Log, track, and re-test defects; support SIT/UAT across migration waves; maintain artifacts and assist regression testing; collaborate with Data Engineers
Must-have skills: 3–5 years in data/ETL testing; strong SQL querying; experience validating data pipelines and transformations; basic familiarity with Python-based data pipelines; understanding of ETL/ELT concepts and data reconciliation; experience in Agile/wave-based delivery
Nice-to-haves: Experience with dbt and Informatica outputs; advanced data reconciliation techniques; exposure to multi-wave migration programs
Location & work type: Bangalore, Karnataka, India; Offshore role; hybrid/onsite requirements subject to client needs and project schedule

Full Description

Req ID: 355865 NTT DATA strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now. We are currently seeking a Offshore Test Engineer to join our team in Bangalore, Karnātaka (IN-KA), India (IN). Test Engineer Role Overview The Test Engineer is responsible for executing test cases and validating data accuracy for Python-based extract/load pipelines and dbt transformation models. This role focuses on hands-on testing activities to ensure data is landed as-is from source systems and that transformed outputs align with expected business logic derived from Informatica workflows. The Test Engineer works under the guidance of the Senior Test Engineer and Technical Leads to support wave-based migration delivery for SWP and IMS. Key Responsibilities

· Execute test cases for Python-based extract/load processes, validating

o Record counts
o Field-level data accuracy
o Schema and data type consistency
· Perform dbt transformation validation using SQL-based reconciliation queries.
· Compare legacy Informatica outputs with dbt-generated results based on agreed criteria.
· Log, track, and re-test defects through resolution.
· Support SIT and UAT test cycles across multiple migration waves.
· Maintain test artifacts, evidence, and execution logs.
· Assist in regression testing as new waves are onboarded.
· Collaborate with Data Engineers to clarify expected outputs and resolve issues.
Required Skills & Experience
· 3–5 years of experience in data testing or ETL testing roles
· Strong SQL querying skills
· Experience validating data pipelines and transformations
· Basic familiarity with Python-based data pipelines (reading logs, outputs)
· Understanding of ETL/ELT concepts and data reconciliation techniques
· Experience working in Agile or wave-based delivery models
About NTT DATA
NTT DATA is a $30 billion business and technology services leader, serving 75% of the Fortune Global 100. We are committed to accelerating client success and positively impacting society through responsible innovation. We are one of the world's leading AI and digital infrastructure providers, with unmatched capabilities in enterprise-scale AI, cloud, security, connectivity, data centers and application services. our consulting and Industry solutions help organizations and society move confidently and sustainably into the digital future. As a Global Top Employer, we have experts in more than 50 countries. We also offer clients access to a robust ecosystem of innovation centers as well as established and start-up partners. NTT DATA is a part of NTT Group, which invests over $3 billion each year in R&D.