Job highlights

- 10+ years in Data Warehouse and ETL Testing with expertise in Azure Data Factory and dbt
- Lead end-to-end data testing strategy for EDW migration, design automated validation frameworks, manage testing teams, and coordinate SIT, UAT, and regression testing

Dear All, We are hiring for the below demand on high priorty. Kindly share suitable profiles matching the below requirements.

Skills Azure Data Factory + Testing

Exp 9-12 years

: Data Test Lead

Key Responsibilities

- Define and lead the end-to-end data testing strategy for large-scale EDW migration programmes from legacy ETL platforms to cloud-native architectures.
- Drive source-to-target reconciliation, parallel testing, and transformation validation to ensure Azure Data Factory and dbt outputs align with existing Ab Initio processing logic and business rules.
- Design, develop, and automate robust data validation frameworks using:
- dbt testing capabilities
- SQL-based reconciliation techniques
- ADF validation activities
- Custom validation and audit frameworks
- Validate complex transformation logic, aggregations, business rules, and dimensional models across staging, curated, and reporting layers.
- Lead and mentor distributed QA and testing teams across onsite and offshore delivery models.
- Coordinate SIT, UAT, regression, reconciliation, and production validation activities.
- Track test execution progress, defect management, data quality KPIs, and testing metrics for stakeholder and programme reporting.
- Build reusable frameworks for:
- Continuous data quality monitoring
- Automated reconciliation
- Data lineage validation
- Source-to-target validation
- Regression testing




- Collaborate closely with Data Architects, ETL Developers, Business Analysts, and Platform Teams to ensure successful migration delivery.
- Support root cause analysis and defect triage activities for data discrepancies and pipeline failures.
- Ensure adherence to enterprise governance, audit, compliance, and data quality standards.

Required Skills & Experience

- 10+ years of experience in Data Warehouse and ETL Testing, including leadership responsibilities.
- Strong understanding of ETL/ELT concepts and legacy-to-cloud migration testing methodologies.
- Extensive experience in:
- Data validation
- Transformation testing
- Reconciliation testing
- Source-to-target testing
- Data quality assurance
- Strong knowledge of Ab Initio components and validation of graphs, mappings, and processing workflows.
- Experience testing Azure Data Factory pipelines, orchestration flows, and metadata-driven frameworks.
- Hands-on expertise in dbt including:
- dbt tests
- snapshots
- SQL-based transformation validation
- model validation
- lineage verification
- Advanced SQL expertise with modern cloud databases such as Snowflake.
- Robust understanding of dimensional modelling and enterprise data warehousing concepts.
- Experience with defect management and test management tools such as JIRA, Azure DevOps, or equivalent.
- Strong stakeholder management, communication, and leadership capabilities.

Share the below details :

Name

Exp

Rel Exp

C lo

P Loca

CTC

ExpCTC

LWD / NP

Freelancing done

slot for L1 Discussion:

Reach to "[email protected] "or (phone hidden)

Regards,

Sandhya Shree Srinivasan

TAG Hexaware

📌 Azure Data Factory + Testing (Chennai)
🏢 Hexaware Technologies
📍 Chennai