Engineering

Sr Tech Data Validation & DBT Engineer

NTT DATA India

  • Bengaluru, Karnataka
  • Onsite

Posted 21 Oct 2026

About this role

Senior Technical Data Validation & DBT Engineer (ETL Modernization) The Senior Technical Data Validation Engineer will play a critical role during System Integration Testing (SIT) for the Data Warehouse Modernization Program.

The role is responsible for validating migrated data pipelines, performing source-to-target reconciliation, identifying root causes of data discrepancies, and partnering with development teams to accelerate defect resolution.

The ideal candidate should possess strong expertise in DBT, Snowflake, ETL/Data Warehouse concepts, SQL-based reconciliation, and legacy Informatica workflows, with the ability to independently analyze complex data issues and provide actionable defect diagnostics.

Roles & Responsibilities

Data Validation & SIT Support

  • Perform end-to-end source-to-target data validation across Informatica and DBT-based implementations.
  • Validate data completeness, accuracy, transformations, aggregations, and business rules across staging, core, and mart layers.
  • Execute record count, aggregate, reconciliation, SCD, and incremental-load validation.
  • Analyze data discrepancies and identify root causes before routing defects to development teams.
  • Prepare SQL evidence, impacted records, and detailed defect diagnostics to improve defect quality and reduce turnaround time.
  • Participate in SIT defect triage sessions and collaborate with development teams to accelerate issue resolution.
  • Validate data lineage and trace data flow across source systems, DBT models, and Snowflake objects. DBT & Data Engineering Support
  • Translate Informatica mappings, transformations, and business rules into DBT models where required.
  • Develop and maintain DBT tests (schema tests, custom tests, data-quality validations).
  • Design and implement staging, core, and mart layers using DBT best practices.
  • Participate in performance analysis and optimization of DBT models and Snowflake queries.
  • Support deployment validation and migration activities across environments. Quality & Governance
  • Contribute to SIT strategy, test case reviews, and validation frameworks.
  • Ensure defects are documented with clear root-cause analysis, business impact, and remediation recommendations.
  • Support regression testing and release validation activities.
  • Maintain validation documentation, reconciliation reports, and testing evidence. Experience & Skills
  • 7+ years of experience in Data Warehouse, ETL, Data Engineering, or Data Validation.
  • 2+ years of hands-on experience with DBT (Core or Cloud).
  • Strong experience in Data Warehouse Migration / Modernization programs.
  • Experience supporting SIT or large-scale data validation initiatives.
  • Developer-level understanding of Informatica mappings, workflows, and transformations.
  • Experience working with Snowflake and modern cloud data platforms.
  • Good communication skills and ability to read/understand existing ETL logic and requirements documentation. Must Have: 1) Strong Knowledge of
  • Advanced SQL
  • ETL/Data Warehouse testing
  • Source-to-target data validation
  • dbt knowledge
  • Snowflake
  • Data Mapping
  • Source-to-Target-Validation
  • Complex joins and transformation validation
  • Count/Aggregate/SCD/incremental-load validation
  • Incremental Load Validation
  • Defect analysis and root-cause analysis
  • Financial reconciliation 2) SIT & Defect Analysis
  • Root Cause Analysis
  • Defect Triage & Debugging
  • SIT Execution Support
  • Test Data Analysis
  • Reconciliation Reporting
  • Business Rule Validation Strongly Preferred
  • Databricks
  • Azure DevOps or similar CI/CD tools
  • dbt test automation
  • Python for Data Validation
  • Data-validation automation frameworks/tools
  • Experience with large-scale ETL modernization

Before you apply

Company Jobs India lists this vacancy from the employer's official careers website. Apply only on that website. Genuine employers do not ask for a fee, deposit, OTP or bank details to give you an interview or an offer letter.

Skills

Software & ItCommunicationDocumentationEngineering

Role details

Work mode
Onsite
Job functions
Engineering
Application method
Continue to the employer’s application website

Listed from NTT DATA India’s official careers website · last checked 17 Nov 2026.

Employer

NTT DATA India

View the company profile and its current opportunities.

Company profile