Senior Data Engineer Interview Questions

2,553 senior data engineer interview questions shared by candidates

Online Coding Contest on Hackerrank: simple array question to solve in O(n) time and O(1) space 1 question on Binary Tree( medium level) Interview 1: 1.basic array Coding question 2.Coding question on Linked List Theory - OLTP vs OLAP Hadoop vs AWS S3 storage Question on spark(medium level) Interview 2: The interviewer asked me to solve Scenario based question on which he was currently working :P Didn't able to and this properly as many doubtful cases coming into the picture coding question on array(minimize to 1 for-loop, I did it with 2) very simple SQL query( solved with AVG() func) Interview 3: Coding Question on String(simple) coding question on Kadane's Algo questions on mongodb(basics) question on oops(basics) Interview 4(with Manager): 1.coding question on 2D array(medium level) 2.Advance Sql Ques Interview 5(with Head): General Discussion Call with HR : Salary discussion and perks
avatar

Senior Data Engineer

Interviewed at Poshmark

4
Nov 29, 2021

Online Coding Contest on Hackerrank: simple array question to solve in O(n) time and O(1) space 1 question on Binary Tree( medium level) Interview 1: 1.basic array Coding question 2.Coding question on Linked List Theory - OLTP vs OLAP Hadoop vs AWS S3 storage Question on spark(medium level) Interview 2: The interviewer asked me to solve Scenario based question on which he was currently working :P Didn't able to and this properly as many doubtful cases coming into the picture coding question on array(minimize to 1 for-loop, I did it with 2) very simple SQL query( solved with AVG() func) Interview 3: Coding Question on String(simple) coding question on Kadane's Algo questions on mongodb(basics) question on oops(basics) Interview 4(with Manager): 1.coding question on 2D array(medium level) 2.Advance Sql Ques Interview 5(with Head): General Discussion Call with HR : Salary discussion and perks

1. What is factless fact table. 2. Explain spark stages of execution in case of a join 3. what is confirmed dimension 4. Explain all the normal forms in the database (seriously... still ) 4. Explain data vault concepts. Some good questions are 1. design a database for universities. 2. write a small SQL query 3. Spark program to work with a list
avatar

Senior Data Engineer

Interviewed at Omio

3
Dec 14, 2018

1. What is factless fact table. 2. Explain spark stages of execution in case of a join 3. what is confirmed dimension 4. Explain all the normal forms in the database (seriously... still ) 4. Explain data vault concepts. Some good questions are 1. design a database for universities. 2. write a small SQL query 3. Spark program to work with a list

Viewing 461 - 470 interview questions

See Interview Questions for Similar Jobs

Glassdoor has 2,553 interview questions and reports from Senior data engineer interviews. Prepare for your interview. Get hired. Love your job.