Mastercard
Practice questions for the skills this job lists, plus common questions for any interview. These are for practice: we don’t know the employer’s actual questions.
Write a query for the second-highest salary in each department.
SQL
Explain the difference between INNER, LEFT and FULL joins with an example.
SQL
How would you design a paginated, versioned REST API? Which status codes would you return?
REST APIs
What is DAX, and how do measures differ from calculated columns?
Power BI
Walk me through a project you built: the design, a hard bug and what you'd change.
This kind of role
Reverse a linked list, then explain its time and space complexity.
This kind of role
How would you design a URL shortener?
This kind of role
What do you know about Mastercard's products and customers?
Mastercard
Tell me about yourself in two minutes, focused on this role.
About you
Why this company, and why this role?
About you
Tell me about a time you disagreed with a teammate. What happened?
About you
Describe a time you failed or missed a deadline, and what you changed afterwards.
About you