Round 1: Coding Round 1
Questions:
- Similar to Group Anagrams
- SQL (medium)
- Data Theory: difference between Snowflake/Stake, OLTP/OLAP. When to use what.
Candidate's Approach
No approach provided.
Interviewer's Feedback
No feedback provided.
Round 2: Coding Round
Questions:
- Similar to Word Search
- Rank Team by Votes: Instead of characters, keep a string for team votes and get top 3 teams with the highest votes.
- Database Design for Confluence: Consider Tag, likes, dislikes views. Find the most interacted page.
Candidate's Approach
No approach provided.
Interviewer's Feedback
No feedback provided.
Round 3: System Design Round
Questions:
- Scorecard Design: The problem statement was a 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 use case query.
Candidate's Approach
No approach provided.
Interviewer's Feedback
No feedback provided.
Round 4: Management Round
Questions:
- Deep dive into the projects coupled with management fit in the team.
Candidate's Approach
No approach provided.
Interviewer's Feedback
No feedback provided.
Round 5: Cultural And Values Fit
Questions:
- Atlassian doesn’t hire for a specific team; the process remains the same across all teams, making it easier to switch between teams if needed.
- Standard HR questions. Emphasize the STAR Values and the Company’s values in your answers.
Candidate's Approach
No approach provided.
Interviewer's Feedback
No feedback provided.