Code Room
System designHardsd-g090
Subject Feature storeLevel Senior–Staff~45 minCommon in ML systems · Databases & SQL interviewsIndustries Technology

Question

Design a feature store for a fraud-detection model where the same feature definitions (e.g. 'card transaction count in last 24h', 'avg basket value last 7d') are used both to train offline on years of historical data and to score transactions online at 5k TPS with a 20ms feature-fetch budget. The bank's biggest recurring problem is training/serving skew: models look great offline and underperform in production. Design the store to make online and offline features provably consistent, and explain how you guarantee point-in-time correctness when generating training data.

What a strong answer looks like

Clarify scale and constraints first. Propose a clean component breakdown, then go deep on the hard parts — data model, bottlenecks, consistency, failure modes — and name the trade-offs you are making.

Narrate your design
Loading whiteboard…
Run or narrate your approach, then ask the coach.