18 practice questions for Atlassian Data Engineer interviews
Atlassian data engineer interviews cover ETL pipelines, data modelling, SQL optimisation, distributed systems like Spark and Kafka, and warehouse architecture.
Category: Interval-based coding problem# Question Given a list of people who enter and exit, find the people who entered without their badge and who exited without their badge. This...Input: List Output: Array
codingMediumVerified Question#2
2. Agent Vote
Category: String coding problem# Question Design a Customer Support Ticket System that allows customers to rate support agents on a scale of 1 to 5. You need to implement...Input: List Output: Array
codingMediumVerified Question#3
3. Middleware Router
Category: String coding problem# Question We want to implement a middleware router for our web service, which based on the path returns different strings. This problem is split...Input: String Output: Computed result
codingHardVerified Question#4
4. Tennis Court Bookings
Category: Algorithm coding problem# Question The input is a list of tennis court bookings, where each booking includes a start and end time. You need to write a program that assigns...Input: List Output: Integer
codingEasyVerified Question#5
5. Word Wrap
Category: String coding problem# Question Implement a function that formats a list of words into lines, separating them with hyphens, while ensuring no line exceeds a maximum...Input: Array of strings Output: Computed result
codingMediumVerified Question#6
6. Design Rate Limiter
Category: Sliding window coding problem# Design Rate Limiter Design a rate limiter system that controls the number of requests allowed within a specified time window. The rate limiter is...Input: String Output: Computed result
codingMediumVerified Question#7
7. Running Commodity Price
Category: Trie-based coding problemYou are given a stream of data points consisting of <timestamp, commodityPrice>. You need to design a data structure that supports upserting...Input: Given input Output: Integer
codingMediumVerified Question#8
8. Shuttle Route Pickup
Category: Graph coding problem# Question Two shuttle buses travel different road networks to reach a festival campsite, picking up passengers at stops along the way. Each bus...Input: Graph (nodes and edges) Output: Computed result
codingMediumVerified Question#9
9. Storage Hierarchy Stats
Category: Trie-based coding problem# Question Design a StorageHierarchyStats class that manages documents organized into labeled buckets. Buckets can have parent-child relationships...Input: List Output: Computed result
codingMediumVerified Question#10
10. Path Router
Category: Algorithm coding problem# Question Design a PathRouter class that maps URL-like path patterns to handler names. Patterns may contain wildcard segments (*) that match any...Input: Number(s) Output: Computed result
codingEasyVerified Question#11
11. Snowpack Trail
Category: Array coding problem# Question You are planning a hiking trip along a trail represented as an elevation array. Snow accumulates or melts on the trail each day according...Input: Array Output: Computed result
codingMediumVerified Question#12
12. Rocket Launch Board
Category: Algorithm coding problem# Question You are building a simulator for a board game called Rocket Launch. The board has numbered squares from 1 to boardSize. On each...Input: Number(s) Output: Computed result
codingEasyVerified Question#13
13. Anagram Substring Search
Category: String coding problem# Question You are given a list of keywords and a text string t. Return the first keyword from the list such that any anagram of that keyword...Input: List Output: Computed result
codingMediumVerified Question#14
14. Worm Game
Category: Grid/matrix coding problem# Question Design a WormGame class that simulates a worm moving on a 2D grid. The worm starts at the top-left corner (0, 0) with length 1. It...Input: 2D grid Output: Computed result
codingMediumVerified Question#15
15. Jump Board
Category: Array coding problem# Question You are given a 1D board represented as an array of instruction strings. You start at index 0. On each step, you follow the instruction at...Input: Array Output: Computed result
codingMediumVerified Question#16
16. Plan Billing
Category: Algorithm coding problem# Question Design a PlanBilling class that tracks subscription charges on a daily basis and provides monthly and annual billing summaries....Input: Given input Output: Computed result
codingMediumVerified Question#17
17. Racing Lap Stats
Category: Algorithm coding problem# Question You are analyzing race lap data for a set of drivers. Each driver has a list of lap times and a set of laps flagged as pit-stop laps...Input: List Output: Computed result
codingEasyVerified Question#18
18. Warehouse Trip Saver
Category: Algorithm coding problem# Question A warehouse is organized into sections. Each product belongs to exactly one section. An employee has a pick list of products to collect....Input: List Output: Integer