Upload Button Icon Add office photos

MasterCard

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

MasterCard Data Engineer Interview Questions and Answers

Updated 1 Oct 2024

MasterCard Data Engineer Interview Experiences

4 interviews found

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. How do you delete duplicate values
  • Ans. 

    To delete duplicate values, use SQL queries with DISTINCT keyword or programming languages like Python with sets.

    • In SQL, use SELECT DISTINCT to retrieve unique values

    • In Python, convert list to set to automatically remove duplicates

    • Use pandas library in Python to drop duplicates in a DataFrame

  • Answered by AI

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Campus Placement and was interviewed in Sep 2024. There was 1 interview round.

Round 1 - Aptitude Test 

Interview: resume,puzzles, guesstimates

Interview Preparation Tips

Interview preparation tips for other job seekers - 100 gfg puzzles
case interview cracked videos

Data Engineer Interview Questions Asked at Other Companies

asked in Cisco
Q1. Optimal Strategy for a Coin Game You are playing a coin game with ... read more
asked in Sigmoid
Q2. Next Greater Element Problem Statement You are given an array arr ... read more
asked in Sigmoid
Q3. Problem: Search In Rotated Sorted Array Given a sorted array that ... read more
asked in Cisco
Q4. Covid Vaccination Distribution Problem As the Government ramps up ... read more
asked in LTIMindtree
Q5. 1) If you are given a card with 1-1000 numbers and there are 4 bo ... read more
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via LinkedIn and was interviewed in Aug 2024. There were 2 interview rounds.

Round 1 - Aptitude Test 

Aptitude questions asked about basic stuff

Round 2 - Technical 

(1 Question)

  • Q1. Projects related concepts
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
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 - Technical 

(2 Questions)

  • Q1. Spark architecture
  • Q2. Sql questions on joins and hive related questions
Round 3 - Group Discussion 

Project explanation

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare sql

MasterCard interview questions for designations

 Data Engineer 1

 (1)

 Big Data Analyst

 (1)

 Data Consultant

 (1)

 Data Analyst

 (3)

 Data Scientist

 (1)

 Senior Data Scientist

 (2)

 Data Science Intern

 (1)

 Software Engineer

 (10)

Interview questions from similar companies

I was interviewed in Jun 2017.

Interview Questionnaire 

