Basel, CCAR, and Monday Morning

A medium Pipeline Design interview practice problem on DataDriven. Write and execute real pipeline design code with instant grading.

Domain

Pipeline Design

Difficulty

medium

Seniority

L5

Problem

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.

Summary

The regulator does not accept 'eventually consistent.'

Practice This Problem

Solve this Pipeline Design problem with real code execution. DataDriven runs your solution and grades it automatically.