I applied through university. The process took 2 weeks. I interviewed at Mastercard (Pittsburgh, PA) in Sep 2017
Interview
First round is to check the knowledge about database design and SQL query; Second round is to analyse business case involving market size question; the questions are not very hard, but it's important to show both your technical skills and business sense during the interview.
Interview questions [1]
Question 1
Redesign the database for a book store. Write a query to get data for each group.
I applied through university. The process took 1 day. I interviewed at Mastercard (College Station, TX) in Oct 2018
Interview
Talked to the company at Career Fair and later applied online. Got a call for Campus Interview. Didn't make it to the second round which was supposed to happen at their headquarters.
Interview questions [1]
Question 1
One Case-Study question which was related to designing a database. They wanted to know the overall thinking process
I applied online. The process took 5 weeks. I interviewed at Mastercard (San Francisco, CA) in Sep 2018
Interview
3 rounds total. First round was on campus, covered past projects/internships, some basic SQL questions, and a market sizing question. Second round was in the SF office, went over past internship experience and a database design case with some related SQL questions. Final round was in the Arlington office. It consisted of four 45 minute interviews. I had one creative data one, two business cases, and one database design case. Overall a really great experience, everyone was very friendly and helpful!
Interview questions [2]
Question 1
Design a database for your favorite messaging app.
I applied through university. The process took 2 weeks. I interviewed at Mastercard in Oct 2017
Interview
I applied through my college and got offered an on campus interview. The interview was only 30 minutes and consisted of about 1 behavioral question, two database questions, and a market-sizing question. The interviewer was very nice and helpful during the case.