Why is the need of dbt
Senior Data Engineer Interview Questions
2,553 senior data engineer interview questions shared by candidates
The "pair programming" thing was a joke. I thought it was going to be collaborative, but instead it was just a one-sided coding exercise - just me writing SQL while sitting there as my interviewer said nothing. Zero collaboration, or even back and forth. Oh, and besides that, they asked one of those "brain teaser" type questions that involve SQL that you'll never see in the real world - the answer involved joining a dimension table to a sales table using a cartesian. Yeah, that's really what you want your engineers to do - cross join millions of dimension records to billions of fact records, brilliant.
Explain your previous experience on your resume.
Spark Arch, Airflow, EMR vs Glue, Deltalake, Data Warehousing concepts
Without giving too much away I can mention questions about inversion of control, Apache Beam, and a bit about differences between various programming languages and what they would each be suitable for.
What is rownum? Why do we use columnar database? Which cases columnar database is not good?
Basics of python and AWS
Merge two sorted lists and don't use any in built sort function
Going over Resume, Past experience, Architectural questions, SQL - window function question
Asking me how to choose between in-house solution and managed services.
Viewing 401 - 410 interview questions