I applied online. The process took 4 weeks. I interviewed at Deloitte (Hyderabad) in Jan 2023
Interview
1st round consists of aptitude and coding. There were 3 sections in aptitude reasoning and english. 2 coding questions were given of moderate level. initially resume screening will be there and after your resume gets selected u need to book the slot.
Interview questions [1]
Question 1
intoduction
questions on projects mentioned in resume
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