I applied through college or university. The process took 1 day. I interviewed at Deloitte (Gauhati) in Aug 2024
Interview
There was only one interview arranged over there platform all the candidates were queued at the same time and each one of them got to give interview once allowed to the interview. It was an easy interview someone with the basic knowledge of core subjects and dsa can easily have a good interview.
3 rounds, first- questions on SQL and dataframes, business case, second round- questions on SQL, third round- business case and SQL, mostly focusing on joins, window functions and repeat rate questions and checking business intuition
Interview questions [1]
Question 1
Calculate the repeat rate of orders from a given table, difference between inner join and outer join
very conversational, scenario interview was pretty easy, was hard to stand out though because no question was that hard, I thought it went well but did not end up getting the job
Interview questions [1]
Question 1
Why do you want to work specifically in Audit and Assurance?
It was smooth and easy.. All they asked was about python and data visualization part like power Bi, Data analysis, Dash board development and Data Modelling. The interviewer was pretty cool
