Flying Blind Until Midnight
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
- L6
Interview Prompt
Our capital markets desk runs trading books across fixed income, FX, and derivatives, and we need intraday margin calculations that reflect current market positions. Right now risk runs nightly and the trading desk is flying blind intraday. The bigger challenge: our regulators in Canada require BCBS 239-compliant lineage on every risk number - every P&L figure must be traceable back to its source trade and price. Design a risk data pipeline that satisfies both the latency and the compliance requirements.
Summary
Intraday risk, full lineage. The regulator is watching.
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