American Express India Business Analyst Interview: Rounds, Questions and Preparation

What the job involves

A Business Analyst in a GCC or Big 4 consulting environment works with business and technology teams to understand problems, gather and document requirements, analyse data, and support process improvement or system changes. Day to day you might write user stories, build reports in Excel or SQL, run stakeholder meetings, and translate business needs into clear functional specifications. You act as a bridge between clients or internal business units and delivery teams.

Role and technical knowledge

1. 1

   What is the difference between a BRD and an FRD, and when would you use each?

   Explain that a BRD captures business needs and objectives at a high level, while an FRD details functional requirements for the solution. Mention that BRDs are used early with stakeholders and FRDs guide development.

2. 2

   How would you write a user story for a feature that lets customers view their transaction history?

   Use the format 'As a [user], I want [feature] so that [benefit]' and include acceptance criteria. Show that you think about edge cases like failed transactions or date filters.

3. 3

   What is a process map, and what symbols would you use in a simple flowchart?

   Describe a process map as a visual representation of steps, decisions, and actors. Mention common symbols: oval for start/end, rectangle for process, diamond for decision, arrow for flow.

4. 4

   Write a basic SQL query to find the top 5 customers by total transaction amount from a table called transactions.

   Show a query with SELECT, SUM, GROUP BY, ORDER BY DESC, and LIMIT. Explain that you would join with a customer table if needed and handle nulls.

Practical scenarios

1. 5

   A stakeholder keeps changing requirements mid-sprint. How would you handle this?

   Talk about documenting the change request, assessing impact on timeline and scope, and discussing with the product owner or project manager. Emphasise communication and prioritisation rather than saying no outright.

2. 6

   You are given a spreadsheet with 10,000 rows of customer complaints. How would you analyse it to find the top three issues?

   Outline steps: clean the data, categorise complaints using text or keywords, use pivot tables to count frequency, and visualise with a bar chart. Mention that you would validate with a sample and check for duplicates.

3. 7

   The business team wants a dashboard but has not defined any metrics. What do you do?

   Say you would set up a workshop to understand their goals, propose a few relevant KPIs like transaction volume or resolution time, and create a mock-up for feedback. Stress iterative refinement.

4. 8

   During a UAT session, testers find a critical bug two days before go-live. What is your immediate action?

   Explain that you would log the bug, inform the project manager and development lead, assess severity and workaround, and recommend either a fix or a delay. Show calm prioritisation and risk communication.

Behavioural and situational

1. 9

   Tell me about a time you had to explain a complex idea to someone who did not have a technical background.

   Use STAR format: describe the situation, your action of simplifying with analogies or visuals, and the positive outcome. Highlight patience and clarity.

2. 10

   Describe a situation where you worked in a team to meet a tight deadline. What was your role?

   Focus on your specific contribution, how you coordinated, and the result. Mention tools like shared trackers or daily check-ins if relevant.

3. 11

   Give an example of a time you received negative feedback. How did you respond?

   Show self-awareness and willingness to improve. Describe the feedback, what you changed, and how it helped you grow. Avoid being defensive.

4. 12

   Why do you want to work as a Business Analyst in a GCC or consulting firm rather than a product company?

   Talk about exposure to multiple clients or business functions, structured training, and the chance to solve varied problems. Connect it to your interest in analysis and process improvement.

HR and motivation

1. 13

   What do you understand about the role of a Business Analyst in a global capability centre?

   Mention that GCCs support global operations, so you may work with international stakeholders, follow standard processes, and contribute to efficiency. Show awareness of time zones and cross-cultural communication.

2. 14

   Where do you see yourself in three years as a Business Analyst?

   Express a realistic path: deepening domain knowledge, taking on larger projects, and possibly moving into a senior analyst or product owner role. Align with the company's growth.

3. 15

   How do you handle working with multiple stakeholders who have conflicting priorities?

   Say you listen to each, document their needs, and facilitate a meeting to align on common goals. Mention using data or impact analysis to support decisions.

4. 16

   Are you comfortable with flexible work hours to overlap with global teams?

   Answer positively and give an example of adapting your schedule for a project or study group. Show that you understand the need for occasional early or late calls.