Atlassian Interview Questions
Master your tech interview with our curated database of real questions from top companies.
Identify Top-3 Users by Recent Total Spend
Users +----+-------+-------------+ | id | name | joined_date | +----+-------+-------------+ | 1 | Alice | 2023-01-02 | | 2 | Bob | 2023-02-14 |...
Expand Internationally: Data and Strategy for Market Entry
Behavioral + Product Sense (Onsite) Context You are interviewing for a Data Scientist role at a product-led software company. In this onsite round, yo...
Diagnose Checkout Rate Drop: Steps and Analyses
Scenario A core product metric (checkout-completion rate) shows an unexpected change. Leadership needs a root-cause analysis and action plan within ho...
Implement Real-Time Rate Limiting for Web Service Requests
Scenario A web service must throttle traffic from clients; you need to decide in real-time whether each incoming request should be served or rejected ...
Minimize L1 Distance with k Cluster Centers in Array
1D k-Center (Minimax L1) Clustering Problem You are given an array of n integers on a number line and an integer k (1 ≤ k ≤ n). Place k cluster center...
Minimize max L1 radius with k centers in 1D
You are given an array A of n integers (values may be negative and may repeat) and an integer k (1 ≤ k ≤ n). Place k cluster centers anywhere on the r...
Implement sliding-window rate limiter with dual thresholds
Implement getRequestStatus(urls: List[str]) -> List[str]. The i-th entry in urls represents a single incoming request at timestamp t = i seconds (t st...
Demonstrate motivation, feedback, and prioritization
Behavioral & Leadership STAR Prompts (Data Scientist — Technical Screen) Context: You are preparing for a Data Scientist technical screen at Atlassian...
Train and evaluate logistic model with regularization
Binary Classification with Logistic Regression and Regularization Data - Two CSVs: a training set x and a test set x_test. - Each has 7 columns: - C...
Label game performance by margin
Given a games DataFrame (or R data.frame) with columns: team_id, opponent_team_id, team_score, opponent_team_score, write code to: (1) Define a functi...
Rank each team’s top 3 scores in 2024
Using the same schema, compute each team’s top 3 highest-scoring games for season_year = 2024, treating each game from BOTH teams’ perspectives (i.e.,...
Find 2023 NCAA championship winner
You are given two tables. Schema: team(team_id INT PRIMARY KEY, team_name TEXT); game(game_id INT PRIMARY KEY, team_id INT, opponent_team_id INT, date...
Implement snake game and find org LCA
Part A — Snake Game Engine: Implement a grid-based snake game. The board has height H and width W (0-indexed, row-major). The snake starts at (0, 0) m...
Design crawler storing only image URLs
System Design: Image-URL Crawler (URLs only, no HTML storage) Context Design a production web crawler that fetches HTML pages and extracts only image ...
Implement wildcard URL router
Question Implement a URL routing matcher that supports wildcard segments (e.g., '/a/*/c') using a trie. Discuss time and space complexity, show how to...
Find LCA in organization tree
Question Given an organizational hierarchy tree, return the lowest common organization (parent node) for two or more employees (≥ 2). Provide unit tes...
Design a scalable tagging system
System Design: Scalable Tagging Service Context You are designing a multi-tenant tagging service for a large-scale SaaS product. Items (e.g., document...
Design a trie-based URL router with wildcards
Implement a URL routing matcher that supports adding route patterns and matching request paths. Use a trie as the core data structure. Support static ...
Ensure thread-safe updates to org hierarchy
Thread-safe Organization Hierarchy: API, Concurrency, and Consistency Context You are building an in-memory organization directory that manages groups...
Find nearest common manager for multiple employees
Given an organizational hierarchy modeled as a rooted tree, build the tree from (employee, manager) pairs and implement a function that, for k ≥ 2 emp...