It was a good interview they have covered all the topics that related to Azure data Factory , azure Databricks and Sql. They have concentrated on scenario based concepts as well
Interview questions [1]
Question 1
What are the optimization techniques that we can use ?
I applied online. I interviewed at Deloitte (Pune) in Sep 2023
Interview
There are three technical rounds. They mostly asked fundamental questions for 3 years of experience. If basics are clear in SQL, Python then you can easily crack the interviews. I feel interview process is very slow at Deloitte.
I applied online. The process took 5 days. I interviewed at Deloitte (Hyderabad) in Oct 2024
Interview
It was online interview, they mainly focused on sql, pyspark and ware housing. They asked about the same, in sql joins and queries, in pyspark, dataframe operations and merge logic for scdtype2.
Interview questions [1]
Question 1
Explain about SCDType2, and write logic for merge.