A few generic questions around Data Warehousing/ETL approach, scenario based questions. One interviewer was asking questions from Interview Q&A website, was not happy if answers and terms didn't match exactly. You don't ask syntactical questions to experienced staff who can lookup manual in a minute and figure things out.
Questions about building and monitoring pipelines
Mutiple continuous questions from everybody, can't provide.
SQL, Spark, DB Design, Coding (Data Structures and Algorithms), Conceptual - rote memorization type questions
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.
Viewing 1491 - 1500 interview questions