Typical programming questions. Some coding exercises.
Senior Data Engineer Interview Questions
2,442 senior data engineer interview questions shared by candidates
What do you know about the company?
Given a OLTP system which tracks the sales of items with order processing, returns and shipping, need to create a data warehouse model to answer gross sales, net sales, gross sales by prodcut etc..
SQL round was a miscellaneous gauntlet of joins, another five questions in an hour.
Given a simplified OLTP data model in Instacart, how would you design, in sufficient details, its data warehouse?
He was interested in projects I've worked upon. He asked me business usecases where I used data engineering, ask about bulk insert, dimensional modeling and related stuff.
Explain as detailed as you know it, the difference between SQL and NoSQL databases
Binary Search-related questions. Also, graph- and tree-related questions were asked in coding interviews.
design a system supporting a dashboard showing metrics about played songs with a few filters, from client to server whiteboard coding interview: implement a queue. Distributed map-reduce, explanation, how to handle sorting
Round 2: System Design - Similar to data, design a "weekly wrapped" feature (top 50 songs per country per week)
Viewing 781 - 790 interview questions