Top 24

Prep plan

Updated weekly · Last refresh Oct 27

Marks & Spencer Data Engineer Interview Questions

The questions to prepare for a Marks & Spencer Data Engineer interview. Questions from real interview reports rank first. Updated daily.

24questions

~4htotal time

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

Start practicing free →

CodingStart here. 3 questions · ~28 min

Merging DictionariesEasy

Practice

Merge two Macy's catalog dictionaries into a new dictionary, with values from the second dictionary overriding duplicate keys.

Hash TablesArraysStrings

Marks & Spencer

SQL and Python CodingMedium

Assesses ability to implement a SQL solution and use object-oriented Python effectively.

sqlpython

Marks & Spencer

More Coding questions with a free account

Pipelines15 questions · ~141 min

Python for ETL Pipeline TasksEasy

Discuss Python scripting experience for ETL, orchestration, and data quality tasks in data pipelines.

InfrastructureToolsETL

Marks & Spencer

Large-Scale Data Pipeline ChallengesMedium

Discuss the main pipeline challenges that appear as data volume, velocity, and system complexity grow.

InfrastructureQuality

Marks & Spencer

Model Analytics Warehouse for RetailEasy

Design an ELT pipeline and warehouse data model in Snowflake for retail analytics, including dimensional modeling, orchestration, and data quality.

InfrastructureData ModelingQuality

Marks & Spencer

More Pipelines 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

SQL & Data Manipulation6 questions + 3 drills · ~87 min

SQL vs NoSQL for Go-to-Market DataEasy

Explain how SQL and NoSQL differ in schema, consistency, scaling, and Demandbase-style analytics use cases.

JoinsData Wrangling

Marks & Spencer

SQL Query With PythonMedium

Evaluates practical skills combining SQL and Python for data manipulation.

sqlpython

Marks & Spencer

Optimize SQL PerformanceMedium

Tests query optimization techniques and performance troubleshooting in SQL.

indexingJoinsAggregations

Marks & Spencer

Handling Missing DataEasy

Practice

Practice drill

Replace missing sales fields with defined defaults and return a consistently ordered dataset.

missing valuesdata cleaningnull handling

University of Minnesota

The Home Depot

Nationwide

Monthly Sales Trends by CategoryMedium

Practice

Practice drill

Aggregate monthly sales by product category and use LAG to calculate month-over-month changes.

InfrastructureToolsData Wrangling

Total Wine & More

Inc.

Benjamin Moore

Contact Center Agent Performance MetricsHard

Practice

Practice drill

Compute daily agent call KPIs and SLA using joins, aggregations, and window ranking in a contact center model.

ETLAggregationsData Modeling

ADP

More SQL & Data Manipulation questions with a free account

The finish line: interview-readyComplete all 24 questions plus 3 hands-on drills to finish this plan.