Design an analytical data warehouse for a mid-sized online store: the data comes from the product Postgres database, a CRM and ad platforms, and the consumers are BI dashboards and analysts. Walk me through how you'd set it all up.
~10 min by voice
How to approach it
The interviewer wants to see whether you can design a complete analytics pipeline end to end: from clarifying requirements and extracting data to warehouse layers, mart modeling, orchestration, data quality and access. It's not enough to name tools; you need to justify the choices and show that you're thinking about running the system in production.
The interviewer will ask this question and listen. Think out loud and ask for a hint if you need one. When you're done, pause or tap “That's my answer”. In about a minute, your score and the points you covered show up here.