ETL Test Lead

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