Interview question
Design idempotent Airflow DAG for daily ETL
Asked in JPMorgan Chase US Data Engineer interviews
Asked by
27% candidates
Difficulty
Medium
Round
Technical Round
AI synthesized from candidate reports
Question 1 of 4
Design idempotent Airflow DAG for daily ETL
Medium58% Candidate ReportsSYSTEM DESIGNJPMorgan Chase USData Engineer
Question
Design idempotent Airflow DAG for daily ETL
High-Level Approach
Partition by key, idempotent consumers, retry topic with backoff, DLQ with alerting.