Upload Button Icon Add office photos

MasterCard

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

MasterCard Data Analyst Interview Questions, Process, and Tips

Updated 16 Jan 2025

Top MasterCard Data Analyst Interview Questions and Answers

  • Q1. Guesstimate the number of people travelling by local metro in mumbai
  • Q2. Reliance fresh wants to open a store in north-eastern part of India. Should it or should it not?
  • Q3. If the 3rd position in a string contains 'b' replace it with 'v'

MasterCard Data Analyst Interview Experiences

3 interviews found

Data Analyst Interview Questions & Answers

user image sameer kulkarni

posted on 16 Jan 2025

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. SQL case study for data
  • Q2. Find nth salary
  • Ans. 

    To find the nth salary in a dataset

    • Sort the dataset in descending order based on salary

    • Remove duplicates if necessary

    • Return the salary at index n-1

  • Answered by AI

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 26 Apr 2024

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Approached by Company and was interviewed before Apr 2023. There was 1 interview round.

Round 1 - Technical 

(3 Questions)

  • Q1. Implement lag() and lead() without using lag() or lead()
  • Ans. 

    Implement lag() and lead() functions without using lag() or lead()

    • To implement lag(), shift the values in the array by one position to the right

    • To implement lead(), shift the values in the array by one position to the left

    • For example, to implement lag() on [1, 2, 3, 4], you can shift the values to get [null, 1, 2, 3]

    • For lead(), you can shift the values to get [2, 3, 4, null]

  • Answered by AI
  • Q2. How will you go about optimising a query?
  • Ans. 

    Optimising a query involves identifying bottlenecks and improving efficiency.

    • Identify slow-performing queries using tools like query execution plans.

    • Optimize database indexes to speed up query performance.

    • Limit the number of columns and rows returned in the query.

    • Avoid using SELECT * and instead specify only the necessary columns.

    • Use appropriate data types and avoid unnecessary data conversions.

    • Consider denormalizing d...

  • Answered by AI
  • Q3. If the 3rd position in a string contains 'b' replace it with 'v'
  • Ans. 

    Replace 'b' with 'v' in the 3rd position of each string in an array

    • Iterate through each string in the array

    • Check if the 3rd position contains 'b'

    • If yes, replace 'b' with 'v'

  • Answered by AI

Skills evaluated in this interview

Data Analyst Interview Questions Asked at Other Companies

asked in Deloitte
Q1. Suppose there is a room in the office and X people enter room thr ... read more
asked in Wipro
Q2. Chocolate Distribution Problem You are given an array/list CHOCOL ... read more
asked in Wipro
Q3. Ninja and Substrings Problem Statement Ninja has to determine all ... read more
asked in Capgemini
Q4. Ninja and His Secret Information Encoding Problem Ninja, a new me ... read more
Q5. Sliding Window Maximum Problem Statement You are given an array/l ... read more

Data Analyst Interview Questions & Answers

user image Aishwarya Mallik

posted on 2 Jul 2017

Interview Questionnaire 

5 Questions

  • Q1. Tell me about yourself
  • Ans. 

    I am a data analyst with experience in analyzing and interpreting complex data sets to drive business insights.

    • Experienced in using statistical analysis tools such as Python, R, and SQL

    • Proficient in data visualization tools like Tableau and Power BI

    • Skilled in data cleaning, data mining, and data modeling techniques

    • Strong problem-solving and critical thinking skills

    • Effective communicator and team player

    • Example: I have w...

  • Answered by AI
  • Q2. Biggest hurdle you faced during the work you did t organise the tech fest of your college
  • Ans. 

    The biggest hurdle I faced during organizing the tech fest of my college was securing sponsorships.

    • Difficulty in convincing companies to sponsor the event

    • Limited budget for organizing a large-scale tech fest

    • Competition with other college events for sponsorships

    • Negotiating sponsorship deals and ensuring deliverables

    • Finding sponsors aligned with the theme and objectives of the tech fest

  • Answered by AI
  • Q3. Would you go for an MBA?
  • Ans. 

    Yes, pursuing an MBA can enhance my skills and open up new career opportunities.

    • An MBA can provide a strong foundation in business and management principles.

    • It can help develop analytical and problem-solving skills.

    • An MBA can broaden my network and provide access to valuable connections.

    • It can open up leadership roles and higher-level positions in organizations.

    • Having an MBA can increase earning potential and job prosp...

  • Answered by AI
  • Q4. Reliance fresh wants to open a store in north-eastern part of India. Should it or should it not?
  • Ans. 

    Yes, Reliance Fresh should open a store in the north-eastern part of India.

    • The north-eastern part of India has a growing population and increasing consumer demand.

    • Reliance Fresh can tap into the untapped market potential in the region.

    • Opening a store in the north-eastern part of India can help Reliance Fresh expand its presence and increase its market share.

    • Reliance Fresh can leverage its existing supply chain and dist...

  • Answered by AI
  • Q5. Guesstimate the number of people travelling by local metro in mumbai
  • Ans. 

    The number of people travelling by local metro in Mumbai is estimated to be in millions.

    • Mumbai has a population of over 20 million people.

    • The local metro is a popular mode of transportation in Mumbai.

    • During peak hours, the metro trains are usually crowded.

    • The metro network in Mumbai is extensive, covering various parts of the city.

    • The number of daily commuters on the metro can be estimated based on population density a

  • Answered by AI

