- Hai altri iter di assunzione in corso?
Senior Data Engineer Interview Questions
2,552 senior data engineer interview questions shared by candidates
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
What are your salary expectations
Viewing 461 - 470 interview questions