Prep RoomSign inStart free
Code RoomSaaS API sync framework
MediumPrep Room Coding #3311

SaaS API sync framework

System designNetworking & APIsMid–Senior~40 min

Design an ETL connector framework that syncs data from ~50 third-party SaaS APIs (CRMs, ticketing, marketing tools) into a customer's warehouse, refreshing every 15 minutes. Each API differs: some paginate by cursor, some by offset, all have different rate limits and occasional 429/5xx, some support incremental ('updated since') and some only full-dump, and some have eventually-consistent reads. Design the extraction framework so syncs are incremental where possible, resumable on failure, respect rate limits, and never silently miss records.

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.

Clarify4:30 left
Estimate4:30 planned
Design13:30 planned
Deep dive10:30 planned
Failure7:00 planned
0:00
Which questions mattered is sealed until you submit. Telling you now would just be handing over the edge cases.