Top 32
Prep plan
Updated weekly · Last refresh Aug 30

Milliman Data Engineer Interview Questions

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

32questions
~5htotal time
Track your progressSign up free to work through all 32 questions and resume where you left off.
Start practicing free →
1
CodingStart here. 5 questions · ~46 min
Reverse Linked List or Detect CyclesMedium
Practice

Detect cycles with Floyd's algorithm, then reverse an acyclic Kraft Heinz product feed linked list in place.

Linked ListstraversalpythonMilliman
Four Principles of OOPEasy

Explain encapsulation, abstraction, inheritance, and polymorphism with examples and simple Java illustrations.

javaabstractionoopMilliman
Generator vs List ComprehensionMedium

Compare generator expressions and list comprehensions by memory usage, execution model, and when each is preferable.

memory managementloopspythonMilliman
More Coding questions with a free account
2
SQL & Data Manipulation7 questions + 2 drills · ~84 min
Longest Consecutive Login Streak per UserHard
Practice

Calculate the longest consecutive login streak for each user using window functions and date manipulations.

Window FunctionsJoinsAggregationsMilliman
Explain Full Outer vs Left JoinMedium

Explain how FULL OUTER JOIN and LEFT JOIN differ when reconciling customer records across systems.

JoinsData WranglingCase WhenMilliman
Normalization vs Denormalization TradeoffsMedium

Explain normalization, why it improves data integrity, and when denormalization is a practical performance tradeoff.

schema designperformanceData ModelingMilliman
Second Highest Without AggregatesHard
Practice
Practice drill

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

SubqueriesRankingSelf-JoinsCredit GenieDevoteamCisco Restaurant + Bar
Advanced SQL With PartitionsHard
Practice
Practice drill

Use CTEs, aggregations, and window functions to compare gender pay and find each department's second-highest salary.

Window FunctionsJoinssqlMeesho
More SQL & Data Manipulation 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
Pipelines5 questions · ~46 min
Handle PySpark Data SkewMedium

Approach for detecting and mitigating skew in PySpark pipelines using partitioning, join strategies, and runtime monitoring.

Data Qualitypysparkdata skewnessMilliman
PySpark Transformations vs ActionsMedium

Tests Spark concepts like lazy evaluation and how they affect execution planning and performance.

transformationsperformancesparkMilliman
More Pipelines questions with a free account
4
Behavioral & Leadership15 questions · ~137 min
More Behavioral & Leadership questions with a free account
The finish line: interview-readyComplete all 32 questions plus 2 hands-on drills to finish this plan.