A two-person team has Stripe, a Python ETL, and a Looker dashboard wired straight to the ETL
A medium 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
- medium
Interview Prompt
A two-person team has Stripe, a Python ETL, and a Looker dashboard wired straight to the ETL. Stripe rate-limits at 100 req/min while the dashboard refreshes 200 times a day, so every refresh re-pulls Stripe and trips the limit; when the ETL crashes mid-run the chart goes blank. Apply the section's four-roles framing and add the role the canvas is missing so the dashboard can refresh without retouching Stripe and keep serving when the ETL is down.
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