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.
Preguntas de entrevista [1]
Pregunta 1
Guesstimate question to get the number of the ATM machine
Me postulé a través de un reclutador. El proceso tomó 5 días. Acudí a una entrevista en Mastercard (Mumbai) en jun 2024
Entrevista
Recruiter Screen - Mentioned it will be a storytelling technical round
Team Member - 30mins interview on Tableau (he was very helpful and altered his questions to help me get the answer).
Another round of advanced Tableau
Final round with the VP of the team
if you have the following
Category | Sub-Category | Sales for Sub-Category |
How do you calculate the total sales for each category
Sub Question - What are the different types of LOD
If you have Category (Columns), Sub-Category (Rows), and Sales in the Text card; how do you highlight the min and max sales for each category with red and green color? The rest of the sales need to stay blue/ default color.
Me postulé en línea. El proceso tomó 3 semanas. Acudí a una entrevista en Mastercard (Dublín, Dublín) en jun 2023
Entrevista
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
Preguntas de entrevista [1]
Pregunta 1
Describe your current experience, then technical questions about SQL, Data warehouse design, Python, Spark