I applied online. The process took 3 months. I interviewed at Deloitte in Feb 2024
Interview
The final assessment centre included 1-1 interview, group work, and a critical-thinking test (present several scenarios and I had to analyse the situation and give the solution to the problem).
Interview questions [1]
Question 1
What software did you use for previous work or project?
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