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.
Interview questions [1]
Question 1
Guesstimate question to get the number of the ATM machine
I applied through a recruiter. The process took 5 days. I interviewed at Mastercard (Mumbai) in Jun 2024
Interview
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.
I applied online. The process took 3 weeks. I interviewed at Mastercard (Dublin, Dublin) in Jun 2023
Interview
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
Interview questions [1]
Question 1
Describe your current experience, then technical questions about SQL, Data warehouse design, Python, Spark
