The role
Job description
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.