Staff Data Engineer Enterprise Architecture
PagerDutyThirty Million Unique Jobs a Year
We produce 30 million custom print products a year for small businesses - business cards, flyers, and banners - each one unique. Our profitability depends on ganging: combining multiple customer orders onto a single press sheet to maximize utilization. The ganging algorithm needs a real-time view of pending orders, and our operations team needs to know before a job starts whether it will meet its delivery promise. Our analytics are also fragmented across 10 acquired companies running different ERP systems. Design a pipeline that supports all three needs.
Ask the interviewer clarifying questions to understand the requirements and constraints before designing.
When you're ready, click Ready to Design to start building.
Thirty Million Unique Jobs a Year
A hard Pipeline Design mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.
- Domain
- Pipeline Design
- Difficulty
- hard
- Seniority
- staff
Interview Prompt
We produce 30 million custom print products a year for small businesses - business cards, flyers, and banners - each one unique. Our profitability depends on ganging: combining multiple customer orders onto a single press sheet to maximize utilization. The ganging algorithm needs a real-time view of pending orders, and our operations team needs to know before a job starts whether it will meet its delivery promise. Our analytics are also fragmented across 10 acquired companies running different ERP systems. Design a pipeline that supports all three needs.
How This Interview Works
- Read the vague prompt (just like a real interview)
- Ask clarifying questions to the AI interviewer
- Write your pipeline design solution with real code execution
- Get instant feedback and a hire/no-hire decision