SaaS API Connector with Incremental Sync
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
A third-party CRM holds about 40 million records behind an API whose schema changes without notice. The warehouse needs a full historical copy of them plus ongoing incremental updates. Design the pipeline that keeps the warehouse in sync with this API.
Summary
The API has rate limits. You have deadlines.
How This Interview Works
- Read the vague prompt (just like a real interview)
- Ask clarifying questions to the AI interviewer
- Draw your pipeline on the design canvas: sources, transforms, storage and checks
- Answer the interviewer's follow-up questions, then get a hire or no-hire decision