Atlassian (P40)
Summary
I interviewed at Atlassian for a P40 position, undergoing five rounds including coding, system design, management, and cultural fit, finding the recruiters very helpful and organized throughout the process.
Full Experience
I recently went through the interview process at Atlassian for a P40 level role. The entire process was well-structured and quite thorough, consisting of five distinct rounds. After successfully clearing the initial coding round, I proceeded to four subsequent rounds covering more coding challenges, system design, management, and cultural fit. The recruiters were exceptionally professional and detailed, proactively communicating all the questions I should expect in each upcoming round, which was incredibly helpful.
Interview Questions (6)
I was asked conceptual questions regarding data theory, specifically differentiating between Snowflake and Stake, and also between OLTP and OLAP, including scenarios on when to use each.
The interviewer presented a problem where I had to rank teams by votes. Uniquely, instead of simple numerical counts, I was asked to process a string representing team votes and then identify the top 3 teams based on the highest vote count derived from this string.
My task was to design a database schema specifically for Atlassian Confluence. The design needed to account for various features such as tags, likes, dislikes, and views, with an explicit requirement to efficiently find the most interacted page.
I was given a lengthy problem statement to design a Scorecard System. This comprehensive task involved defining both functional and non-functional requirements, creating a high-level architectural diagram, designing APIs along with appropriate protocols, outlining the database design, and formulating some use-case queries.
Preparation Tips
For the Cultural and Values Fit round, I focused on preparing for standard HR questions. A key piece of advice I received was to integrate Atlassian's company values and the STAR method into my answers, demonstrating how my experiences align with their culture.