Systems Integration Senior Specialist

NTT DATA North America; Bengaluru; On-site; INR 1,100,000 - 1,800,000; Full time

Job summary

NTT DATA in Bengaluru, India seeks an experienced Systems Integration Senior Specialist for ETL/ELT data testing and quality assurance across cloud data platforms. The candidate will validate end-to-end data pipelines, transformations, lineage and data quality with Snowflake, dbt, and Fivetran.

The role requires 7+ years of hands-on testing experience, strong SQL, and proven collaboration with data engineers, analytics engineers, and stakeholders. Remote/hybrid options may be available.

Qualifications

• 7+ years of ETL/ELT testing, data warehouse testing, or data quality testing.
• Strong SQL for data validation and reconciliation.
• Experience with Snowflake as a cloud data warehouse.
• Experience testing dbt data models and quality checks.
• Experience with Fivetran or similar ingestion tools (Airbyte, Matillion, etc.).
• Knowledge of data warehousing concepts and dimensional modeling.
• Familiarity with Agile/Scrum practices.
• Experience with defect tracking tools (Jira/Azure DevOps/TestRail).
• Strong analytical, troubleshooting, and communication skills.

Responsibilities

• Design, develop, and execute test plans for ETL/ELT pipelines.
• Validate source-to-target mappings and data lineage.
• Perform data reconciliation, completeness, accuracy, and integrity checks.
• Test data ingestion pipelines with Fivetran or similar tools.
• Validate dbt transformations, incremental models, and tests.
• SQL-based validation of Snowflake data, including large datasets.
• Log, track, and retest data defects with stakeholders.
• Develop automated data validation and regression tests where applicable.
• Validate error handling and audit/recovery mechanisms.
• Support multiple validation testing phases (integration, regression, UAT, production).
• Review requirements and data models to identify test scenarios.
• Monitor data quality issues and perform root-cause analysis.
• Ensure test evidence and defect documentation are maintained.

Skills

ETL/ELT testing

Data validation

SQL

Snowflake

dbt

Fivetran

Agile/Scrum

Communication

Analytical thinking

Tools

Airflow

Git

Job description

Job Description:

Req ID: 390775

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,

We are currently seeking a Systems Integration Senior Specialist to join our team in bengaluru, Karnātaka (IN-KA), India (IN).

Role Overview

We are seeking an experienced ETL Tester / Data Quality Engineer with 7+ years of hands‑on experience testing data transformation and data integration solutions. The ideal candidate will have strong expertise in validating end‑to‑end data pipelines, transformation logic, data quality, and reconciliation across modern cloud data platforms, particularly Snowflake, dbt, and Fivetran or comparable tools.

Key Responsibilities

• Design, develop, and execute test plans, test cases, and test scripts for ETL/ELT and data transformation pipelines.
• Validate source-to-target data mappings, transformation rules, business logic, and data lineage.
• Perform data reconciliation, completeness, accuracy, consistency, duplication, and referential-integrity checks.
• Test data ingestion pipelines built using Fivetran or similar integration tools.
• Validate data transformations and models developed in dbt, including incremental models, snapshots, macros, tests, and dependencies.
• Perform SQL-based validation of data stored in Snowflake, including large-volume datasets and complex transformations.
• Identify, log, track, and retest data defects in collaboration with data engineers, analytics engineers, developers, and business stakeholders.
• Develop and maintain automated data validation and regression test frameworks where applicable.
• Validate error handling, exception processing, rerun/recovery mechanisms, and audit/control tables.
• Support integration, system, regression, user acceptance, and production validation testing.
• Review requirements, source-to-target mapping documents, data models, and technical design documents to identify test scenarios.
• Monitor data quality issues and provide root‑cause analysis support.
• Ensure test evidence, execution reports, and defect documentation are complete and maintained.

Required Skills & Qualifications

• 7+ years of experience in ETL/ELT testing, data warehouse testing, or data quality testing.
• Strong hands‑on experience writing complex SQL queries for data validation and reconciliation.
• Experience working with Snowflake as a cloud data warehouse.
• Experience testing dbt data models, transformations, schema tests, and data quality checks.
• Experience with Fivetran or similar data ingestion/integration tools such as Airbyte, Matillion, Informatica Cloud, Stitch, Talend, or AWS Glue.
• Strong understanding of data warehousing concepts, dimensional modeling, star/snowflake schemas, facts, and dimensions.
• Experience validating batch and incremental data loads.
• Knowledge of ETL/ELT concepts, source-to-target mapping, CDC, SCD types, and data lineage.
• Experience with defect tracking and test management tools such as Jira, Azure DevOps, TestRail, or similar.
• Familiarity with Agile/Scrum delivery methodologies.
• Strong analytical, troubleshooting, and communication skills.

Preferred Skills

• Experience with Python or PySpark for test automation and data validation.
• Experience with orchestration tools such as Airflow, Azure Data Factory, Dagster, or Prefect.
• Knowledge of cloud platforms such as AWS, Azure, or GCP.
• Familiarity with CI/CD pipelines, Git, and automated dbt deployment processes.
• Experience with data observability or data quality tools such as Great Expectations, Soda, Monte Carlo, or equivalent.
• Experience testing BI/reporting layers such as Power BI, Tableau, Looker, or Sigma.

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

Whenever possible, we hire locally to NTT DATA offices or client sites. This ensures we can provide timely and effective support tailored to each client’s needs. While many positions offer remote or hybrid work options, these arrangements are subject to change based on client requirements. For employees near an NTT DATA office or client site, in‑office attendance may be required for meetings or events, depending on business needs. At NTT DATA, we are committed to staying flexible and meeting the evolving needs of both our clients and employees. NTT DATA recruiters will never ask for payment or banking information and will only use @nttdata.com, @nttdatafed.com and @talent.nttdataservices.com email addresses. If you are requested to provide payment or disclose banking information, please submit a contact us form, https://us.nttdata.com/en/contact-us.

NTT DATA endeavors to make https://us.nttdata.com accessible to any and all users. If you would like to contact us regarding the accessibility of the website or need assistance completing the application process, please contact us at https://us.nttdata.com/en/contact-us.

This contact information is for accommodation requests only and cannot be used to inquire about the status of applications. NTT DATA is an equal opportunity employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status. For our EEO Policy Statement, please click here. If youd like more information on your EEO rights under the law, please click here. For Pay Transparency information, please click here.

Requirements: