Top 41
Prep plan
Updated weekly · Last refresh Oct 17

Atlassian Data Engineer Interview Questions

The questions to prepare for a Atlassian Data Engineer interview. Questions from real interview reports rank first. Updated daily.

41questions
~9htotal time
Track your progressSign up free to work through all 41 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 11 questions · ~139 min
Write a SQL query to find 2nd-degree connections (friends of friends) for usersMedium
Practice

Find each user's friends of friends, excluding direct connections and the user themselves.

data relationshipsJoinscomplex queriesAtlassian
Reverse the words in a sentenceMedium
Practice

Reverse the word order of each sentence using PostgreSQL string processing and return one result per input row.

data cleaningData ManipulationData WranglingAtlassian
More SQL & Data Manipulation questions with a free account
2
Coding12 questions · ~152 min
Fetch data from an API and build a 2-dimensional list with some of the attributes, appl...Medium
Practice

Convert API records into a 2D list by selecting fields and applying string, status, and collection transformations.

api integrationapiArray ManipulationAtlassian
Merge overlapping intervals (Python)Medium
Practice

Sort intervals and merge overlapping or adjacent ranges into a minimal ordered list.

ArraysArray ManipulationAlgorithmsAtlassian
More Coding questions with a free account

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan
3
Pipelines4 questions · ~51 min
Star vs Snowflake for AnalyticsMedium
Recently asked

Compare star and snowflake schemas, then select the appropriate model for analytics workloads and pipeline requirements.

ETLdata warehouseData ModelingAtlassian
Design a Real-Time Data PipelineHard
Recently asked

Design a reliable real-time pipeline for Atlassian analytics and reporting with low latency, quality controls, recovery, and scalable serving.

Data Qualitydata pipelinedata latencyAtlassian
More Pipelines questions with a free account
4
Behavioral & Leadership12 questions · ~152 min
More Behavioral & Leadership questions with a free account
5
More topics2 questions · ~25 min
Design a data model for a simplified version of Jira that tracks issue state changes ov...Hard

Design a Jira data model that preserves complete issue state history using a star schema, medallion architecture, and SCD Type 2.

data ingestiondesignarchitecture patternsAtlassian
Design a High-Level Event SystemHard

Design an ML-enabled system that ingests millions of events from thousands of sources with reliable processing and monitoring.

distributed systemsscalabilitydata ingestionAtlassian
The finish line: interview-readyComplete all 41 questions to finish this plan.