It was easy, basic sql questions like 2nd highest salary. HR asked about View, and subquery. 3 round, first with Hr then Manager and then Director. Director asked some reasoning questions which sounds tricky but were easy.
Interview questions [1]
Question 1
What is view in sql and find the second highest salary
I applied through other source. The process took 2 weeks. I interviewed at Aon (Toronto, ON) in Dec 2017
Interview
I had three interviews for the position. The first was a screening interview with HR, the second was an interview with my boss and a senior colleague and the last was a panel interview with the previous interviewers and the head of the department.
Interview questions [1]
Question 1
Tell me about how you would go about doing a VLOOKUP?
I applied online. I interviewed at Aon (Orlando, FL) in Feb 2020
Interview
Had an interview with a couple of managers from different teams. They were pretty friendly and the interview was very relaxed. They provided plenty of time for me to answer and welcomed questions from me.
Interview questions [2]
Question 1
Typical behavioral questions, such as 'Tell us of a time when you had to deal with conflict with other team members (s), what was the issue, how did you approach it and what was the end result?