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