Here's what the average data engineering interview looks like in 2024:

- 1 hour algorithms in Python
Here you will be asked irrelevant questions about dynamic programming, linked lists, and inverting trees

- 1 hour SQL
Here you will be asked niche questions about recursive CTEs that you've used once in your ten year career

- 1 hour data architecture
Here you will be asked about CAP theorem, lambda vs kappa, and a bunch of other things that ChatGPT probably could answer in a heartbeat

- 1 hour behavioral
Here you will be asked about how to play nicely with your coworkers. This is the most relevant interview in my opinion

- 1 hour project deep dive
Here you will be asked to make up a story about something you did or did not do in the past that was a technical marvel

- 4 hour take home assignment
Here you will be asked to build their entire data engineering stack from scratch over a weekend because why hire data engineers when you can submit them to tests?