Describe the difference between ETL and ELT and when to choose each
Tests transform timing and compute location. ETL cleans data before loading via external engines; ELT loads raw data first, then transforms in the warehouse. Pick ETL when pre-load cleansing is needed, ELT when warehouse compute is cheaper.
What's really being asked
The interviewer wants to know if you understand that ETL and ELT are not just acronyms but architectural choices driven by cost, latency, compliance, and the capabilities of your target system. Specifically, they care whether you recognize who does the work, where the work happens, and what trade-offs that creates for data quality, security, and agility.
The full answer
Four things in order. First, define ETL as extracting data from sources, transforming it on an external compute layer, and then loading the refined result into the target. Second, define ELT as extracting data, loading it raw into the target system, and then transforming it inside that system using its own compute. Third, explain the decision criteria: choose ETL when you must cleanse, mask, or filter sensitive data before it lands in storage, when data volumes are small enough that external engines are efficient, or when the target database or data lake lacks compute power. Choose ELT when your cloud warehouse is cheaper and faster than external engines, when you want to preserve raw data for future reprocessing, or when schemas evolve quickly and you need flexibility. Fourth, mention real-world economics, such as the shift from traditional ETL tools to ELT in modern cloud warehouses like Snowflake, BigQuery, or Redshift.
The mistakes people make
Saying ETL is simply old and ELT is simply new without explaining why. Claiming that ELT always replaces ETL, which ignores compliance scenarios where raw sensitive data cannot be loaded. Describing the difference only as the order of letters without discussing compute location or cost. Giving a scenario that does not justify the choice with concrete constraints like data volume, security requirements, or target system limitations.
What usually comes next
The interviewer may ask how you would handle schema drift in an ELT pipeline, how you would secure raw data in an ELT architecture before transformation, or what specific tools you have used for each pattern such as Informatica or Airbyte for ETL and dbt for ELT. They may also ask about cost comparisons between running transformations on Spark clusters versus inside a Snowflake warehouse.
A concrete example
Imagine you are building a pipeline for a healthcare company that ingests patient records from multiple clinics. If regulations require that personally identifiable information be masked before it enters the data warehouse, you should choose ETL because the transformation must happen on a secure external compute layer before loading. Conversely, if you are ingesting high-volume clickstream events into a cloud data warehouse and the business wants to experiment with different sessionization models weekly, you should choose ELT because you can land the raw events cheaply and use dbt to iterate on transformations without re-extracting from the source.
Interview question
Which factor most strongly justifies choosing ETL over ELT?
- a.The organization wants to preserve raw data for future reprocessing
- b.Schemas change frequently and the team wants to iterate on transformations
- c.The cloud warehouse offers cheaper and faster compute than external engines
- d.Regulations require that sensitive data be masked before entering storageCorrect
Why? this is the answer
ETL is correct because it transforms data on external compute before loading, satisfying requirements to mask sensitive data before it reaches storage. The option citing cheaper warehouse compute is tempting but actually describes a primary reason to choose ELT instead.
Just read this? Test yourself on what you have been reading.
Read the original → en.wikipedia.org
You just looked this up. Could you explain it out loud?
That is the part interviews actually test. Tezvyn takes questions like this one and gives you what the interviewer is really checking, the answer that lands, and the mistake that ends the conversation, in the four minutes before your next meeting.
The iPhone app is on the way
We are building it. Until it lands, nothing here is held back from you: every interview card, your saved cards, streaks and the job board all work in Safari, plus hundreds of free practice quizzes of thirty questions each. Sign in and it all carries over to the app the day it arrives.
Want it as an icon? Tap Share at the bottom of Safari, then Add to Home Screen. It opens full screen and the cards you have read stay available offline.
We are hiring for this. Open roles that interview on data engineering — each one lists the topics its interview covers.
See open roles