Upload Button Icon Add office photos

Filter interviews by

American Express Lead Business Analyst Interview Questions and Answers

Updated 14 Mar 2024

American Express Lead Business Analyst Interview Experiences

1 interview found

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Referral and was interviewed in Feb 2024. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. 1) Difference between Inner join and outer join. Explain it to a non technical person
  • Ans. 

    Inner join combines only matching rows from two tables, while outer join includes all rows from one table and only matching rows from the other.

    • Inner join only includes rows that have matching values in both tables

    • Outer join includes all rows from one table and only matching rows from the other

    • Example: Inner join would return only customers who have made a purchase, while outer join would return all customers with thei

  • Answered by AI

Skills evaluated in this interview

Interview questions from similar companies

I applied via Naukri.com and was interviewed before Apr 2020. There was 1 interview round.

Interview Questionnaire 

3 Questions

  • Q1. Bcbs 424 related
  • Q2. Credit risk basics
  • Q3. Frm related basic

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare cv throughly
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(2 Questions)

  • Q1. What is a user story
  • Ans. 

    A user story is a concise description of a software feature from an end-user perspective.

    • Describes the feature to be implemented

    • Written from the user's point of view

    • Includes the reason for the feature and the benefit it provides

    • Typically follows the format: As a [type of user], I want [some goal] so that [some reason]

  • Answered by AI
  • Q2. What is a use case diagram
  • Ans. 

    A use case diagram is a visual representation of the interactions between users and a system.

    • It shows the different ways users can interact with a system

    • It helps to identify the actors involved in the system

    • It outlines the various use cases or scenarios of how the system will be used

    • It is often used in software development to understand and communicate system requirements

  • Answered by AI

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via LinkedIn and was interviewed in Aug 2024. There was 1 interview round.

Round 1 - One-on-one 

(2 Questions)

  • Q1. What is a user story
  • Ans. 

    A user story is a concise description of a software feature from an end-user perspective.

    • Describes the feature to be implemented

    • Written from the user's point of view

    • Includes the reason for the feature and the benefit it provides

    • Follows a specific format: As a , I want so that

  • Answered by AI
  • Q2. How do you create Wireframes
  • Ans. 

    I create wireframes by gathering requirements, sketching initial ideas, using wireframing tools, and iterating based on feedback.

    • Gather requirements from stakeholders to understand project goals

    • Sketch initial wireframe ideas on paper or using digital tools like Sketch or Adobe XD

    • Create wireframes using wireframing tools to visualize layout, content, and functionality

    • Iterate on wireframes based on feedback from stakehol

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Interview was easy

Skills evaluated in this interview

I applied via Recruitment Consultant

Interview Questionnaire 

2 Questions

  • Q1. Technical
  • Q2. Finance
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed before Nov 2022. There were 3 interview rounds.

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 tips
Round 2 - One-on-one 

(1 Question)

  • Q1. Basic on experience and skill on their requirement on Tableau and MS suites
Round 3 - HR 

(1 Question)

  • Q1. Salary requirement n doubt clearing

I applied via Recruitment Consultant and was interviewed before Sep 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Do you still expect to get a hike in this pandemic

Interview Preparation Tips

Interview preparation tips for other job seekers - The straight forward answer got me a good hike.

Answer was
Frankly speaking getting a job in this pandemic would be enough fore but i think as per the name and big company like you should maintain the reputation and give a decent hike despite of a pandemic.

I applied via Naukri.com and was interviewed before Feb 2021. There was 1 interview round.

Round 1 - One-on-one 

(1 Question)

  • Q1. Be well prepared for technical round as this will be a make or break for you

Interview Preparation Tips

Topics to prepare for HSBC Group Business Analyst interview:
  • Technical
Interview preparation tips for other job seekers - Prepare well for technical round

Interview Questionnaire 

1 Question

  • Q1. It was mostly about the instrument reference data and typical business analyst question about change management, BRD, Agile and technology we use.

I appeared for an interview before Sep 2020.

Round 1 - Coding Test 

(1 Question)

Round duration - 90 minutes
Round difficulty - Medium

It was a cumulative test

  • Q1. 

    Trapping Rainwater Problem Statement

    You are given an array ARR of long type, which represents an elevation map where ARR[i] denotes the elevation of the ith bar. Calculate the total amount of rainwater t...

  • Ans. 

    Calculate the total amount of rainwater that can be trapped within given elevation map.

    • Iterate through the array to find the maximum height on the left and right of each bar.

    • Calculate the amount of water that can be trapped above each bar by taking the minimum of the maximum heights on the left and right.

    • Sum up the trapped water above each bar to get the total trapped water for the elevation map.

  • Answered by AI
