Coding Round 1

1. Similar to Group Anagrams (https://leetcode.com/problems/group-anagrams/)
2. SQL (medium)
3. Data Theory : difference between Snowflake/Stake , OLTP/OLAP. When to use what.

Once you clear the 1st round, they will schedule the next 4 rounds.
Coding + System Design Round

1. Similar to Word Search (https://leetcode.com/problems/word-search/description/)
2. Rank Team by Votes, instead of characters, he asked me to keep a string for team votes and get top 3 teams with the highest votes. Link
3. Database Design for Confluence - Consider Tag,likes, dislikes views. Find most interacted page.

Product Sense Round
Scorecard Design(problem statement was bit lengthy but this was the main question )
Functional and Non Functional requirements with high level diagram,
API Design including Protocols
Database design and some usecase query.

Management Round
It's a deep dive into the projects coupled with management fit in the team.

Cultural And Values Fit
Atlassian doesn't hire for a specific team, the process remains the same across all the teams which make it easier to switch between teams in case you are not happy once you join. Pretty standard HR questions. Try to inoculate the STAR Values and the Company's values into your answers

The recruiter would follow up with you to mention all the questions that are going to be involved in each round. The recruiters at Atlassian are really nice and thorough.