Data/ML/AIDatabases

ETL

Also written as Extract, Transform, Load

The process of pulling data from source systems, cleaning/reshaping it, and loading it into a destination like a data warehouse.

Think of it like

Like a mailroom that collects incoming packages from many senders, repackages and labels them consistently, then delivers them to the right department's shelf.

Junior or senior?

Junior sounds like

Describes an ETL pipeline as something that 'moves data around.'

Senior sounds like

Can walk through a specific pipeline they built, what broke, and how they found out.

Ask them

“Walk me through an ETL pipeline you built. What broke, and how did you find out?”