Add office photos
American Express
CompareProud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
American Express Data Analyst Intern Interview Questions, Process, and Tips
Top American Express Data Analyst Intern Interview Questions and Answers
- Q1. Puzzle There is an island with 100 prisoners, all of who have green eyes. All 100 prisoners are perfect logicians. They all want to escape the island. The condition of es ...read more
- Q2. 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 ...read more
- Q3. 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 balanc ...read more
American Express Data Analyst Intern Interview Experiences
2 interviews found
Selected
I applied via Campus Placement and was interviewed before Mar 2023. There were 3 interview rounds.
Two basic programming questions (30 min) and reasoning/aptitude questions
(1 Question)
- Q1. How will you pull data from a table, given a time interval?
- Ans.
Use SQL query with WHERE clause to pull data from a table based on a time interval.
Use SQL query with SELECT statement to specify the columns you want to retrieve.
Add a WHERE clause with the condition for the time interval, using appropriate date/time functions.
Example: SELECT * FROM table_name WHERE timestamp_column BETWEEN 'start_time' AND 'end_time';
(1 Question)
- Q1. How would you run a business on a state level to maximize your sales?
- Ans.
To maximize sales on a state level, focus on market research, targeted marketing strategies, strong customer service, and strategic partnerships.
Conduct market research to understand the local consumer behavior and preferences
Implement targeted marketing strategies based on the research findings
Provide excellent customer service to build loyalty and attract repeat business
Form strategic partnerships with local business...
Interview Preparation Tips
Skills evaluated in this interview
CodingNinjas
I was interviewed before Jan 2021.
(3 Questions)
Round duration - 60 Minutes
Round difficulty - Medium
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.
- Q1. 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? - Q2. 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.
- Q3. Puzzle
- There is an island with 100 prisoners, all of who have green eyes.
- All 100 prisoners are perfect logicians.
- They all want to escape the island.
- The condition of escaping the island is that one can deduc...
(1 Question)
Round duration - 60 Minutes
Round difficulty - Hard
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.
- Q1. 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 ...
Interview Preparation Tips
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.
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)
Top trending discussions
Interview questions from similar companies
Data Analyst Intern Interview Questions & Answers
JPMorgan Chase & Co.
Anonymous
posted on 7 Feb 2024
(1 Question)
- Q1. Explain about Projects
Selected
I applied via campus placement at Vellore Institute of Technology (VIT) and was interviewed before Jul 2022. There were 4 interview rounds.
There was an aptitude test with 30 questions to complete within 45 min.
3 Coding questions to complete within 1hr.
(2 Questions)
- Q1. HR round was simple and was about how my skills can fit into the organisation.
- Q2. What are my skills and how you will use them (gave me a scenario)?
Data Scientist Interview Questions & Answers
Commonwealth Bank of Australia, India
Anonymous
posted on 11 Dec 2024
I applied via Recruitment Consulltant and was interviewed in Nov 2024. There was 1 interview round.
(2 Questions)
- Q1. Detailed project questions
- Q2. Explain completed gen ai project
- Ans.
Developed a generative AI model to create realistic images of fictional characters.
Used GANs (Generative Adversarial Networks) to generate new images based on existing data.
Trained the model on a dataset of character images from various sources.
Implemented techniques like style transfer to enhance the diversity and creativity of generated images.
Evaluated the model's performance based on image quality metrics and user
Skills evaluated in this interview
I applied via LinkedIn and was interviewed in Jul 2024. There were 3 interview rounds.
Assignment on credit risk
(1 Question)
- Q1. Hyperparameter tuning
(1 Question)
- Q1. Case study for problem solving
Lead Data Analyst Interview Questions & Answers
Fidelity Investments
Anonymous
posted on 29 Jul 2024
(2 Questions)
- Q1. Talked about previous experience in detail.
- Q2. Asked some case studies regarding their products
Interview Preparation Tips
Question on Probability and basic aptitude questions
(2 Questions)
- Q1. Question were related to Past projects
- Q2. SQL and Excel medium level questions
Lead Data Scientist Interview Questions & Answers
JPMorgan Chase & Co.
Anonymous
posted on 14 Jun 2024
I applied via Referral and was interviewed in May 2024. There was 1 interview round.
(4 Questions)
- Q1. Given a variable, how to do Linear Regression?
- Ans.
Linear regression is a statistical method used to model the relationship between a dependent variable and one or more independent variables.
Collect data on the variables of interest
Plot the data to visualize the relationship between the variables
Choose a suitable linear regression model (simple or multiple)
Fit the model to the data using a regression algorithm (e.g. least squares)
Evaluate the model's performance using ...
- Q2. How Linear Regression handles noise?
- Ans.
Linear Regression minimizes noise by fitting a line that best represents the relationship between variables.
Linear Regression minimizes the sum of squared errors between the actual data points and the predicted values on the line.
It assumes that the noise in the data is normally distributed with a mean of zero.
Outliers in the data can significantly impact the regression line and its accuracy.
Regularization techniques l...
- Q3. Solve two equations to find coefficients?
- Ans.
Use linear algebra to solve for coefficients in two equations.
Set up the two equations with unknown coefficients
Solve the equations simultaneously using methods like substitution or elimination
Example: 2x + 3y = 10 and 4x - y = 5, solve for x and y
- Q4. Probability question on picking a red ball from Red, blue, black ball bag with replacement.
Interview Preparation Tips
Skills evaluated in this interview
I applied via Referral and was interviewed in Nov 2024. There were 2 interview rounds.
(4 Questions)
- Q1. Types of Chunking in data preparation in RAG
- Q2. How Embedding works in Vector Databases
- Q3. Explain ARIMA model
- Q4. How can we decide to choose Linear Regression for a business problem
(4 Questions)
- Q1. What is token and it's limit for Open Source LLMs
- Q2. Difference of a Regression and Time Series problem
- Q3. Advantage of LSTM over RNN
- Q4. Performance Metrics for Logistic Regression
American Express Interview FAQs
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 Business Development Executive Interview Questions
- American Express Customer Service Executive Interview Questions
- Show more
Interview Questions for Popular Designations
- Data Scientist Interview Questions
- Data Science Intern Interview Questions
- Senior Data Analyst Interview Questions
- Senior Data Scientist Interview Questions
- Data Scientist Intern Interview Questions
- Jr. Data Scientist Interview Questions
- Associate Data Scientist Interview Questions
- Data Science Engineer Interview Questions
- Show more
People are getting interviews through
Interview Questions from Similar Companies
Fast track your campus placements
|
Business Analyst
890
salaries
|  ₹9.8 L/yr - ₹17 L/yr |
|
Assistant Manager
696
salaries
| ₹14 L/yr - ₹42 L/yr |
|
Senior Analyst
565
salaries
| ₹5.3 L/yr - ₹23 L/yr |
|
Analyst
550
salaries
| ₹12.5 L/yr - ₹28 L/yr |
|
Lead Analyst
546
salaries
| ₹4 L/yr - ₹13 L/yr |
MasterCard
Visa
PayPal
State Bank of India
Calculate your in-hand salary
- Home >
- Interviews >
- American Express Interview Questions >
- American Express Data Analyst Intern Interview Questions
