I completed the first coding round at Atlassian for a Data Engineer role.
As this role requires strong SQL and Python skills, the coding round featured three sequential SQL questions and one Python-based programming question.
The questions were fairly straightforward if you had prepared well.
I am still awaiting a response from Atlassian regarding my interview. Hoping for the best!
SQL Questions:
The first question was based on ranking and joining to get the solution.
The second follow-up question used the same database and tables. It asked for a rolling average based on the last 3 days.
The third question was again based on a rolling sum and then a count query based on that rolling sum.
All of the SQLs required CTE statements.
Lastly, the Python programming question was a basic for loop to search for the position of a target number. The interviewer asked for a different approach to solving it.
The following metrics were computed from 2 interview experiences for the Atlassian Senior Data Engineer role in Sydney, Australia.
Atlassian's interview process for their Senior Data Engineer roles in Sydney, Australia is fairly selective, failing a large portion of engineers who go through it.
Candidates reported having very good feelings for Atlassian's Senior Data Engineer interview process in Sydney, Australia.