InterviewStack.io LogoInterviewStack.io

Workflow Orchestration and Scheduling Questions

Orchestrating multi-step data workflows with DAG schedulers (Airflow, Dagster, and similar tools): dependency management between tasks, scheduling strategies (cron-based, sensor and trigger patterns, event-driven runs), and backfills or catch-up runs for time-partitioned data. Covers task-level retries and idempotent task design, so a scheduler can safely re-run a failed step, plus SLA tracking and alerting when a run is late or missing. The core concern is coordination: given a set of dependent tasks that must run in some order on some schedule, how do you trigger, sequence, and re-run them reliably. This is distinct from whether the data itself stays correct across a failure (exactly-once processing, deduplication, checkpointing, and dead-letter handling for corrupted or poison messages, which is a data-consistency concern) and from how a specific compute engine executes a task internally (Spark or Hadoop mechanics). The operational glue of a data platform: getting the right task to run at the right time, in the right order, with visibility into failures.

HardTechnical
54 practiced

Implement a simplified Python scheduler to run retraining jobs given a DAG of tasks and dependencies. Requirements: accept a JSON DAG, resolve execution order, support backfill of missed runs for specific dates, and detect cycles. Provide a minimal implementation sketch and explain how you would extend it for distributed execution and retries.

MediumTechnical
50 practiced

Write a Python function that constructs an Apache Airflow DAG skeleton for a nightly training pipeline with tasks named: ingest, validate, preprocess, train, evaluate, register_model, deploy. Use the @dag decorator and PythonOperator placeholders; set sensible task dependencies and a nightly schedule. You do not need to implement the task functions, only the DAG structure.

MediumTechnical
48 practiced

You are asked whether to use Apache Airflow or Dagster for a new set of ETL jobs. Explain the high-level differences that matter in practice: developer experience, observability, dataset awareness, testing support, and deployment model. State when you would recommend each tool.

EasyTechnical
71 practiced

Define idempotency for orchestrated ETL tasks and explain why an orchestrator depends on it for safe retries and backfills. Walk through how you would turn a non-idempotent write step into an idempotent one, and what trade-offs your approach introduces. How would you validate in CI that a task is actually idempotent before it ships?

HardSystem Design
56 practiced

Design resource allocation and autoscaling for a Kubernetes cluster running heterogeneous pipeline tasks orchestrated by Airflow: short ETL jobs, medium-size Spark jobs, and heavy GPU model training. Address node pools, priority classes, preemption (spot/spot-like instances), GPU scheduling, and preventing starvation of critical tasks.

Unlock Full Question Bank

Get access to all 16 Workflow Orchestration and Scheduling interview questions and detailed answers.

Sign in to Continue

Join thousands of developers preparing for their dream job.