Top 25
Prep plan
Updated weekly · Last refresh Oct 16

Akamai Data Analyst Interview Questions

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

25questions
~4htotal time
Track your progressSign up free to work through all 25 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 6 questions + 2 drills · ~71 min
Optimizing Large Transaction Table JoinsHard

Explain how to tune a slow PostgreSQL query that joins several large transaction tables using indexes, join strategy, and partitioning.

JoinsperformancesqlAkamai
Clustered vs Non-Clustered IndexesMedium

Explain how clustered and non-clustered indexes differ in storage, lookup behavior, and query performance.

JoinsData WranglingAkamai
Most Efficient Sorting AlgorithmMedium

Evaluates your understanding of algorithm efficiency and time complexity tradeoffs.

time complexityAkamai
Top Servers Per RegionMedium
Practice

Use window functions to return the three highest-traffic Akamai servers within each region.

Window FunctionsJoinsData ManipulationAkamai
Normalize vs Denormalize LoggingHard

Tests tradeoffs in schema design for large-scale logging and performance considerations.

performancenormalizationData ModelingAkamai
Clean Duplicate Network LogsMedium

Tests SQL skills for deduplication, data quality, and safe cleanup patterns.

null handlingData Wranglingdata validationAkamai
SQL Joins in ScenariosMedium
Practice
Practice drill

Combine property and request data to report successful request counts and bytes, including properties with no matching requests.

null handlingJoinssqlAkamai
Nth Salary SQLMedium
Practice
Recently asked
Practice drill

Use ranking to return the nth distinct salary from an employee table.

system designnull handlingsqlBBirdeyeDDatafortuneCisco
2
Behavioral & Leadership18 questions · ~153 min
Handling Tough Feedback Under PressureEasy

Tests how you absorb feedback under pressure, adapt quickly, and turn criticism into improved performance.

resiliencefeedbackpressureAkamai
More Behavioral & Leadership questions with a free account
3
More topics1 question · ~8 min
The finish line: interview-readyComplete all 25 questions plus 2 hands-on drills to finish this plan.