Loading interview...

Financial Services Pipeline with Regulatory Reporting

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
senior

Interview Prompt

We're a financial services company handling consumer credit products. The risk and compliance team needs a warehouse that supports regulatory reporting - Basel III liquidity ratios, CCAR stress testing data, and daily loan portfolio snapshots. Right now the source data sits in a mix of operational databases with no analytics layer. Design the full pipeline and data model.

How This Interview Works

  1. Read the vague prompt (just like a real interview)
  2. Ask clarifying questions to the AI interviewer
  3. Write your pipeline design solution with real code execution
  4. Get instant feedback and a hire/no-hire decision