Round 2 - Coding Test 

(1 Question)

Round duration - 90 minutes
Round difficulty - Medium

It was sophisticated in nature and a good brain buster.

  • Q1. 

    Candies Distribution Problem Statement

    Prateek is a kindergarten teacher with a mission to distribute candies to students based on their performance. Each student must get at least one candy, and if two s...

  • Ans. 

    Determine the minimum number of candies needed to distribute to students based on their performance and ratings.

    • Iterate through the array of student ratings and assign 1 candy to each student initially.

    • Then iterate from left to right and check if the current student's rating is higher than the previous student, if so, assign candies accordingly.

    • Similarly, iterate from right to left to handle cases where the current stu...

  • Answered by AI
Round 3 - Face to Face 

(1 Question)

Round duration - 1 hour
Round difficulty - Medium

  • Q1. DBMS

    It revolved around basic concepts

  • Ans. 

    DBMS is a software system that manages databases and allows users to interact with data stored in them.

    • DBMS stands for Database Management System

    • It helps in creating, updating, and managing databases

    • Examples of DBMS include MySQL, Oracle, SQL Server

    • It ensures data integrity, security, and efficient retrieval

  • Answered by AI
Round 4 - Group Discussion 

Round duration - 70 minutes
Round difficulty - Hard

It was a great experience

Interview Preparation Tips

Professional and academic backgroundI applied for the job as SDE - 1 in HyderabadEligibility criteriaGood Resume and 7 CGPA +Morgan Stanley interview preparation:Topics to prepare for the interview - I have done a rigourous training on Data Structure and Algorithms. It really helped me a lot to excel in life. Also I did vocational courses which enhanced my personality. I did analytical mindset training with problem solving methodologies. The hands on training on Python and Unix helped me a lot.Time required to prepare for the interview - 8 monthsInterview preparation tips for other job seekers

Tip 1 : Stay consistent with your efforts
Tip 2 : Work hard with honesty
Tip 3 : Try to set goal of +1 level from the goal you want to achieve

Application resume tips for other job seekers

Tip 1 : Present yourself with honesty
Tip 2 : Mention about the Workshops, hackathons, achievements, and the projects.

Final outcome of the interviewSelected

Skills evaluated in this interview

American Express Interview FAQs

How many rounds are there in American Express Lead Business Analyst interview?
American Express interview process usually has 1 rounds. The most common rounds in the American Express interview process are Technical.
How to prepare for American Express Lead Business Analyst 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 American Express. The most common topics and skills that interviewers at American Express expect are Analytics, SQL, Auditing, Automation and Data Management.

Tell us how to improve this page.

American Express Lead Business Analyst Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more

Interview Questions from Similar Companies

Wells Fargo Interview Questions
3.8
 • 586 Interviews
Citicorp Interview Questions
3.7
 • 573 Interviews
HSBC Group Interview Questions
3.9
 • 491 Interviews
BNY Interview Questions
3.8
 • 352 Interviews
UBS Interview Questions
3.9
 • 339 Interviews
Morgan Stanley Interview Questions
3.6
 • 293 Interviews
FactSet Interview Questions
3.9
 • 210 Interviews
View all
American Express Lead Business Analyst Salary
based on 166 salaries
₹5 L/yr - ₹19.5 L/yr
45% less than the average Lead Business Analyst Salary in India
View more details

American Express Lead Business Analyst Reviews and Ratings

based on 28 reviews

4.6/5

Rating in categories

3.8

Skill development

4.6

Work-life balance

4.1

Salary

4.8

Job security

4.7

Company culture

3.0

Promotions

3.9

Work satisfaction

Explore 28 Reviews and Ratings
Business Analyst
812 salaries
unlock blur

₹9.5 L/yr - ₹16.8 L/yr

Assistant Manager
709 salaries
unlock blur

₹14.4 L/yr - ₹42 L/yr

Senior Analyst
606 salaries
unlock blur

₹14.7 L/yr - ₹27 L/yr

Analyst
543 salaries
unlock blur

₹12.7 L/yr - ₹25 L/yr

Lead Analyst
494 salaries
unlock blur

₹4.2 L/yr - ₹13 L/yr

Explore more salaries
Compare American Express with

MasterCard

3.9
Compare

Wells Fargo

3.8
Compare

JPMorgan Chase & Co.

3.9
Compare

HSBC Group

3.9
Compare
Did you find this page helpful?
Yes No
write
Share an Interview