J'ai postulé en ligne. Le processus a pris 1 semaine. J'ai passé un entretien chez Mastercard en juill. 2024
Entretien
The HR reached out to me and scheduled the interview the same afternoon, the first round was SQL only questions were on joins and window functions one question on what would be the output for a left and right join , then 2 medium hard questions on window functions and one very hard question on window functions
Questions d'entretien [1]
Question 1
out put of left join & right join
brand which the contionous increasing order of sales (window function)
status change in log data (window function)
J'ai postulé en ligne. J'ai passé un entretien chez Mastercard (Pune) en nov. 2025
Entretien
1) They took in person interview.
2) Interviewer was mostly interested in Theocratical questions rather than technical questions.
3) Based on basic questions only they will judge and expect to know all answers in details. In my case I worked on 7-8 related techs but interviewer was only familiar with 2 so he was expecting answers more in theoretical or bookish kind of answers.
Basically this particular interviewer was more interested in typical definitions rather than focusing on actual experience questions. Even though these companies are slow on adapting new tech and he was thinking in terms of you should be able to implement new tech. My questions is now if you are not able to use current tech in market you are 10 years behind when you are going to implement tomorrows tech? Haha!
Questions d'entretien [1]
Question 1
What is need of Data warehousing?
How things evolved till this stage in Big data?
How Delta tables achieve ACID transactions?
J'ai postulé en ligne. J'ai passé un entretien chez Mastercard
Entretien
The interview went well. The interviewer was friendly and easy to talk to. I enjoyed the conversation and learned a lot. I learned a lot about the role and the team's goals, and I believe my skills and experience would be a good fit.
3 rounds, one phone screening, one behavioral, and then one technical in person. The process was lengthy in terms of time but was not extremely difficult, they asked a lot of statistic and scenario based questions of how I would solve a problem
Questions d'entretien [1]
Question 1
What does the r-squared value in a regression model mean?