Dataford
Top 11
Prep plan
Updated weekly · Last refresh Aug 30

Michael Page Data Engineer Interview Questions

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

11questions
~2htotal time
Track your progressSign up free to work through all 11 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 5 questions + 3 drills · ~74 min
Difference Between WHERE and HAVING ClausesEasy

Explain the differences between WHERE and HAVING clauses in SQL and when to use each.

JoinsData WranglingAggregationsMichael Page
Customer Orders: LEFT vs INNER JOINEasy

Explain how INNER JOIN and LEFT JOIN differ, and when to use each for matched-only versus all-left-row analysis.

JoinsData WranglingGroup ByMichael Page
Optimizing Slow SQL QueriesHard

Tests query tuning methodology, including execution plans, indexing, and rewrite strategies.

performancequery optimizationsqlMichael Page
Aggregating Monthly MetricsMedium

Tests SQL query structuring for time-based aggregation and metric rollups.

aggregationData AnalysissqlMichael Page
SQL Bookstore Schema PracticeEasy
Practice
Practice drill

Use a CTE, joins, and distinct aggregates to calculate Meta Logistics bookstore payment metrics.

sql queriessqlpythonMeta Logistics
SQL Join and Group By PracticeHard
Practice
Practice drill

Join SAT data, aggregate monthly center performance, and compare average scores with LAG.

JoinsGroup BysqlThe College Board
Second-Highest Salary SQLMedium
Practice
Practice drill

Find the second-highest salary and department statistics using DENSE_RANK, LEFT JOIN, GROUP BY, and aggregate functions.

JoinsGroup Bysqlairtel
More SQL & Data Manipulation questions with a free account
2
Coding4 questions · ~35 min
Optimizing Python Memory UsageMedium

Tests Python performance and memory optimization techniques for large in-memory data structures.

memoryData StructurespythonMichael Page
Lists vs Tuples PerformanceEasy

Tests understanding of Python data structures and practical tradeoffs.

performanceData StructurespythonMichael Page
Normalizing Messy StringsMedium

Tests data cleaning skills for standardizing inconsistent text fields in Python.

data cleaningnormalizationpythonMichael Page
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
More topics2 questions · ~17 min
String Cleaning in Raw DataMedium

Tests practical approach to text cleaning and data quality improvements for downstream analytics.

data cleaningstring manipulationpythonMichael Page
More questions with a free account
The finish line: interview-readyComplete all 11 questions plus 3 hands-on drills to finish this plan.