Psychometric test which you could take anytime within a given time range. 2 virtual interviews covering experience and discussing details of the role and team, including the manager of the team.
I applied through a recruiter. The process took 1 week. I interviewed at Macquarie Group (Sydney) in Aug 2023
Interview
Technical interview - they have slides of SQL questions from easy aggregations to pivot and rank.
They also asked a bit about behavioural questions and past experiences, but the focus was more on the technical side.
Interview questions [1]
Question 1
SQL - how to get the 3rd item when there are items with the same value.
I applied online. The process took 3 weeks. I interviewed at Macquarie Group (Sydney) in Sept 2019
Interview
I had first round of interview which went well, had technical as well as questions based on Agile. Second round was taken by scrum master and by a developer. Apart from knowing applications, databases they expect to know to understand and analyse stored procedure. Question was how a stored procedure is connected to database, what tool you will use to analyse stored procedure etc. Seems like they want a technical champion for Tech BA role who should know agile, application, databases and coder. Also seems like they have no idea what they want.
