Fivetran / Airbyte
Also written as Fivetran, Airbyte, Managed ELT, Data Ingestion Tools
Tools that copy data from business systems (Salesforce, HubSpot, payment providers, production databases) into a data warehouse automatically, using ready-made connectors instead of custom code. Fivetran is the leading paid product; Airbyte is the main open-source alternative. Usually paired with dbt, which then cleans and models the data.
Think of it like
A courier with standing pickups from every supplier, so nobody has to drive out to collect the boxes.
Junior or senior?
Setting up a connector is easy, so it's low signal on its own.
Senior sounds like
Talks about controlling cost, handling changes in the source data's structure, and when they wrote a custom pipeline instead.
Ask them
“What happened when a source system changed its data format, and how did you find out?”