I applied online. I interviewed at Atlassian in Dec 2024
Interview
Had a online coding interview. They had a separate website for coding practice, but there was a big discrepancy between the structure of coding practice and the real coding assessment. The practice only contained couple of SQL questions, but the actual assessment test contained additional Python questions in the same amount of time.
We should first do a hackerrank code test. There are three question. Two coding and one concept. For the coding test, i remember there are two python/sql question. And the concept are stats related question
1 * OA, one round of 4 easy to medium SQL questions and 1 Product case question - manageable, 1 BQ that lasts long. The process proceeded fast. Recruiter was nice.
Interview questions [1]
Question 1
Very thorough review of all types of behavioral questions
Tech interview is one hour, We went over some SQL questions (like medium difficulty in Leetcode) and did a case study in data analysis aspect, like what should we consider, potential problems or so.
Interview questions [1]
Question 1
solving SQL questions and roughly explain the code