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
Senior Data Engineer Interview Questions
2,565 senior data engineer interview questions shared by candidates
- Hai altri iter di assunzione in corso?
About your role in current organization. Lot if SQL related questions. What are my aspirations, and future goals.
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
They asked how I would design and implement a data pipeline, ensuring data quality and performance across different stages.
Basic Data Engineering questions and take home assignment.
Generate a histogram table using Spark
No questions were asked, no interview.
What are five things you could do with a #2 pencil aside from writing or drawing something?
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