Top 16

Prep plan

Updated weekly · Last refresh Oct 17

Oliver Wyman Data Engineer Interview Questions

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

16questions

~2htotal time

Track your progressSign up free to work through all 16 questions and resume where you left off.

Start practicing free →

SQL & Data ManipulationStart here. 7 questions + 3 drills · ~87 min

Star vs Snowflake for Sales AnalyticsMedium

Compare star and snowflake schemas for warehouse design, including trade-offs in normalization, query simplicity, and analytics performance.

JoinsData WranglingGroup By

Oliver Wyman

Writing Complex SQL QueriesHard

Tests your skill in constructing advanced SQL for real analytical datasets.

complex queriessql

Oliver Wyman

Reviewing SQL and CodeMedium

Assesses your ability to review and reason about SQL and Python code quality and correctness.

sqlpython

Oliver Wyman

Analyze Customer Purchase Trends with Window FunctionsEasy

Practice

Practice drill

Calculate the monthly spending trends for customers using window functions and joins.

The Home Depot

Aviso

Hewlett Packard Enterprise

Deep SQL and Recursion InterviewHard

Practice

Practice drill

Compare monthly billable hours across employees while joining managers, departments, and projects.

Lag/LeadJoinscomplex queries

Cognizant

DBMS and Data ManipulationMedium

Practice

Practice drill

Model related policy and claim data, then summarize approved claims while preserving policyholders without claims.

Joinssqldatabase design

Sun Life Financial

More SQL & Data Manipulation questions with a free account

Pipelines3 questions · ~24 min

Data Quality in ETL PipelinesEasy

Approach for maintaining data quality and integrity across ETL pipelines.

IdempotencyData ModelingQuality

Oliver Wyman

Python and Pipeline ConceptsHard

Assesses Python fundamentals and your understanding of data pipeline design choices.

ETLsqlpython

Oliver Wyman

Scalable Real-Time IngestionHard

Tests your ability to architect reliable streaming ingestion for analytics and decisioning.

Stream Processingscalabilitydata ingestion

Oliver Wyman

Sign up to see every question

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

Get my prep plan

Behavioral & Leadership5 questions · ~41 min

Choosing Consulting for Data EngineeringEasy

Tests motivation for consulting, alignment of career goals, and readiness for client-facing data engineering work.

career goalscompany fitmotivation

Oliver Wyman

More Behavioral & Leadership questions with a free account