Recruiter reached me after reviewing my application, then a first interview with Hiring Managers was scheduled. After that I received a message to inform me that the hiring team wanted to go through a 2nd round interview. It was scheduled one week after. One day before that 2nd interview i was informed it was cancelled because an interviewer was not available. Recruiter told me they will reach out "shortly" to reschedule. Then radio silence, 2 weeks after received an informal email informing me they decided to move with another candidate. I would expect more professionalism and clearer communication from Mastercard

I was asked some basic mathematical questions and simple questions on SQL, programming and logical puzzles. There were not many difficult or completely puzzling questions. But you should have good understanding of the conceptual knowledge of databases, sql, ETL.