I applied online. The process took 2 weeks. I interviewed at HALO (Auckland, Auckland) in Oct 2017
Interview
it was a 2-hour interview.
1. talk with the manager to discuss some personal experience;
2. 6 minutes technical test to write a SQL
3. technical interview with test lead and development lead;
Interview questions [1]
Question 1
Use a single sql statement to retrieve data from six tables. join statement should be used in this case.