The online test had three coding and one SQL question. Coding questions were more stringent than SQL, that came as a surprise to me as the position was for "Big Data Engineer." Feels like they hire anyone without any skill match to the job position or based on the "coolness" of the resume factor.
deploy mode in spark
Mostly on Hive, ingesting web traffic data, ingesting json files, lot of sql queries, DWH questions
Complex mysql query faced related to window, joins etc.
Data Lineage? MDM questions on joins. moderate SQL problems Spark
Why do we use parquet file format ? Why dataframes are faster than RDD
What was your role in the project and did you lead the project
Work that you are most proud of, Spark, Hadoop Theory . One Leetcode Medium/Hard
stack and time_map based questions
Very high-level experiences, with specific questions on data analysis and databases.
Viewing 1661 - 1670 interview questions