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.
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.