Role & seniority: Offshore Test Engineer (Test Engineer), mid-level (3–5 years)

Stack/tools: Python-based ETL pipelines, dbt transformations, SQL for reconciliation, data validation and logs; familiarity with Informatica outputs; Agile/wave-based delivery

Top 3 responsibilities

Execute test cases for Python ETL processes; validate record counts, field-level data accuracy, schema/data types
Validate dbt transformations via SQL reconciliation queries; compare legacy Informatica outputs with dbt results
Log, track, re-test defects; support SIT/UAT across migration waves; maintain artifacts and assist in regression testing; collaborate with Data Engineers

Must-have skills

3–5 years in data/ETL testing
Strong SQL querying and data validation across pipelines/transformations
Basic familiarity with Python-based data pipelines and ETL/ELT concepts
Experience with Agile or wave-based delivery models

Nice-to-haves

Experience validating Informatica workflows and legacy outputs
Advanced data reconciliation techniques and broader data tooling exposure
Location & work type: Bangalore, Karnataka, India; Offshore role with potential remote/hybrid arrangements depending on client requirements

Full Description

Req ID: 355870 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.