I recently completed an online interview for the Data Analyst position at Deloitte. The interview covered a broad range of topics, including behavioral questions, theoretical knowledge, and both software and hardware-related skills. It was a well-rounded assessment that tested not only my technical abilities in data analysis but also my problem-solving approach and communication style. Overall, the interview provided a great opportunity to demonstrate my capabilities and understanding of the role.
Interview questions [1]
Question 1
Can you tell us about a time you worked with a large dataset and how you drew meaningful insights from it?
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