Walk Through an ETL Project
DoorDashAnalytics Engineer · Technical Screen
Last updated
This question evaluates an analytics engineer's end-to-end ETL and data engineering competencies, including data ingestion, transformations, data modeling, orchestration, testing, monitoring, backfills, and handling failures or schema changes.
For an Analytics Engineer interview, walk through an ETL project you built end to end. Describe the business goal, source systems, ingestion pattern, transformations, data modeling choices, orchestration, testing strategy, monitoring, backfills, and how you handled failures or schema changes. Then describe a time the project had ambiguous requirements, conflict with a stakeholder or manager, or competing opinions about the right implementation, and explain how you resolved it.
Solution walkthrough is for members
Get the full walkthrough with reference code and complexity analysis, plus Kitty Coach at 300 messages a day. Hints, the code runner and community answers stay free.