Dataford
Top 18
Prep plan
Updated weekly · Last refresh Sep 10

Macy's Data Engineer Interview Questions

The questions to prepare for a Macy's Data Engineer interview. Questions from real interview reports rank first. Updated daily.

18questions
~3htotal time
Track your progressSign up free to work through all 18 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 5 questions + 2 drills · ~69 min
SQL Duplicate Record DetectionEasy
Practice

Find duplicate American Institutes for Research assessment submissions using a CTE, GROUP BY, HAVING, and joins.

deduplicationsqldata integrityMacy's
SQL and Python Work ExamplesMedium

Assesses practical experience combining SQL and Python for data transformation and analysis.

sqlpythonMacy's
Optimizing Slow SQL QueriesMedium

Tests query tuning skills and understanding of performance bottlenecks.

SubqueriesJoinsAggregationsMacy's
Monthly Sales Trends by CategoryMedium
Practice
Practice drill

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

InfrastructureToolsData WranglingTotal Wine & MoreInc.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 ModelingADP
More SQL & Data Manipulation questions with a free account
2
Pipelines11 questions · ~107 min
Optimize Multi-Terabyte ETL PipelineMedium

Explain how you improved a slow ETL pipeline on multi-terabyte data, including bottleneck analysis, tuning choices, and validation.

ETL optimizationdata processingperformanceMacy's
Data Modeling Tools and ArchitectureEasy

Preferred tools and patterns for data modeling and pipeline architecture in a modern data platform.

InfrastructureToolsData ModelingMacy's
Describe a Complex Transformation PipelineMedium

Explain a complex ETL transformation you built, including the main challenges and how you handled them.

ETLData ModelingQualityMacy's
More Pipelines questions with a free account
3
More topics2 questions · ~19 min
Merging Dictionaries in PythonEasy
Practice

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

Hash TablesArraysStringsMacy's
Choosing Data Structures at ScaleEasy

Explain which data structures work best for large datasets based on access patterns, memory use, and update costs.

Hash TablesArraysHeapMacy's

Sign up to see every question

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

Get my prep plan
The finish line: interview-readyComplete all 18 questions plus 2 hands-on drills to finish this plan.