what do you know about the company and projects
Sr Data Engineer Interview Questions
2,592 sr data engineer interview questions shared by candidates
Why is the need of dbt
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
Viewing 411 - 420 interview questions
See Interview Questions for Similar Jobs
Data EngineeringSenior Data EngineerBig Data EngineerSenior Big Data EngineerData EngineerSenior Data ConsultantLead Data EngineerData ScientistsData Scientist IiiPrincipal Data EngineerData Mining EngineerBigdata EngineerSr Data AnalystEtl Data Stage DeveloperSr Database EngineerDatabase Administrator IiSenior Data Stage DeveloperEtl Informatica Developer