Roadmap › 2. Database, ETL & BI › Step 30
ETL
ETL & Data Warehousing Concepts
ETL vs ELT, staging, full vs incremental loads, change data capture, slowly changing dimensions, star and snowflake schemas, fact and dimension tables, data quality, error handling, orchestration and modern cloud data platforms.
Interview priority:★ Must know High priority — asked in almost every interview, learn firstMedium asked regularlyLow good to know
Module 1: Fundamentals
- 1.What ETL is and why it is neededBasic ★ Must know
- 2.Full load vs incremental (delta) loadBasic ★ Must know
- 3.Staging area and the medallion architectureBasic ★ Must know
- 4.Common transformationsBasic Medium
Module 2: Dimensional Modelling
- 5.Facts, dimensions, star and snowflake schemasIntermediate ★ Must know
- 6.Types of facts and dimensionsIntermediate ★ Must know
- 7.Slowly Changing Dimensions (SCD)Intermediate ★ Must know
- 8.Inmon vs Kimball, data marts, data lakes and lakehousesIntermediate Medium
Module 3: Building Reliable Pipelines
- 9.Error handling, logging, auditing and restartabilityIntermediate ★ Must know
- 10.Data qualityIntermediate ★ Must know
- 11.Performance of large loadsAdvanced Medium
- 12.Orchestration and schedulingIntermediate Medium
Next course in the roadmap: 31. SSIS — SQL Server Integration Services →