Deloitte Data Engineer Interview Questions, Process, and Tips

Q1. Sql constrainsts, star schema, dml dcl commands
Add your answer
Q2. About cureent project and responsibilities
Add your answer

Q1. Current projects and resposibilities
Add your answer
Q2. Where vs having, reason for job change
Add your answer

Round 1 was online Test where one basic coding question was there and few aptitiude , verbal ability and python based question.

Q1. What is Data WareHouse..?
Add your answer
Q2. Nested Queries in Bigquery..?
Add your answer

Q1. Basic Python, SQL & Spark coding questions.
Add your answer
Q2. Nth highest salary, word count in pyspark
Ans. 
To find the nth highest salary in pyspark, use the window function with row_number and filter on the desired rank.
• Use window function with row_number to assign a rank to each salary

• Filter the result to get the row with the desired rank

• Example: df.withColumn('rank', F.row_number().over(Window.orderBy(F.col('salary').desc()))).filter(F.col('rank') == n).select('salary')
Answered by AI
Add your answer

Q1. Questions on SQL & PySpark.
Add your answer

Q1. Questions about previous projects & optimization techniques etc. Also behavioural
Add your answer

Q1. Salary negotiation part.
Add your answer

Inbuilt platform where asked gcp releated mcqs

Q1. Python question on list
Add your answer
Q2. Sql window function question
Add your answer