Senior Data Engineer Interview Questions

2,565 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

3.9
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

1st was the online written round which had basic aptitude and logical questions. After that, there were 2 technical rounds. Technical 1 had questions based on sql, nosql- Hbase, spark and sparksql, hive, python, AWS related questions. They also asked questions related to neo4j and Kafka. Technical 2 also had questions related to nosql database, questions related to spark such as sparksession vs sparkcontext, wide transformations, repartition in spark, few python questions, spark scenario based questions and few hive scenario based questions, hive optimization techniques etc. After that a formal HR round about salary expectations, any offer in hand and location. They released offer letter 2 days
avatar

Senior Data Engineer

Interviewed at Nagarro

3.9
Nov 26, 2021

1st was the online written round which had basic aptitude and logical questions. After that, there were 2 technical rounds. Technical 1 had questions based on sql, nosql- Hbase, spark and sparksql, hive, python, AWS related questions. They also asked questions related to neo4j and Kafka. Technical 2 also had questions related to nosql database, questions related to spark such as sparksession vs sparkcontext, wide transformations, repartition in spark, few python questions, spark scenario based questions and few hive scenario based questions, hive optimization techniques etc. After that a formal HR round about salary expectations, any offer in hand and location. They released offer letter 2 days

Viewing 461 - 470 interview questions

See Interview Questions for Similar Jobs

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