Data modeling interview questions for data engineers
OLTP/OLAP, star/snowflake, facts, dimensions, grain, SCD, and keys. 33 questions with full answers, written for freshers. All topics
Foundations (3)
Fact Table Design (6)
Dimensions in Depth (7)
Modern Modeling Approaches (7)
Modeling Case Studies (10)
- Design a ride-sharing data model
- Design a food delivery data model
- Design a streaming (video) platform data model
- Design a social media data model
- Design a bank transactions model
- Design a subscription business model
- Design a healthcare claims model
- Model inventory levels
- How to start a data modeling interview answer
- Fan traps and chasm traps