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