A company at 500 engineers has thousands of pipelines, half written by people who left
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 company at 500 engineers has thousands of pipelines, half written by people who left. Deprecating an orphan pipeline whose owner left and whose consumers are unknown is genuinely hard. The section's structured ownership: team-level ownership (not personal), a quarterly ownership audit that flags orphans, and a five-phase deprecation process: candidate (consumers identified), notice (90-day sunset notice), mute writes (parallel write only, queries return deprecated warnings), stop reads (queries fail), retire (pipeline removed). Plan the sunset by adding the five-phase deprecation process on the canvas plus an ownership-audit node whose name states the cadence and the orphan-flagging rule.
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