11 Questions

  • Q1. How does ajax call work
  • Ans. 

    Ajax calls allow for asynchronous communication between client and server without reloading the page.

    • Ajax stands for Asynchronous JavaScript and XML

    • Uses XMLHttpRequest object to send and receive data

    • Allows for partial page updates without reloading the entire page

    • Can handle data in various formats such as JSON, XML, HTML, and plain text

    • Example: $.ajax({url: 'example.com', success: function(data){console.log(data)}});

  • Answered by AI
  • Q2. Difference between REST and SOAP
  • Ans. 

    REST is lightweight and uses HTTP while SOAP is XML-based and has more features.

    • REST uses HTTP methods like GET, POST, PUT, DELETE while SOAP uses XML messaging.

    • REST is stateless while SOAP can maintain state.

    • REST is faster and easier to use while SOAP is more secure and reliable.

    • REST is used for web services while SOAP is used for enterprise-level services.

    • Example of REST: Twitter API. Example of SOAP: Amazon Web Serv

  • Answered by AI
  • Q3. What is GET and POST
  • Ans. 

    GET and POST are HTTP methods used for sending data to a server.

    • GET is used to retrieve data from a server

    • POST is used to submit data to a server

    • GET requests can be cached and bookmarked

    • POST requests are not cached and cannot be bookmarked

    • GET requests have length restrictions

    • POST requests have no length restrictions

    • GET requests are less secure than POST requests

  • Answered by AI
  • Q4. What is observer pattern
  • Ans. 

    Observer pattern is a design pattern in which an object maintains a list of its dependents and notifies them automatically of any state changes.

    • Also known as publish-subscribe pattern

    • Used in event-driven systems

    • Allows loose coupling between objects

    • Example: A weather station broadcasts weather updates to multiple displays

    • Example: A stock market ticker notifies multiple investors of stock price changes

  • Answered by AI
  • Q5. What is singleton
  • Ans. 

    Singleton is a design pattern that restricts the instantiation of a class to a single object.

    • Singleton ensures that only one instance of a class exists in the entire application.

    • It provides a global point of access to the instance.

    • Commonly used in scenarios where a single instance needs to coordinate actions across the system.

    • Example: Database connection manager, logger, configuration manager.

  • Answered by AI
  • Q6. What is immutable in java
  • Ans. 

    Immutable in Java refers to objects whose state cannot be changed after creation.

    • String, Integer, and other wrapper classes are immutable in Java.

    • Immutable objects are thread-safe and can be shared without synchronization.

    • To create an immutable class, make all fields final and private, and don't provide setters.

    • Examples of immutable classes in Java include LocalDate, LocalTime, and LocalDateTime.

  • Answered by AI
  • Q7. How do you create immutable in java
  • Ans. 

    Creating immutable in Java

    • Use final keyword to make variables immutable

    • Use private constructor to prevent object modification

    • Use defensive copying to prevent modification of mutable objects

    • Use enum to create immutable objects

    • Use String class to create immutable strings

  • Answered by AI
  • Q8. Where have you used immutable in java
  • Q9. What is dependency injection
  • Ans. 

    Dependency injection is a design pattern that allows objects to receive dependencies rather than creating them internally.

    • It helps to decouple the code and makes it more testable and maintainable.

    • It allows for easier swapping of dependencies without changing the code.

    • There are three types of dependency injection: constructor injection, setter injection, and interface injection.

    • Example: Instead of creating a database co...

  • Answered by AI
  • Q10. What is CORS
  • Ans. 

    CORS stands for Cross-Origin Resource Sharing. It is a security feature implemented in web browsers to restrict access to resources from different origins.

    • CORS allows web servers to specify which origins are allowed to access its resources

    • It is implemented using HTTP headers

    • CORS prevents malicious websites from accessing sensitive data from other websites

    • Examples of resources that may be restricted by CORS include cook

  • Answered by AI
  • Q11. How do you overcome CORS
  • Ans. 

    CORS can be overcome by configuring the server to allow cross-origin requests.

    • Configure the server to include the Access-Control-Allow-Origin header

    • Use JSONP (JSON with Padding) to bypass CORS restrictions

    • Use a proxy server to make the request on behalf of the client

    • Use a browser extension to disable CORS restrictions during development

    • Use a server-side proxy to forward requests to the target server

  • Answered by AI

Interview Preparation Tips

Skills: Java Programming

Skills evaluated in this interview

Interview Questionnaire 

1 Question

  • Q1. Explain about self introduction

Software Engineer Interview Questions & Answers

Visa user image Pranali Yawalkar

posted on 14 Dec 2015

Interview Questionnaire 

7 Questions

  • Q1. Discussion on my internships and course projects.
  • Q2. My field of interest, how well have I fared in it.
  • Q3. Design a mvc controller system where given a url, I am able to invoke the right controller. Eg, given "xyz.com/a/b/c", I should be able to invoke c controller by going through a and b
  • Q4. Design autocomplete in IDEs
  • Ans. 

    Autocomplete in IDEs helps developers write code faster by suggesting code snippets and completing code as they type.

    • Autocomplete should suggest code snippets based on the context of the code being written

    • Autocomplete should prioritize suggestions based on frequency of use

    • Autocomplete should also suggest variable and function names

    • Autocomplete should be customizable to allow for user-defined snippets and suggestions

    • Exa...

  • Answered by AI
  • Q5. What is my weakness
  • Ans. 

    My weakness is public speaking.

    • I tend to get nervous when speaking in front of large groups.

    • I am working on improving my public speaking skills by practicing and seeking feedback.

    • I have taken courses and attended workshops to help me overcome my fear of public speaking.

  • Answered by AI
  • Q6. Given 2 game scenarios for basketball, and given p as the probability of making a basket in an attempt, I have to understand the condition where game1 would be preferable over game2. In first game, I have ...
  • Ans. 

    Comparing 2 basketball game scenarios with different number of trials and baskets required to win

    • Calculate the probability of winning in each game scenario using binomial distribution formula

    • Compare the probabilities to determine which game scenario is preferable

    • In game1, the probability of winning is p. In game2, the probability of winning is the sum of probabilities of making 2 or 3 baskets

    • If p is high, game1 is pref...

  • Answered by AI
  • Q7. Given a dictionary of words, I have to go from one word to another in least number of transitions where a transition is a defined as changing any letter of the current word such that the new word is also i...

Interview Preparation Tips

