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