Location
toronto
Job Type
Full-time
Posted
June 06, 2026
Job Description
Responsibilities
Full load vs Incremental / Delta load testing Late Arriving Dimensions, Out-of-sequence data Advanced SQL skills Complex joins, subqueries, window functions Data reconciliation & cross-layer balancing Duplicate, null, referential integrity checks Core Skills (Must Have)
Strong Data Warehousing & EDW concepts Fact & Dimension modeling Star / Snowflake schemas Data marts and reporting layers Hands-on EDW testing experience Source → Staging → Integration → Presentation layer validation Full load vs Incremental / Delta load testing SCD validation expertise SCD Type 1, Type 2 (history, effective dates, current flag) Late Arriving Dimensions, Out-of-sequence data Advanced SQL skills Complex joins, subqueries, window functions Data reconciliation & cross-layer balancing Duplicate, null, referential integrity checks Testing Capabilities
Data Validation & Reconciliation Business rule & transformation logic validation Row count, aggregation, threshold ...
Full load vs Incremental / Delta load testing Late Arriving Dimensions, Out-of-sequence data Advanced SQL skills Complex joins, subqueries, window functions Data reconciliation & cross-layer balancing Duplicate, null, referential integrity checks Core Skills (Must Have)
Strong Data Warehousing & EDW concepts Fact & Dimension modeling Star / Snowflake schemas Data marts and reporting layers Hands-on EDW testing experience Source → Staging → Integration → Presentation layer validation Full load vs Incremental / Delta load testing SCD validation expertise SCD Type 1, Type 2 (history, effective dates, current flag) Late Arriving Dimensions, Out-of-sequence data Advanced SQL skills Complex joins, subqueries, window functions Data reconciliation & cross-layer balancing Duplicate, null, referential integrity checks Testing Capabilities
Data Validation & Reconciliation Business rule & transformation logic validation Row count, aggregation, threshold ...