AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
American Express
Compare
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
American Express Data Analyst Interview Questions, Process, and Tips
Top American Express Data Analyst Interview Questions and Answers
- Q1. Sliding Window Maximum Problem Statement You are given an array/list of integers with length 'N'. A sliding window of size 'K' moves from the start to the end of the arr ...read more
- Q2. Can you explain a complex joins problem related to database management systems (DBMS)?
- Q3. Q1. Case study for Number of Green T-shirts sold in US?
American Express Data Analyst Interview Experiences
11 interviews found
Anonymous
I applied via Approached by Company and was interviewed in Jan 2023. There were 3 interview rounds.
Three Data model questions will be given to solve within 24 hours.
(2 Questions)
- Q1. Q1. Case study for Number of Green T-shirts sold in US?
- Ans.
A case study on the number of green T-shirts sold in the US.
Identify the target audience for green T-shirts
Analyze the market demand for green T-shirts
Study the sales data of green T-shirts in the US
Identify the popular brands and styles of green T-shirts
Analyze the impact of seasonality on sales
Consider the pricing strategy of green T-shirts
Identify potential marketing opportunities to increase sales
- Q2. Q2. SQL joins and Python simple questions
Interview Preparation Tips
I applied via campus placement at Indian Institute of Technology (IIT), Jodhpur and was interviewed in Jun 2024. There was 1 interview round.
(3 Questions)
- Q1. What is p value?
- Ans.
A p-value is a measure used in statistical hypothesis testing to determine the strength of evidence against the null hypothesis.
A p-value is the probability of obtaining results as extreme as the observed results, assuming the null hypothesis is true.
A p-value is compared to a significance level (usually 0.05) to determine if the null hypothesis should be rejected.
A p-value less than the significance level indicates st
- Q2. Tell the output a**2
- Ans.
The output of a**2 is the square of the value of a.
The output is the value of a multiplied by itself
For example, if a = 3, then the output would be 9 (3*3)
- Q3. Difference between append() and concat
- Ans.
append() adds elements to a single DataFrame, while concat() combines multiple DataFrames.
append() is a method used to add rows to a DataFrame.
concat() is a function used to combine multiple DataFrames along a particular axis.
append() modifies the original DataFrame, while concat() returns a new DataFrame.
Example: df1.append(df2) vs pd.concat([df1, df2])
Prakhar Rawat
(2 Questions)
- Q1. SQL Query of case when then statement
- Ans.
SQL query using CASE WHEN THEN statement
Use CASE WHEN statement to create conditional logic in SQL queries
Syntax: SELECT column_name, CASE WHEN condition1 THEN result1 WHEN condition2 THEN result2 ELSE result3 END AS new_column_name FROM table_name
Example: SELECT name, CASE WHEN age < 18 THEN 'Minor' ELSE 'Adult' END AS age_group FROM customers
- Q2. SQL Query of join
- Ans.
SQL query to join tables based on a common key
Use JOIN keyword to combine rows from two or more tables based on a related column between them
Specify the columns to be joined in the ON clause
Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN
Skills evaluated in this interview
What people are saying about American Express
I applied via Campus Placement
1hr test , basic apti questions .
American express discussion and economics
Interview Preparation Tips
American Express interview questions for designations
Three sections of apti, ML and Case study
(1 Question)
- Q1. Factors to account for ATM placements in city?
- Ans.
Factors such as foot traffic, proximity to banks, crime rates, and demographics should be considered for ATM placements in a city.
Foot traffic in the area
Proximity to banks or financial institutions
Crime rates in the neighborhood
Demographics of the area (income levels, age groups)
Accessibility and visibility of the location
Local regulations and zoning laws
Availability of power and network connections
Competition from ot...
Get interview-ready with Top American Express Interview Questions
Vishnu Aneja
Selected
(1 Question)
- Q1. How would you decide if a person can be a customer of a private jet company
- Ans.
To determine if a person can be a customer of a private jet company, factors such as income level, travel frequency, and location must be considered.
Consider the individual's income level to determine if they can afford private jet services
Evaluate the person's travel frequency to see if they would benefit from the convenience of private jet travel
Take into account the person's location and travel destinations to asses
Data Analyst Jobs at American Express
debayan paul
Selected
I applied via Referral and was interviewed before Nov 2023. There were 2 interview rounds.
You are building a model to predict if an order will be returned for a furniture ecommerce site.
1. steps to be followed.
2. What all features would you select based on your business sense.
(2 Questions)
- Q1. Why this job interests you?
- Q2. Tell us your past experience
Selected
I applied via Campus Placement and was interviewed before Apr 2023. There were 2 interview rounds.
(2 Questions)
- Q1. Explain why and when Analysis of Variance (ANOVA) is used. {Question from CV, since I had mentioned the use of it before}
- Q2. ,You want to create an index that comprises of a bunch of components. How would you choose to aggregate all the individual components? Is it context specific?
- Ans. Use of PCA is advised. Methods of aggrefation used might be a GM, AM or a HM along with all their weighted counterparts. PCA might be come in handy. Furthermore, PCA is more generalised and has greater applicability.
Question:
Suppose you are trying to detect if a particular credit card transaction is fraudulent or not. The credit score of the individual to which the card belongs to had a very healthy credit score. All bills were paid in time and average transaction amount was not that high ($800). The individual had not been out of the country in the last couple of decades. Here is a list of transactions:
1) Gold jwelleries worth $5000
2) Groceries worth $35
3) Second hand car worth $8,000
4) Burgers worth $10
Which transaction looks fraudulent to you?
There is no specific answer. They just want to see how you think through the problem. One can potentially make use of data in order to deal with this problem. From that, one can estimate the probability of each of these transactions being fraudulent. Econometrically, one can develop a potential binary logit model. That would involve identifying certain features that belong to individuals like the one considered above and use these features to come up with an estimate of the probability of the transaction being a fraud.
Not just that, this also needs to include not individual specific features but external features as well. For example, the first transaction might not be as fraudulent as it looks like, because in heavily regulated markets, the risk associated with reselling the gold or exchanging it for money might be high enough to disincentivise the fraudster from buying gold. Thus regulation might also be a valid feature, and different from features describing an individuals characteristics.
Ofcourse problems of overfitting would arise ifan excessive number of features are used. Various means of finding the optimal Degrees of Freedom can be employed.
Obviously one can do better with more complicated decisioning algorihms that involve machine learning models as well.
Eventually one needs to estimate at what threshold of probability will the trasaction be declared fraudulent.
Interview Preparation Tips
- Econometrics
- Statistics
- Economics
Selected
I applied via Walk-in and was interviewed before Apr 2023. There were 2 interview rounds.
Mettle test on quant and machine learning
(2 Questions)
- Q1. How will you handle an office emergency
- Q2. What are your strengths
Interview Preparation Tips
I was interviewed in Aug 2021.
(1 Question)
Round duration - 90 Minutes
Round difficulty - Medium
5-9pm
- Q1.
Sliding Window Maximum Problem Statement
You are given an array/list of integers with length 'N'. A sliding window of size 'K' moves from the start to the end of the array. For each of the 'N'-'K'+1 possi...
(1 Question)
Round duration - 45 Minutes
Round difficulty - Medium
Timing was Morning-noon
Interviewer was super friendly.
He even helped me at places I got Stuck
- Q1. Can you explain a complex joins problem related to database management systems (DBMS)?
Round duration - 15 Minutes
Round difficulty - Easy
Easiest HR round ever.
Just 15 mins after the technical interview round
Interview Preparation Tips
Tip 1 : Prepare short hand written notes for a quick glance before each interview.
Tip 2 : Start with Easy questions for DSA and Slowly Increase your level to medium and then to hard. Do not Rush things.
Tip 3 : Follow LOVE BABBAR'S DSA sheet. It's the best.
Tip 1 : Mention only genuine Skills on your resume. Do not lie or over-exaggerate
Tip 2 : Do not put Coursera/Udemy or any such Course Certifications on Your Resume, As Interviewers do not care about where You learnt things from, They only care about The things you know.
Skills evaluated in this interview
Raunak Chitlangia
I applied via campus placement at Indian Institute of Technology (IIT), Kharagpur
Interview Preparation Tips
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..
American Express Interview FAQs
The duration of American Express Data Analyst interview process can vary, but typically it takes about less than 2 weeks to complete.
Tell us how to improve this page.
American Express Interviews By Designations
- American Express Analyst Interview Questions
- American Express Business Analyst Interview Questions
- American Express Management Trainee Interview Questions
- American Express Data Analyst Interview Questions
- American Express Software Developer Interview Questions
- American Express Software Engineer Interview Questions
- American Express Financial Analyst Interview Questions
- American Express Business Development Executive Interview Questions
- Show more
American Express Data Analyst Interview Process
based on 10 interviews
1 Interview rounds
- Technical Round
Data Analyst Interview Questions from Similar Companies
Fast track your campus placements
American Express Data Analyst Reviews and Ratings
based on 21 reviews
Rating in categories
1-3 Yrs
₹ 5-24 LPA
2-5 Yrs
₹ 4.3-20 LPA
|
Business Analyst
879
salaries
|  ₹9.7 L/yr - ₹16.8 L/yr |
|
Assistant Manager
718
salaries
| ₹14 L/yr - ₹42 L/yr |
|
Senior Analyst
591
salaries
| ₹5.9 L/yr - ₹23.9 L/yr |
|
Lead Analyst
497
salaries
| ₹4 L/yr - ₹15 L/yr |
|
Analyst
453
salaries
| ₹12.8 L/yr - ₹28 L/yr |
MasterCard
Visa
PayPal
State Bank of India
- Home >
- Interviews >
- American Express Interview Questions >
- American Express Data Analyst Interview Questions
