Azure Data Factory + Testing

Kaizen Sra Technologies; Hyderabad; On-site; INR 2,500,000 - 4,200,000; Full time

Job summary

Kaizen Sra Technologies is seeking a Data Test Lead with 9+ years of experience in data warehouse and ETL testing to define and lead end-to-end data testing for large-scale EDW migration programs.

You will drive source-to-target reconciliation, validation of Azure Data Factory and dbt outputs, and mentor distributed QA teams across onsite and offshore delivery, ensuring governance and data quality across staging, curated, and reporting layers.

Qualifications

• Minimum 10 years in Data Warehouse and ETL Testing with leadership experience.
• Experience in end-to-end cloud migration testing approaches.
• Strong SQL and data validation capabilities.
• Hands-on with Azure Data Factory and dbt testing.
• Proven ability to manage onsite and offshore teams and stakeholders.

Responsibilities

• Define and lead end-to-end data testing strategy for large-scale EDW migrations.
• Drive source-to-target reconciliation, parallel testing, and validation of Azure Data Factory and dbt outputs.
• Design, develop, and automate data validation frameworks using dbt tests, SQL reconciliations, and ADF validation.
• Validate transformations, aggregations, and dimensional models across layers.
• Lead distributed QA teams across onsite and offshore delivery models.
• Coordinate SIT, UAT, regression, reconciliation, and production validation activities.
• Track test execution, defects, data quality KPIs, and reporting.
• Build reusable frameworks for data quality monitoring, automated reconciliation, data lineage validation, and regression testing.
• Collaborate with Data Architects, ETL Developers, Business Analysts, and Platform Teams.
• Support root cause analysis for data discrepancies and ensure governance standards.

Skills

Data Warehouse Testing

ETL Testing

Leadership

SQL

Azure Data Factory

dbt Testing

Transformation Testing

Source-to-Target Testing

Data Quality

Stakeholder Management

Tools

JIRA

Azure DevOps

Ab Initio

dbt

Snowflake

Job description

Skills Azure Data Factory + Testing

Exp – 9+ years

Job Description: 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 Initiocomponents and validation of graphs, mappings, and processing workflows.
• Experience testing Azure Data Factorypipelines, orchestration flows, and metadata-driven frameworks.
• Hands-on expertise in dbtincluding:
  • dbt tests
  • snapshots
  • SQL-based transformation validation
  • model validation
• Advanced SQL expertise with modern cloud databases such as Snowflake.
• Strong 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.