A daily orders pipeline ran green every night last week
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 daily orders pipeline ran green every night last week. Finance noticed Friday that revenue dropped 12 percent on Tuesday and stayed low. The cause: a Kafka partition silently dropped events for six hours; the pipeline read every event that was present and exited zero. Operational success and semantic failure coexisted. The section's point is that green orchestrator runs do not prove the data is correct. Spot the silent failure by adding a quality gate between the transform and the mart, plus a paging destination so the gate's verdict reaches a human.
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