Round 2: Data - You are given a data set of song "plays" and metadata (song, artists etc.) - Design a data solution to calculate the top artists per country
Senior Data Engineer Interview Questions
2,442 senior data engineer interview questions shared by candidates
Code the fibonacci sequence, multiple ways
Brush up spark, scala, python and sql concepts. 2 phone rounds - 1 technical , 1 behavioral + architectural!! If you manage to clear then onsite will be quick, they are very understanding and clear on their thoughts — 5 techinal rounds focused on streaming , Coding , design, sql and leadership!!
what do you know about the company and projects
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.
Basics of python and AWS
Viewing 391 - 400 interview questions