The Long Route
A hard Data Modeling mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.
- Domain
- Data Modeling
- Difficulty
- hard
- Seniority
- L5
Interview Prompt
We run a large e-commerce marketplace. A unit is bought from a vendor, received at one of our fulfillment centers, then picked, packed, and shipped to the customer. A single order often splits across several fulfillment centers, and one outbound truck can carry items from many different orders. Operations needs to see not just where every unit sits right now, but the full path it took to get there. Design the data model.
Summary
A package splits, reroutes, and (maybe) arrives.
How This Interview Works
- Read the vague prompt (just like a real interview)
- Ask clarifying questions to the AI interviewer
- Write your data modeling solution with real code execution
- Get instant feedback and a hire/no-hire decision