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.
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
What can you bring to this company
Explain to me your experience in a tool that isn’t mentioned in the job description for a task which isn’t mentioned in the job description. Points off for mentioning another, relevant tool made by the same vendor which IS in the job description.
problems solved in previous projects and few other DE questions
Viewing 451 - 460 interview questions