I applied through college or university. The process took 2 weeks. I interviewed at Mastercard (Arlington, VA) in Feb 2016
Interview
First round screening as on campus then final round in Arlington VA, Full day, four rounds of 45 minutes each. Business case, no market sizing, SQL, Normalization. SQL on how to rank sales such that all values of sales $ are in the same group. i.e. you cannot just use NTILE. Other SQL questions were simple, SUM|Count.
Interview questions [1]
Question 1
SQL, Resume questions, Business case questions. Schema generation and SQL on generated schema.
I applied through college or 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 college or 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.
