SQL, Spark, DB Design, Coding (Data Structures and Algorithms), Conceptual - rote memorization type questions
Senior Data Engineer Interview Questions
2,562 senior data engineer interview questions shared by candidates
Write a SQL and PySpark code to display the 2nd lowest salary employees for each department having more than 10 employees, along with their employee name and department name. Two tables Employee and Department is giving? What to use Row_Number, Rank or Dense Rank?
Project management, SQL, Spark, Python
The provided a fictional business and asked what type of data structure I would build out to support the business. They asked me to do it Realtime in draw.io.
1st round - Medium difficulty questions were sent over the email and had to reply on email within one hour. Cleared. 2nd round - Asked about my work experience and explain a bit about the role being offered. Most of the questions were related to Data modelling and designing a data model for a hypothetical scenario.
All questions related to skills mentioned in the job description. ( Airflow, Snowflake, Datawarehouse concept, previous projects experience)
what is a decorator in python.
all text book questions on SQL and Python
Kimbal model types AWS Python SQL
How do you automate your day to day tasks as part of Data Platform team?
Viewing 1501 - 1510 interview questions