Round: Test
Experience: The test was on hackerrank.
Tips: * Fast coding and problem solving required
* Time crunch
* The test is valued a LOT in the hiring process
Duration: 120 minutes
Total Questions: 4

Round: Technical Interview
Experience: Question 1 : He tried to take the discussion to web based technologies to which I straightly told I don’t know. Not sure if that was a good decision. Nevertheless, he went over my resume a lot of times and asked about various projects.
Question 2 : Discussed the various projects related to it.
Question 3 : He asked this question because I had worked on django during my FB internship. I proposed a tree based structure. xyz.com/a/b/c ---> b is child of a, c is child of b.

Question 4 : Next he moved to a very interesting question. Given a simple text editor, I want to facilitate autocomplete feature. We discussed about syntactic methods using language specific keywords. I suggested a trie based implementation which he liked. Later he asked me to improve and redirected me to using scope of the variables, and grammar of the language. We discussed about all the steps I did in language translators lab (macrojava -> minijava -> typechecking -> miniIR -> microIR -> miniRA ->Mips) where we built a Java compiler in Java. We later hopped back to original question and I suggested that we can use grammar to to store multiple (nested kind of) tries for different scope. He asked me how would I define “scope”. He gave me a scenario which helped me come up with the nested trie structure
int a;
{
int b;
{
int c; //a b c can be used
}
{
int d; //a b d can be used
}
}
He then asked me details of how I would code. I said we could use the respective visitors and maintain the current trie root for scope. He liked it but I missed at 2 places :
1. He asked me about token generation used in a compiler and I said flex and bison. I was expected to elaborate a bit.
2. He asked me how the grammar is generated and how the visitors are invoked. I couldn’t explain properly because I was not thorough with it.
Tips: * Keep smiling in the interviews.
* My interviewer had hopped from Microsoft to Visa. We had a short detailed discussion on how the transition was and what drove him to do that.
* It’s always good to know about the company to pick up interesting discussions, read up latest articles and news
* The interviewers want to see if you are passionate about what they are building. Their PPT (Pre Placement Talk) was also focussed majorly on the technologies they are building.
* If you take a question in a direction, make sure you are very very thorough with it. I took it in the direction of compilers, but couldn't make the transition seamlessly because I wasn't thorough with a lot of things (like token generation, visitor invocation).
* Not sure if telling upfront that you don't know about web technologies when you are applying for a profile that might need it is a good idea or not.


Round: Technical Interview
Experience: I think he was a senior person and spoke very passionately about the work that is happening in visa Bangalore office.

Question 1 : I said maybe I should have learnt a little about web based technologies. I think he was looking for a more generic answer.
Question 2 : I went ahead with calculating the expected score where my score random variable = 1 with probability p, and 0 with probability (1-p). I conditioned that expected score of game1 > game2 which would give me the range of p. I goofed up the equations twice but he said he liked my approach and I was just there

Question 3 : I suggested building a graph where a node is a word and an edge means a transition, and then performing BFS. He said that was obvious and that he was more interested in knowing how I build the graph. I suggested a method to reduce the number of string comparisons by storing a count vector with each word. Count vector is a 26 length vector where count[i] = number of times that letter occurs in the word. I would do string comparison to identify neighbours only if the difference in count vectors in 2. Eg, cot = cat - a + o. String comparison is still needed because of false positives. Eg, oct = cat - a + o but cat -> oct is not a valid transition. He liked my approach and asked me to code, discussed the complexity.
Tips: * Don't be naive around a senior engineer. Be confident.
* Explain your approach before going ahead solving it. I missed that in Q1 and for a long time he didn't know what I was heading towards.
* Write clean code, practice coding on paper to make sure you write compilable code. Shabby code is a turn off.
* Show passion for the company you are applying for.

General Tips: * Be friendly and keep smiling.
* Know about the company, well in detail. Recent news, articles, acquisitions, organisational changes, new offices, new product, etc.
* Know about the volume the company handles, certain mind boggling figures, what the company *does not* do
* If you are introducing yourself as an expert in a certain field, be prepared for questions like "How will you contribute to our company with your expertise" type of questions.
* Be very very thorough with every single thing you write on your resume. A small point you weren't sure about might become the basis of your whole interview. Don't write things you are unsure of, or have worked very little on.
Skill Tips: * I think I didn’t take Visa very seriously. I was assuming they won’t take a undergrad and they won’t take me because I have 0 knowledge in web based technologies. I might have acted a little cocky.
* They had nice pie diagrams which shows that they had done thorough research about each and every candidate based on resume and the coding test.
* They value the coding test a lot.
* Be very thorough with the projects you write on resume. They will give you a problem which won't be straightforward and will map onto one of your course projects. You are expected to do the mapping seamlessly. Every bit of the discussion you have with the interviewer can be your next problem.
* Brush up on web based technologies if you can.
* There will be a HR round as well if you clear the technical interviews.

