I applied through other source. The process took 2 weeks. I interviewed at Deloitte (McLean, VA) in Feb 2022
Interview
There are 2 interviews video process. In the interview, there were 3 people who will ask you question. There is one pre-screen interview process. you have to wait 2 weeks for the final decision.
Interview questions [1]
Question 1
What would you do if you have a conflict with your boss?
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
