ADF and Testing Lead

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:

o    Data validation

o    Transformation testing

o    Reconciliation testing

o    Source-to-target testing

o    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:

o    dbt tests

o    snapshots

o    SQL-based transformation validation

o    model validation

o    lineage verification

·         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.