Data Engineer · Junior · Theory

What's the difference between ETL and ELT?

~4 min by voice

How to approach it

The interviewer wants to see whether you understand where exactly the data transformation happens, before the warehouse or inside it, and why the industry shifted to ELT with the arrival of powerful cloud and columnar warehouses.

Have you seen this question in a real interview?

Answers0

Avg. score—

Strong—

Practiced0

Topics

etl data pipelines

Similar questions

Design a system of daily batch pipelines for several hundred tables with dependencies between them. How would you handle reruns, backfills and late-arriving data? Senior You need to deliver changes from a multi-terabyte production PostgreSQL database to an analytics warehouse with no more than five minutes of latency. How would you design this pipeline? Senior A daily pipeline loads yesterday's data into the warehouse. Sometimes it fails halfway through, and after a restart duplicates show up in the table. How would you redesign it? Mid-level Design a simple pipeline that moves orders from the production database to an analytics warehouse every day. Junior Design an analytical data warehouse for a mid-sized online store: the data comes from the product Postgres database, a CRM and ad platforms, and the consumers are BI dashboards and analysts. Walk me through how you'd set it all up. Mid-level

Answer by voice

The interviewer will ask this question and listen. Think out loud and ask for a hint if you need one. When you're done, pause or tap “That's my answer”. In about a minute, your score and the points you covered show up here.

Best with headphones · ~4 min