Top 28
Prep plan
Updated weekly · Last refresh Aug 30

Akamai Data Analyst Interview Questions

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

28questions
~4htotal time
Track your progressSign up free to work through all 28 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 5 questions + 3 drills · ~70 min
Clustered vs Non-Clustered IndexesMedium

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

JoinsData WranglingAkamai
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
Most Efficient Sorting AlgorithmMedium

Evaluates your understanding of algorithm efficiency and time complexity tradeoffs.

time complexityAkamai
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: 100th Element QueryEasy
Practice
Recently asked
Practice drill

Use generate_series, a CTE, and a join to return the 100th Akamai service element with product metadata.

sqlAkamai
Second Highest Without AggregatesHard
Practice
Recently asked
Practice drill

Find the second highest salary in each department without using aggregate functions.

SubqueriesRankingSelf-JoinsCredit GenieDevoteamCisco Restaurant + Bar
Pivot Lucid Campaign Performance by MonthMedium
Practice
Practice drill

Use joins, a CTE, CASE expressions, and monthly pivoting to compare Lucid campaign performance across channels.

pivot tablesnull handlingData WranglingLucid Motors

Sign up to see every question

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

Get my prep plan
2
Behavioral & Leadership23 questions · ~184 min
Correcting a Critical Data AnomalyMedium

Tests ownership and analytical rigor in finding, fixing, and preventing a data anomaly with business impact.

Data WranglingProblem Solvingtechnical experienceAkamai
Handling Tough Feedback Under PressureEasy

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

resiliencefeedbackpressureAkamai
Prioritizing Competing Data RequestsMedium

Tests prioritization under pressure in a data engineering context, including stakeholder management, trade-off decisions, and ownership of outcomes.

Decision MakingStakeholder ManagementPrioritizationAkamai
More Behavioral & Leadership questions with a free account
The finish line: interview-readyComplete all 28 questions plus 3 hands-on drills to finish this plan.