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