Location
toronto
Posted
June 04, 2026
Commute
Local Area
Local Opportunity Near You!
This job is in your area. Enjoy a short commute and work close to home.
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