Interviewers keep asking if I have built ETL, what I built is Fivetran plus dbt, is that the same thing
Two years in this role, I own ingestion from six sources into Snowflake, roughly ninety dbt models and an Airflow schedule that ties it together. In interviews I get asked about ETL tooling and I never know whether to say yes and then explain, or say no and lose the question. Is the transform before load versus after load distinction actually load bearing anywhere in practice, or is it just vocabulary that shops use to signal which decade they hired in?
@yaml_yusuf · last mo. · 2 replies
Be aware the word means different things in different buildings and that is why the question feels weird. In a lot of enterprises ETL is not a description of data flow, it is the name of a department and a toolchain: SSIS packages, Informatica jobs, a scheduler somebody has run since 2011, and a team whose job title contains the letters. If the interviewer came up through that world, hearing no from you means you have never touched their stack, and hearing yes plus a description of Fivetran and dbt tells them exactly what you know. Answer the question they meant rather than the one about acronyms.
Reply
Report
@backfill_bram · last mo.
This. Ask them what their current stack is before you answer and the whole thing becomes a conversation instead of a test.
Reply
Report