What do you know about the company?
Senior Data Engineer Interview Questions
2,400 senior data engineer interview questions shared by candidates
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
Data engineering concepts, Open source technologies.
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 761 - 770 interview questions