Have you managed people before?
Sr Data Engineer Interview Questions
2,601 sr data engineer interview questions shared by candidates
Mostly on micropartions and pruning in snowflake. Caching Sql query Find 2 nd highest salary Find the sum of salary and display in desc order
Algorithms
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.
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
Viewing 2261 - 2270 interview questions