AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
MasterCard Business Analyst Interview Questions, Process, and Tips
Top MasterCard Business Analyst Interview Questions and Answers
- Q1. If you are going to open an e-commerce website like Flipkart what will be the things that you will have to keep in mind.
- Q2. Revenue collected by the barbers of Kanpur in an year
- Q3. Do you think data analysis job is overrated?
MasterCard Business Analyst Interview Experiences
2 interviews found
Shikha Raj
(2 Questions)
- Q1. How would you copy a large dataset
- Ans.
Use a data migration tool to copy the dataset efficiently.
Utilize a data migration tool like AWS Data Pipeline, Apache Nifi, or Talend to copy the dataset.
Break down the dataset into smaller chunks to avoid overwhelming the system.
Ensure proper data validation and error handling during the copying process.
Consider using parallel processing to speed up the copying process.
Monitor the progress of the dataset copying to t
- Q2. Do you think data analysis job is overrated?
- Ans.
No, data analysis job is not overrated as it plays a crucial role in decision-making and problem-solving.
Data analysis helps in identifying trends and patterns in data
It provides valuable insights for businesses to make informed decisions
Data analysis is essential for optimizing processes and improving efficiency
It can uncover hidden opportunities and potential risks
Many industries rely on data analysis for strategic p
Skills evaluated in this interview
Anonymous
I appeared for an interview in Dec 2016.
Interview Questionnaire
5 Questions
- Q1. Any thing which your friends hate about you?
- Ans.
I tend to be too organized and structured, which can annoy my friends at times.
My friends sometimes find my need for planning and structure to be excessive
I can be inflexible when it comes to deviating from my plans
My attention to detail can come across as nitpicky to some
I prioritize efficiency over spontaneity, which can be frustrating for my more laid-back friends
- Q2. Revenue collected by the barbers of Kanpur in an year
- Ans.
I don't have the available data to answer this question.
Need data on number of barbers in Kanpur
Need data on average revenue per barber
Need data on number of working days in a year
Need data on number of customers per barber per day
- Q3. If you are going to open an e-commerce website like Flipkart what will be the things that you will have to keep in mind.
- Ans.
To open an e-commerce website like Flipkart, one must keep in mind various factors such as target audience, product range, user experience, logistics, and marketing.
Identify the target audience and their preferences
Offer a wide range of products to cater to different needs
Ensure a seamless user experience with easy navigation and quick loading time
Establish a robust logistics network for timely delivery and hassle-free...
- Q4. If given the other job profile will you accept it?
- Ans.
It depends on the job profile and its alignment with my career goals.
I would consider the job profile and evaluate its alignment with my career goals.
I would assess the job responsibilities and the skills required for the role.
I would also consider the company culture and work environment.
If the job profile aligns with my career goals and offers growth opportunities, I would accept it.
However, if it does not align with...
- Q5. Any one decision you will like to change in course of these 4 years which could open a better career profile for you.
- Ans.
I would have pursued a certification in data science earlier.
I should have taken a course in data science during my undergraduate studies.
I could have pursued a certification in data science while working as a business analyst.
Learning data science earlier would have opened up more opportunities for me in the field.
I could have gained more experience in data analysis and visualization.
I could have applied for more adva
Interview Preparation Tips
Experience: The question were tricky not conventional quant. Spend time on questions don't rush
Tips: CAT level preparation will be more than enough
Duration: 1 hour
Total Questions: 60
Round: HR Interview
Experience: Basic HR questions. Be confident and good communication skills will help
Round: Technical + HR Interview
Experience: There were 2 panelist one man and a woman. When they asked the revenue question, I asked the ma'am as to how many times do she go to a parlor and then how much does it cost each time. This lightened the mood and she was smiling throughout the interview. After listening to questions I was saying "Please give me 2 minutes to think over it" She finally said "Why do you want 2 minutes every time we ask a question" then i answered "I just want to come up with the best answer in 2 minutes and don't say anything irrelevant". They were very impressed said "Take as much time as you want "
Tips: Just be yourself. Confident with a smile. Workout the problem with them
Skills: Guesstimate Skills, HR Skills, Communication And Confidence, Ability To Handle Situations, Commitment
College Name: IIT Kanpur
Interview questions from similar companies
AKASH KUMAR SINGH
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
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 Referral
(2 Questions)
- Q1. Are you available to join immediately?
- Q2. What's your location preference?
Situation based questions
(2 Questions)
- Q1. Tell me about yourself
- Ans.
I am a dedicated and experienced consultant with a strong background in problem-solving and client management.
Over 5 years of experience in consulting roles
Skilled in analyzing data and providing strategic recommendations
Proven track record of successfully managing client relationships
Strong communication and presentation skills
Certified in relevant consulting methodologies
- Q2. Describe the assignment
- Ans.
The assignment involved analyzing market trends and creating a strategic plan for a new product launch.
Researched current market trends and competitor analysis
Developed a comprehensive strategic plan for product launch
Presented findings and recommendations to stakeholders
(1 Question)
- Q1. Salary negotiation
Selected
I applied via Approached by Company and was interviewed in Jan 2024. There were 2 interview rounds.
It was easy. Basic questions
(2 Questions)
- Q1. Sql related query
- Q2. Situation based
I applied via Campus Placement and was interviewed in Jul 2024. There were 2 interview rounds.
Basic question of probability and profit and loss were asked
(2 Questions)
- Q1. Basic questions related to awareness
- Q2. Like how much water is present in Atlantic ocean
- Ans.
Approximately 321,000,000 cubic miles of water is present in the Atlantic Ocean.
The Atlantic Ocean is the second-largest ocean in the world.
It covers an area of about 41,100,000 square miles.
The average depth of the Atlantic Ocean is around 12,880 feet.
The volume of water in the Atlantic Ocean is estimated to be around 321,000,000 cubic miles.
Interview Preparation Tips
sahithi reddy
Selected
I applied via LinkedIn and was interviewed before Mar 2023. There were 2 interview rounds.
(1 Question)
- Q1. What is the order of execution in sql
- Ans.
The order of execution in SQL is: FROM, WHERE, GROUP BY, HAVING, SELECT, ORDER BY.
1. FROM: Specifies the tables involved in the query.
2. WHERE: Filters the rows based on specified conditions.
3. GROUP BY: Groups the rows that have the same values into summary rows.
4. HAVING: Filters groups based on specified conditions.
5. SELECT: Selects the columns to be included in the result set.
6. ORDER BY: Sorts the result set base
(1 Question)
- Q1. How to do conditional formatting in excel
- Ans.
Conditional formatting in Excel allows users to format cells based on specified conditions.
Select the range of cells you want to apply conditional formatting to
Go to the 'Home' tab and click on 'Conditional Formatting'
Choose the desired formatting option, such as color scales, data bars, or icon sets
Set the conditions for when the formatting should be applied, such as greater than, less than, or equal to a certain valu...
Interview Preparation Tips
Skills evaluated in this interview
I applied via Campus Placement and was interviewed in Jan 2024. There were 2 interview rounds.
I applied through our University (placement) ,it was just a formal MCQ based aptitude questions.
(4 Questions)
- Q1. Introduce yourself
- Q2. Hobbies other than study
- Q3. Why shall we hire you
- Q4. About my project
Interview Preparation Tips
Selected
I applied via Referral and was interviewed before Apr 2022. There were 3 interview rounds.
(1 Question)
- Q1. SQL Window functions projects
(1 Question)
- Q1. ML questions case study
Interview Preparation Tips
MasterCard Interview FAQs
Tell us how to improve this page.
MasterCard Interviews By Designations
- MasterCard Senior Software Engineer Interview Questions
- MasterCard Software Engineer Interview Questions
- MasterCard Consultant Interview Questions
- MasterCard Devops Engineer Interview Questions
- MasterCard Software Developer Interview Questions
- MasterCard Java Developer Interview Questions
- MasterCard Data Engineer Interview Questions
- MasterCard Data Analyst Interview Questions
- Show more
Interview Questions for Popular Designations
- Business Development Executive Interview Questions
- Business Development Manager Interview Questions
- Business Development Associate Interview Questions
- Senior Business Analyst Interview Questions
- Business Associate Interview Questions
- Business Development Interview Questions
- Business Executive Interview Questions
- Business Manager Interview Questions
- Show more
MasterCard Business Analyst Interview Process
based on 1 interview
Interview experience
Business Analyst Interview Questions from Similar Companies
Fast track your campus placements
MasterCard Business Analyst Reviews and Ratings
based on 3 reviews
Rating in categories
|
Senior Software Engineer
831
salaries
|  ₹13.9 L/yr - ₹46 L/yr |
|
Software Engineer2
279
salaries
| ₹9.6 L/yr - ₹30 L/yr |
|
Software Engineer
229
salaries
| ₹6.2 L/yr - ₹22.6 L/yr |
|
Consultant
182
salaries
| ₹11.8 L/yr - ₹36 L/yr |
|
Lead Software Engineer
150
salaries
| ₹18.8 L/yr - ₹57.5 L/yr |
PayPal
Paytm
Fiserv
PhonePe
- Home >
- Interviews >
- MasterCard Interview Questions >
- MasterCard Business Analyst Interview Questions
