I was sent a simulated scenario question on the data engineer pipeline. Loading of data, ETL, streaming data to data lake on cloud.
Sr Data Engineer Interview Questions
2,573 sr data engineer interview questions shared by candidates
Medium leetcode problem and advanced SQL.
There were no very difficult questions
What is an RDD in spark?
Typical programming questions. Some coding exercises.
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.
Viewing 811 - 820 interview questions
See Interview Questions for Similar Jobs
Data EngineeringSenior Data EngineerBig Data EngineerSenior Big Data EngineerData EngineerSenior Data ConsultantLead Data EngineerData ScientistsData Scientist IiiPrincipal Data EngineerData Mining EngineerBigdata EngineerSr Data AnalystEtl Data Stage DeveloperSr Database EngineerDatabase Administrator IiSenior Data Stage DeveloperEtl Informatica Developer