# A growth team is launching a new analytics platform that needs to ingest from all four shapes at onc Canonical URL: Domain: Pipeline Design ยท Difficulty: medium ## Problem A growth team is launching a new analytics platform that needs to ingest from all four shapes at once: a Postgres orders database (pull), a Kafka clickstream topic (push), an SFTP partner directory (file drop), and the Stripe API (API). Every source must land in a single Iceberg raw zone, each with the right resume state and the right defensive checks. Assemble the multi-source ingestion: incremental pull with bookmark on Postgres, write-first-commit-after Kafka consumer with webhook buffer, manifest plus validation plus processed-prefix on SFTP, and cursor-based paginated API ingest with rate limiter, OAuth refresh, and 429/5xx backoff. ## Related - [All practice problems](https://datadriven.io/problems) - [Mock interview mode](https://datadriven.io/interview/a-growth-team-is-launching-a-new-analytics-platform-that-nee-b4c5a07c) - [System Design Interview Questions](https://datadriven.io/data-engineering-system-design) - [Data Engineering Interview Prep Guide](https://datadriven.io/data-engineer-interview-prep) - [Daily Challenge](https://datadriven.io/daily) --- Source: DataDriven (https://datadriven.io). 100% free data engineering interview prep. Live code execution against Postgres 16, Python 3.11, and Spark sandboxes. No paywall, no premium tier, no signup gate.