# Three jobs (extract, transform, load) run on three separate cron schedules

Canonical URL: <https://datadriven.io/problems/three-jobs-extract-transform-load-run-on-three-separate-56b11517>

Domain: Pipeline Design · Difficulty: medium

## Problem

Three jobs (extract, transform, load) run on three separate cron schedules. When extract runs late, transform reads yesterday's data and nobody notices. Design orchestration so each step runs only after its inputs are ready, with a deadline alert.

## Related

- [All practice problems](https://datadriven.io/problems)
- [Mock interview mode](https://datadriven.io/interview/three-jobs-extract-transform-load-run-on-three-separate-56b11517)
- [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.