The data modeling round was about designing the schema for two tables, one to represent individual bookings and one to represent the properties being booked, and then writing queries off of them.
Senior Data Engineer Interview Questions
2,552 senior data engineer interview questions shared by candidates
What schema would you use for a DW?
Describe you previous big data projects.
Mostly questions about past projects and experience
Round 1: Technical questions - Common data structures and algorithms (search in sorted list, search in linked list, red-black-tree) - How would you implement a priority queue? - HashMap collision resolution strategies - Examples of probabilistic data structures, advantages - Difference between functional and imperative programming. - How would you represent a graph in-memory? - Difference between columnar and row based database. - Difference between inner and outer join. - Explain MapReduce.
Round 2: Coding - Calculate the median of a window of values over an infinity data stream - And a second data question I don't remember
Code some well known algorithm and reason about it. Implement unit tests. Besides many trival questions
difference between datalake, datawarehouse, and what is a lakehouse ?
Ask your knowledge of how Spark works. Also ask if you are familiar with cloud technology. Some other stuff like dataware house and Airflow. The question is confusing sometime though, as the interviewer sometimes cannot tell different concepts apart.
d you have any other offer in hand?
Viewing 2221 - 2230 interview questions