Real-Time Investment Portfolio Position Pipeline

A hard 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

hard

Seniority

staff

Interview Prompt

Our portfolio analytics platform shows clients their real-time holdings value, but trade executions aren't reflected in positions until the nightly batch runs 8 hours later. The risk team also needs intraday P&L with market prices validated against multiple data vendors before they feed NAV calculations. Design a pipeline that makes positions and P&L available in near-real-time throughout the trading day.

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