Skills: Maths(esp Probability), Design, Passion, Web Technologies, Technical Skill And Speaking Skill, Coding Skills
College Name: IIT Madras
Motivation: * Been the leader since more than half a century, been through the technological revolution.
* Revolutionising payments architecture. Building something of greatest need, so elegant and optimised, yet producing such consistent performance.
* Keeping up with the need of the generation by introducing features which are brand new. Eg, “all-purpose credit card”.
* Loved their PPT (Pre Placement Talk). Volume of the data and processing is IMMENSE. Billions of transactions in a year voluming up to trillions. More than 200 countries in the world --> these stats are HUGE.
* Fraud detection is a space I would have loved to work on given that I come from a Data Mining background.

Funny Moments: Chucked out before HR round :P

Skills evaluated in this interview

Interview Questionnaire 

2 Questions

  • Q1. Why would you like to join Visa and why?
  • Q2. Tell me about yourself

Interview Preparation Tips

Round: Test
Experience: Coding Questions were fairly standard ones.
Duration: 75 minutes
Total Questions: 42

Round: Interview
Experience: Networks based questions, firewalls, TCP/IP and other OSI layers

Round: Interview
Experience: Coding questions. Asked to code on paper. Questions on Object Oriented Design.

Skills: Networks basics, OOPs basics, Coding Skills
College Name: IIT Guwahati
Motivation: Profiles offered, Package, Location

Interview Preparation Tips

Round: Test
Experience: Questions on
1. Programming: 10 Questions2. Machine Learning Hadoop MCQ: 6 Questions3. Networking MCQ: 6 Questions4. Operating System: 6 Questions5. Infrastructure: 6 Questions6. Application Security: 6 Questions
Tips: Questions were simple , except sections 2,5 unless you have a basic idea about it.
Duration: 75 minutes
Total Questions: 34+2

Round: Technical Interview
Experience: – Projects, Internship– Asymmetric and Symmetric encryption with some real world usage– Concepts behind Digital Signature and Digital Certificates– Detailed discussion on HTTPS– Basic OS concepts : Threads, Mutex , Semaphores– Basic OOPS concepts : Virtual functions , Function overloading and overriding , encapsulation.
Tips: Focus on Network Security concepts !

Round: Technical Interview
Experience: – Projects , Internship– Some discussion on Testing and how you would design a unit test case and a complete project test case. Discussion on Automated Testing.– How does a Web application work.– Software Development Models– Discussion on interpreted language and compiled language– Some DBMS basics for efficiency :- Indexing viz. B+trees , Hashing.– Some discussion on Apple Pay , VbV (Verified by Visa) (informal)

Round: HR Interview
Experience: Basic HR questions !

General Tips: Confidence is the key along with sufficient coding practice both on the IDE and pen-paper.
Skills: Network Security, Programming, Algorithms, Operating System
College Name: IIT ROORKEE

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

Interview Questionnaire 

