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 Intern Interview Questions and Answers
American Express Data Analyst Intern Interview Experiences
1 interview 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
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
Associate Data Scientist Interview Questions & Answers
Commonwealth Bank of Australia, India
Anonymous
posted on 23 Dec 2021
I applied via Recruitment Consultant and was interviewed before Dec 2020. There were 3 interview rounds.
Interview Questionnaire
1 Question
- Q1. Questions were basically related to the projects done previously. If you have knowledge about statistics and model interviews you can clear interviews.
Interview Preparation Tips
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 Software Engineer Interview Questions
- American Express Data Analyst Interview Questions
- American Express Software Developer 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
American Express Data Analyst Intern Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
Fast track your campus placements
|
Business Analyst
886
salaries
|  ₹9.6 L/yr - ₹17 L/yr |
|
Assistant Manager
709
salaries
| ₹14 L/yr - ₹42 L/yr |
|
Senior Analyst
583
salaries
| ₹5.8 L/yr - ₹23.1 L/yr |
|
Analyst
504
salaries
| ₹12.5 L/yr - ₹27 L/yr |
|
Lead Analyst
490
salaries
| ₹4 L/yr - ₹13 L/yr |
MasterCard
Visa
PayPal
State Bank of India
- Home >
- Interviews >
- American Express Interview Questions >
- American Express Data Analyst Intern Interview Questions
