Senior Data Validation and DBT Engineer

NTT DATA Global Delivery Services Ltd; Bengaluru; On-site; INR 1,600,000 - 2,400,000; Full time

Job summary

NTT DATA Global Delivery Services Ltd in Bengaluru seeks a Senior Technical Data Validation & DBT Engineer to lead SIT and data validation for the Data Warehouse Modernization program. You will validate migrated pipelines, perform source-to-target reconciliation, and work with development teams to accelerate defect resolution.

The role requires DBT, Snowflake, ETL concepts, SQL reconciliation, and experience with Informatica workflows.

Qualifications

• 7+ years in Data Warehouse/ETL/Data Validation.
• Strong knowledge of SQL-based validation and DBT.
• Experience with SIT and defect analysis.

Responsibilities

• 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.
• 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.
• Maintain validation documentation, reconciliation reports, and testing evidence.

Skills

DBT

Snowflake

SQL

ETL Testing

Informatica

Data Validation

SIT

Root Cause

Defect Triage

Migration

Data Lineage

Tools

Informatica

DBT

Snowflake

Azure DevOps

Job description

Sr Tech Data Validation & DBT Engineer 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

Experience Level Senior Level