A startup has nine fragile point-to-point pipelines on the canvas: three sources (Postgres, Stripe,
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 startup has nine fragile point-to-point pipelines on the canvas: three sources (Postgres, Stripe, Zendesk) each with three team-specific extracts. Every Postgres schema change breaks three pipelines and the on-call gets paged four times a week. Apply the beginner tier (three gaps, four roles, fan-in, layered architecture) to consolidate. Each source should land once into a shared raw zone, one curated transform should feed a shared warehouse, and every dashboard should read from the warehouse. The final canvas should have fewer nodes than it started with.
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