The Fare Aggregator

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 aggregate airfares from dozens of airline APIs and global distribution systems, and we check 80 billion prices per day to power flight search for 100 million users. The problem is that every GDS and direct airline API has a completely different schema - one calls it departure_time, another calls it dep_utc, another sends it as a Unix timestamp. Our prices also go stale within seconds during booking surges. Design a pipeline that keeps prices fresh and routes users away from sold-out flights before they see a failed booking.

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