Interview question
Design idempotent Airflow DAG for daily ETL
Asked in UBS Canada Data Engineer interviews
Asked by
36% candidates
Difficulty
Hard
Round
System Design
AI synthesized from candidate reports
Related practice
Candidates also saw
- Optimize Spark job with data skew on a large join35%
- Explain slowly changing dimensions in a Snowflake warehouse49%
- Optimize a Spark job with data skew on a large join50%
- Design cost-efficient Snowflake warehouse sizing for ETL workloads51%
- Walk through an Airflow DAG designed for idempotent daily ETL52%
UBS Canada Data Engineer — People Also Ask
Common interview prep questions from recent candidates
- Recent candidates report role-specific technical questions, system design prompts, and behavioral STAR questions tied to ownership and impact.
- Competitive — panels test depth in role fundamentals, system thinking, and communication under follow-up pressure.
- Typical loops: Resume screening → Technical → Behavioral → Offer. Timelines often run 3–6 weeks.
- When the role involves Java or backend services, Spring Boot and API design often appear in technical rounds.
- Mid-senior Data Engineer loops frequently include system design or architecture discussions — especially for distributed systems and scale.