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 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.'

Practice This Problem

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