Interview Preparation Tips

Round: Resume Shortlist
Experience: cpi above 7.0

Round: Test
Experience: Basic maths, shares related questions and english
Duration: 1 hour
Total Questions: 40

Round: Technical + HR Interview
Experience: Very easy round.

Skills: Aptitude, Communication, Quantitative Aptitude, Leadership Skills, Technical Skill
College Name: IIT Kanpur

Interview questions from similar companies

Interview Questionnaire 

1 Question

  • Q1. Explain about self introduction

I applied via Walk-in and was interviewed in Apr 2021. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. About your self

Interview Preparation Tips

Interview preparation tips for other job seekers - please select my profile

Data Analyst Interview Questions & Answers

PayPal user image AKASH KUMAR SINGH

posted on 2 Dec 2016

I applied via Campus Placement and was interviewed in Dec 2016. There were 6 interview rounds.

Interview Questionnaire 

4 Questions

  • Q1. For this round he gave me lot of problems and asked to develop optimal algorithm to solve that. Problems were mainly on trees and number sequences
  • Q2. In this round he mainly discussed my projects and asked me how these can be put to use in Paypal. He also asked some basic questions from ML
  • Q3. HR round was just for formality
  • Q4. Probability , question on calculating expected number of trials and puzzles

Interview Preparation Tips

Round: Test
Experience: The coding question was:
Given a binary string containing 0's and 1's. You can split the string such that each partition should be a exponential of 5 (1,5,25,625...). You were asked to return minimum number of partition for the given string such each partition is exponential of 5. If no such partition exists return -1.
Examples: '101101101' Ans: 3 (101, 101, 101)
'111' Ans: 3 (1,1,1)
10101 Ans: -1
Tips: For MCQ's prepare DSA, OS and Networking. For DSA you can refer to cormen
For Coding question practice on either geeksforgeeks or from any of the coding platforms like hackerrank
The shortlist was mainly dependent on coding question
Duration: 1 hour 30 minutes

Round: Puzzle Interview
Tips: Do lot of puzzles from heard on the street, -----/ , Try to search for more. It will be helpful in other interviews as well

Round: Technical Interview
Tips: Practice algorithm section from geeksforgeeks. There are lot of standard problems. The given questions were slightly modified version of standard problems

Round: Technical Interview
Tips: For this round you need to be well prepared with your projects and resume.

College Name: IIT Madras

I applied via Campus Placement

Interview Preparation Tips

Round: Resume Shortlist
Experience: My resume had a couple of projects and a paper publication added to it, which was a part of my second year intern at TCS Innovation Labs.

Tips: I believe that the resume shortlist to appear for the test is just a formality and not a big deal to get through. Most of the students are allowed to appear for the test which is where, the main shortlisting occurs.
Although, the company does cut off people from certain departments. For example, none of the Agriculture and food engineering students were shortlisted for appearing for the test.
Also, from what I have heard, the company runs resumes through a program to take out the shortlist. Hence, certain key words such as "Scholar" or "Conference" may get you a good chance to get through the shortlisting.

Round: Test
Experience: The test is mainly quant based and how fast you can think and rationalize. They expect excellent speed; they ask you 20 questions to be answered in 30 minutes.
Tips: Normally, if a student is asked to appear for this right after his JEE examination, he would be able to get through it easily. But since our analytical thinking goes way down once we actually get in, it has to be worked upon again. I'd suggest you to solve all the quant questions of any CAT preparatory book for the American Express test. The test questions are quite similar to those that the CAT students prepare for.

Round: Technical Interview
Experience: In general, the American Express interviews are considered to be pretty peaceful compared to the interviews of other companies. I was just asked about my work at TCS Innovation Labs and the paper I would be publishing based on that work and the courses I have done in Data Analytics and what all do I know in it. They do not test the knowledge you say you possess.
Tips: While I was preparing for my interview, I was told to read about Amex and its products. Secondly, and most importantly, I was aksed to read a lot about credit card frauds and suggest ways of preventing that. Even during my time, a lot of people were asked about this and judged severely on that. This is a must must if you would be appearing for its interview.

Also, you would do well if you are able to connect with the interviewer. For instance, if both of you have been a part of the same inter IIT or have the same tastes, etc.

Also, the interviews are that peaceful that you are able to direct the interview in your favour. There are certain parts of your CV that you can easily talk about and certain parts that you would want to avoid. If you are able to think on your feet, it is easy to re direct the interview in your favour and the things that you would like to talk about; in my case, it was my work at TCS.

Round: Puzzle Interview
Experience: The main decision whether you have to be taken in or not is decided in your first round of interview after which, the puzzle interview is just a formality and to find out whether you are able to think on your feet or not. Not a big deal, pretty easy.
Tips: Nothing to be worried about, the puzzles asked are pretty easy and most probably, you would have already heard them if you have a nag of solving puzzles.

