Basel, CCAR, and Monday Morning
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
- Seniority
- L5
Interview Prompt
We run consumer credit products and need a regulatory reporting warehouse the risk and compliance team can file from. Loan attributes live in one operational database and payment activity in another, and both feed the daily Basel III liquidity ratio that regulators expect by 9am each business day, so the pipeline has to land and reconcile both sources and warn on-call well before that deadline if a stage slips. Once a day's report is filed it can never change: corrections go out as new filings, so the submitted snapshots need a durable archive that is written once and kept separate from the warehouse the analysts keep refreshing.
Summary
The regulator does not accept 'eventually consistent.'
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