InterviewLegend

Design a Sensor Log Ingestion and Query Service

Signature problem
Alex Chen25 min readAdded 25 real interview reports

Versions of this have come up at Applied Intuition all through the past year. In a December 2025 in-person loop, one candidate was asked for a module programmers would use to interpret and process data from driving environments. A March 2026 phone screen handed over files full of schemas and asked how to query what they contain. A July 2026 technical screen framed it as sensor data processing, with raw versus processed data, schema design, time-range queries, aggregation and validation all on the table. In October 2026, an AI-assisted virtual onsite had one candidate build the query API over MCAP driving logs and then demo it.

A one-hour drive has camera images at one rate, GPS at another and IMU readings a hundred times a second, and every message is stamped with its own time. An engineer chasing a bug wants the vehicle's speed between two moments, or the location at the instant a frame was captured. The file was written for recording and playback. The service's job is to make it answer those questions in milliseconds. The scale here is per run, and it's lopsided. A few hundred thousand small messages sit next to tens of gigabytes of images. Most of the design follows from treating those two very differently.

The Applied Intuition angle
Applied Intuition builds log, simulation and data tooling for autonomy teams, and MCAP is the default recording format in ROS 2. The October 2026 candidate put the core requirement plainly: every message has a timestamp, and the API has to query by timestamp, so an index is needed. Get to that index early.

Applied IntuitionPremium lesson · System design round

The Applied Intuition design, worked end to end.

  1. The API and data modelSystem design · Signature problem
  2. The design, drawn out1 diagram
  3. 6 deep divesWith the tradeoffs
Get the Applied Intuition questions

$49 a year · all 107 companies · instant access

20,000+ candidate reports · guide updated

Applied Intuition interview guide

Know what Applied Intuition asks before you walk in.

10 coding · 4 system design · 15 behavioral questions

Get Premium$49 a year · Instant access
Or start freeNo card.

Get their questions first.

Had your Applied Intuition interview?How we research

InterviewLegend is independent and not affiliated with or endorsed by any company it covers.