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) Solid 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

📌 Sr Tech Data Validation & DBT Engineer (Bengaluru)
🏢 NTT America
📍 Bengaluru