TikTok·Software Engineer·Onsite - System Design / Architecture
- Given an e-commerce marketplace with buyers, sellers, orders, order items, payments, and page view events, design a data warehouse model to support: daily session-to-purchase conversion rate, average order value, 7-day buyer retention by signup cohort, cancellation rate by seller, and daily GMV by category. Cover fact and dimension tables, grain, key columns, data types, partitioning and clustering, late-arriving events, deduplication, anonymous users, and slowly changing seller attributes. Justify your schema style and surrogate key choices.
“This was a lot to hold in your head at once.”