7 Questions

  • Q1. Given an array, Implement Binary search tree
  • Ans. 

    Implement Binary Search Tree using given array of strings.

    • Sort the array in ascending order

    • Find the middle element and make it the root of the tree

    • Recursively create left and right subtrees using the left and right halves of the array

    • Repeat until all elements are added to the tree

  • Answered by AI
  • Q2. Given the above Binary search tree, print in ascending order
  • Ans. 

    Print the given Binary search tree in ascending order

    • Traverse the left subtree recursively

    • Print the root node

    • Traverse the right subtree recursively

  • Answered by AI
  • Q3. Given an array of stock prices, find where to buy and where to sell for maximum profit in O(n)
  • Ans. 

    Find buy and sell points for maximum profit in an array of stock prices in O(n)

    • Iterate through the array and keep track of the minimum price seen so far

    • Calculate the profit at each index by subtracting the minimum price from the current price

    • Update the maximum profit and buy/sell points accordingly

    • Return the buy and sell points for maximum profit

  • Answered by AI
  • Q4. Resume based
  • Q5. What are three problems Chennai faces?
  • Ans. 

    Chennai faces problems related to water scarcity, traffic congestion, and pollution.

    • Water scarcity due to inadequate rainfall and poor management of water resources.

    • Traffic congestion due to the increasing number of vehicles and poor road infrastructure.

    • Pollution caused by industries, vehicular emissions, and improper waste disposal.

  • Answered by AI
  • Q6. Which one would you solve and how and why?
  • Ans. 

    Need more context on the question to provide an answer.

    • Please provide more information on the problem to be solved.

    • Without context, it is difficult to provide a solution.

    • Can you please provide more details on the problem statement?

  • Answered by AI
  • Q7. What is most interesting thing about Visa?
  • Ans. 

    Visa is a global payments technology company that connects consumers, businesses, banks and governments in more than 200 countries and territories.

    • Visa operates the world's largest retail electronic payments network.

    • VisaNet, the company's global processing system, handles more than 65,000 transaction messages a second.

    • Visa is constantly innovating to improve payment security and convenience, with initiatives such as Vi...

  • Answered by AI

Interview Preparation Tips

Round: Test
Experience: 4 Coding questions on Hackerrank platform, one and half hour time. I am not going to reveal the questions here, but one was a basic binary tree implementation and the other three were algorithmic and mathematical problems. They were kinda hard to solve in an hour and half. I could do only 1 and half of the other one. I got 115/300 points on that. I was one of the 16 people selected for the interview.
Tips: It all depends on how well you can focus on the test day. Just practice a lot on hackerrank.
Duration: 1 hour 30 minutes
Total Questions: 4

Round: Technical Interview
Experience: The first two questions I was able to do fast enough. I was also asked a few questions on my resume and coding-related internship. The last one, I showed an O(n*n) algorithm first and then modified it to O(n). Around 45 minutes.
Tips: Be thorough on the coding part in your resume. Think out aloud!

Round: Technical + HR Interview
Experience: Just a few normal questions regarding my projects and my favorite course and it's application to Visa. 15 minutes.
Tips: Once again, be thorough on your resume.

Round: HR Interview
Experience: Once again a normal round, just random questions as to whether I am interested and good enough in communication. 15 minutes.
Tips: Don't get shaken. Be ready for all kinds of questions. Especially about Visa relation to what you do

Skills: Smart Coding
College Name: IIT Madras

Skills evaluated in this interview

Contribute & help others!
anonymous
You can choose to be anonymous

MasterCard Interview FAQs

How many rounds are there in MasterCard Data Engineer interview?
MasterCard interview process usually has 1-2 rounds. The most common rounds in the MasterCard interview process are Technical, Aptitude Test and Resume Shortlist.
How to prepare for MasterCard Data Engineer interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at MasterCard. The most common topics and skills that interviewers at MasterCard expect are Information Security, Python, SQL, Analytics and Automation Testing.
What are the top questions asked in MasterCard Data Engineer interview?

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

  1. How do you delete duplicate val...read more
  2. Sql questions on joins and hive related questi...read more
  3. Projects related conce...read more

Recently Viewed

JOBS

Browse jobs

Discover jobs you love

COMPANY BENEFITS

KNR Constructions

20 benefits

COMPANY BENEFITS

IRB Infrastructure

60 benefits

COMPANY BENEFITS

Dilip Buildcon

304 benefits

COMPANY BENEFITS

Dilip Buildcon

304 benefits

INTERVIEWS

Liquiloans

No Interviews

INTERVIEWS

Crowe Horwath

No Interviews

INTERVIEWS

Crowe Horwath

No Interviews

INTERVIEWS

MasterCard

No Interviews

JOBS

Crowe Horwath

No Jobs

Tell us how to improve this page.

MasterCard Data Engineer Interview Process

based on 5 interviews

Interview experience

3.6
  
Good
View more

Data Engineer Interview Questions from Similar Companies

View all
MasterCard Data Engineer Salary
based on 36 salaries
₹10.7 L/yr - ₹24 L/yr
73% more than the average Data Engineer Salary in India
View more details

MasterCard Data Engineer Reviews and Ratings

based on 5 reviews

4.7/5

Rating in categories

4.4

Skill development

4.6

Work-life balance

3.5

Salary

4.8

Job security

4.6

Company culture

4.3

Promotions

4.3

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