Mastercard interview questions

The first interview was over the phone with the human resources department and took around twenty minutes; they called to conduct a preliminary interview and then scheduled the formal interview. The second interview was with the hiring agent in the department in which the internship was located; this was a week after the preliminary interview and took approximately thirty minutes.

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.