Sr Tech Data Validation & DBT Engineer

Job description

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