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..
Sr Data Engineer Interview Questions
2,601 sr data engineer interview questions shared by candidates
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)
Round 1: Coding Questsion - Fibonacci (iterative and recursive) - Simple SQL on a single table (group by and accumulate)
Viewing 831 - 840 interview questions