Your question is Use dbt for Maintainable ELT. Take a moment with it on the right.
Talk me through your thinking if you like. When you're confident, submit your answer and I'll grade it like a real screen (7/10 or better passes).
How would you use DBT in an ELT workflow to build maintainable transformations?
Explain how you would structure staging, intermediate, and mart models; manage dependencies; and choose between table, view, incremental, and ephemeral materializations. Include examples of dbt tests, documentation, source freshness checks, incremental logic, environment promotion, and CI validation. Discuss how you would handle schema changes, backfills, failed runs, and lineage while keeping transformations modular and reliable.