General Tips: Do not worry or stress yourself much. The interview is pretty easy if you have an edge in the skills that the company wants. I had started studying Data Analytics in my second year summer vacations, just 1 hour a day for hardly about a month. Which gave me enough of an edge. The main hurdle lies in getting through the test round where about 300 people are simply cut off.
Skill Tips: You should be able to code efficiently. Knowledge in Python and SQL is a big plus.
Also, I had done a course on Coursera called "Machine Learning" of Stanford University. Today, the company does not expect a lot of knowledge in Data Analytics from students which is why this course gave me the edge I needed to get through the interview. It's a pretty easy course and not very demanding. I would recommend this if you want to find out even whether you'd be interested in Data Analytics or not.
I was asked about the things I know and whether I have ever implemented them.
Skills: Analytics And Coding
Duration: 2
College Name: IIT Kharagpur
Motivation: American Express is known to have a good working culture and is currently the third best company to work for in India. The internship stipend is largest compared to any other company in India along with accommodation and travel. The company has a well structured internship program and also has good challenging work to offer.
Funny Moments: After the test, I was not shortlisted for the interview round.. Which broke my heart.
Just after the presentation, I walked up to the person presenting and handed him a hard copy of my resume asking him to at least give me a shot at the interview if they think my profile is good enough.
I believe that this was a turning point of this entire experience. I believe, at that moment itself, I gained their favour to take me in. Which is probably why my interview was peaceful, which is probably why I could get through even though my interview was the last among a bunch of 25 students..
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
More than 8 weeks
Result
Selected Selected

I applied via Referral and was interviewed before Apr 2022. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all Resume tips
Round 2 - One-on-one 

(1 Question)

  • Q1. SQL Window functions projects
Round 3 - Technical 

(1 Question)

  • Q1. ML questions case study

Interview Preparation Tips

Interview preparation tips for other job seekers - prepare projects on resume and ML algorithms along with SQL questions

I applied via Company Website

Interview Questionnaire 

1 Question

  • Q1. Tell me about a project you worked on in which you handled large set of data and multiple tables.

Interview Preparation Tips

Interview preparation tips for other job seekers - Share your geniune answers, articulate them well and be yourself.

Data Analyst Interview Questions & Answers

Visa user image Vishwesh Dayama

posted on 18 Dec 2024

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(2 Questions)

  • Q1. SQL Joins and remove duplicates
  • Q2. Function to create a transaction bin column
  • Ans. 

    Create a function to generate a transaction bin column based on transaction amounts.

    • Create bins based on transaction amounts (e.g. $0-$100, $101-$200, etc.)

    • Use pandas cut() function in Python to create bins

    • Assign bin labels to the transactions based on the bin ranges

  • Answered by AI
Contribute & help others!
anonymous
You can choose to be anonymous

MasterCard Interview FAQs

How many rounds are there in MasterCard Data Analyst interview?
MasterCard interview process usually has 1 rounds. The most common rounds in the MasterCard interview process are Technical.
What are the top questions asked in MasterCard Data Analyst interview?

Some of the top questions asked at the MasterCard Data Analyst interview -

  1. Guesstimate the number of people travelling by local metro in mum...read more
  2. Reliance fresh wants to open a store in north-eastern part of India. Should it ...read more
  3. If the 3rd position in a string contains 'b' replace it with ...read more

Recently Viewed

INTERVIEWS

SmartKnower

No Interviews

INTERVIEWS

Cisco

No Interviews

INTERVIEWS

Techahead Software

No Interviews

INTERVIEWS

Solitaire Infosys

No Interviews

INTERVIEWS

SHCIL SERVICES

No Interviews

INTERVIEWS

ITC

No Interviews

INTERVIEWS

Chevron

No Interviews

INTERVIEWS

Navarro

No Interviews

INTERVIEWS

ITC Hotels

No Interviews

INTERVIEWS

SmartKnower

No Interviews

Tell us how to improve this page.

MasterCard Data Analyst Interview Process

based on 3 interviews

Interview experience

4.3
  
Good
View more
MasterCard Data Analyst Salary
based on 38 salaries
₹6 L/yr - ₹22.8 L/yr
110% more than the average Data Analyst Salary in India
View more details

MasterCard Data Analyst Reviews and Ratings

based on 5 reviews

4.0/5

Rating in categories

3.8

Skill development

4.3

Work-life balance

3.4

Salary

4.0

Job security

4.3

Company culture

3.7

Promotions

4.0

Work satisfaction

Explore 5 Reviews and Ratings
Senior Software Engineer
694 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Engineer2
258 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Engineer
236 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Consultant
183 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Lead Software Engineer
146 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare MasterCard with

PayPal

3.9
Compare

Visa

3.5
Compare

American Express

4.2
Compare

Discover Financial Services

4.0
Compare
Did you find this page helpful?
Yes No
write
Share an Interview
Rate your experience using AmbitionBox
Terrible
Terrible
Poor
Poor
Average
Average
Good
Good
Excellent
Excellent