Half a Million Rental Cars

A medium Pipeline Design mock interview question on DataDriven, with an AI interviewer who asks follow-up questions and a hire or no-hire decision at the end.

Domain
Pipeline Design
Difficulty
medium
Seniority
L5

Interview Prompt

Our 500,000 rental vehicles stream telematics continuously while a reservation system records rentals and service centers log maintenance, and no view spans all three. Design the pipeline and warehouse that unify the three sources on vehicle id and serve each consumer at its own freshness.

Summary

Every vehicle is reporting. Every rental matters.

How This Interview Works

  1. Read the vague prompt (just like a real interview)
  2. Ask clarifying questions to the AI interviewer
  3. Draw your pipeline on the design canvas: sources, transforms, storage and checks
  4. Answer the interviewer's follow-up questions, then get a hire or no-hire decision