Dataford
Dataford
Top 26
Prep plan
Updated weekly · Last refresh Oct 17

Mastercard Data Engineer Interview Questions

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

26questions
~5htotal time
Track your progressSign up free to work through all 26 questions and resume where you left off.
Start practicing free →
1
System DesignStart here. 6 questions · ~67 min
Delta Lake ArchitectureHard

Explain Delta table architecture, transaction logs, ACID guarantees, and practical Databricks use cases.

cloud architecturedistributed systemsdata ingestionMastercard
File Formats in Data LakesMedium

Explain how Parquet, ORC, CSV, and Avro differ, including storage layout, schema handling, performance, and appropriate use cases.

industry standardsdata ingestionoffline syncMastercard
More System Design questions with a free account
2
SQL & Data Manipulation5 questions · ~56 min
Top Nth Salary Without LIMITMedium
Practice

Find the Nth distinct highest salary using PostgreSQL ranking without LIMIT.

Data Manipulationsql querysalaryMastercard
Window Functions in PracticeHard
Practice

Demonstrate ranking, partitioned totals, and running totals with PostgreSQL window functions.

Window FunctionsData Manipulationdatabase queryingMastercard
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
Pipelines8 questions · ~89 min
ETL and Stored Procedures BasicsHard

Explain stored procedures and ETL, compare their roles, and outline a practical pipeline using SQL and Apache Airflow.

data pipelinestored proceduresETLMastercard
Optimize Slow Spark PipelinesHard

Diagnose and optimize a slow Spark pipeline by identifying bottlenecks, reducing shuffle, correcting skew, and tuning execution resources.

distributed computingdata skewnessbottleneck optimizationMastercard
More Pipelines questions with a free account
4
Behavioral & Leadership5 questions · ~56 min
More Behavioral & Leadership questions with a free account
5
More topics2 questions · ~22 min
Find Transaction IDs Not in Second ListEasy
Practice

Identify transaction IDs that are in the first list but not in the second list.

Hash TablesArraysSearchingMastercard
Parsing Logs With PythonMedium
Practice

Parse log lines into tokens and count selected error codes using a hash map.

aggregationCodingData ManipulationMastercard
The finish line: interview-readyComplete all 26 questions to finish this plan.