American Express interview experience Real time questions & tips from candidates to crack your interview

Data Analyst Intern

American Express
upvote
share-icon
4 rounds | 4 Coding problems

Interview preparation journey

expand-icon
Preparation
Duration: 1 Month
Topics: SQL, Python, Big Data-Hadoop(Beginner), Logical Aptitude, Logical Puzzles
Tip
Tip

Tip 1 : Practice a lot of puzzles and aptitude based questions, the interviewer will check your approach. Be calm and think carefully before answering.
Tip 2 : Prepare the projects on your resume well and practice mock interviews amongst your batchmates.
Tip 3 : ML Projects are good to have as they show your experience on working with data.

Application process
Where: Campus
Eligibility: Above 7.5 CGPA
Resume Tip
Resume tip

Tip 1 : Make it concise and relevant to the Job Description shared.
Tip 2 : List and explain projects in an efficient manner(Aim, Approach, Tech Stack, Individual Contributions)

Interview rounds

01
Round
Easy
Coding Test - Pen and paper
Duration25 Minutes
Interview date8 Aug 2019
Coding problem0

First round was pen & paper based, I was given 30 mins to solve 25 questions based on logical aptitude, data interpretation.
Timing: In the morning
My score was 21/25.
Only 33% of the students were taken ahead to the next rounds.

02
Round
Medium
Face to Face
Duration60 Minutes
Interview date8 Sep 2019
Coding problem3

First Question: Tell me about yourself.

Puzzle/Problem Solving round, I was asked 3 different puzzles and the interviewer checked my approach towards the puzzle. I was able to solve 2/3 completely.
Paper & Pen were provided.

1. Puzzle

You have 9 balls, equally big, equally heavy - except for one, which is a little heavier.

How would you identify the heavier ball if you could use a pair of balance scales only twice?

2. Puzzle

How will you measure 4 litre of water from a 3 litre and 5 litre jug? There are no measurement lines on the jug. You can use any amount of water but only those 2 jugs.

3. Puzzle

  1. There is an island with 100 prisoners, all of who have green eyes.
  2. All 100 prisoners are perfect logicians.
  3. They all want to escape the island.
  4. The condition of escaping the island is that one can deduce one’s own eye colour, and tell the guards the answer at midnight. If the answer is correct, the prisoner is set free. Else, he/she is killed.
  5. The restrictions are: None of them knows their own eye colour (through mirrors, reflective surfaces or otherwise), and none of them is allowed to communicate with one another through any means whatsoever.
  6. However, they can see each other and know everybody else’s eye colour.

You are a guest of the island owner (now called the IO). You want to free all the prisoners. The IO allows you to:

  1. Make one and only one statement in the form of an announcement to all prisoners.
  2. The statement does not convey any new information.
03
Round
Hard
Face to Face
Duration60 Minutes
Interview date8 Aug 2019
Coding problem1

This round was a continuation from the previous round. More grilling puzzles were asked and resume based questions were also asked. 
Interviewer was clear with the details from the question and with its specifics, they listened to me patiently without any interruptions and told where I was wrong(if). 
Project based questions were asked around DBMS, ML, SQL.

1. Puzzle

I was asked to generalize a puzzle for 'n' values from the previous round. 
The puzzle was 

You have 9 balls, equally big, equally heavy - except for one, which is a little heavier.

How would you identify the heavier ball if you could use a pair of balance scales only twice?

This was asked in previous round for '9' balls, I was asked to do it for 'n' balls using my logics.
Paper & Pen were provided.

04
Round
Easy
HR Round
Duration10 Minutes
Interview date8 Aug 2019
Coding problem0

General HR round:

Topics included some behavioral questions such why this company, which location would you prefer and why, any questions that you would like to ask us. Prepare & Communicate well for this round.

Here's your problem of the day

Solving this problem will increase your chance to get selected in this company

Skill covered: Programming

What is the output of print(type("Python"))?

Choose another skill to practice
Similar interview experiences
company logo
SDE - 1
4 rounds | 7 problems
Interviewed by American Express
3901 views
0 comments
0 upvotes
company logo
Software Developer
3 rounds | 5 problems
Interviewed by American Express
1771 views
0 comments
0 upvotes
company logo
SDE - 1
3 rounds | 4 problems
Interviewed by American Express
2488 views
0 comments
0 upvotes
company logo
SDE - 2
3 rounds | 5 problems
Interviewed by American Express
3803 views
0 comments
0 upvotes