What is the difference between a business requirement and a functional requirement? Give an example from a retail context.

Define business requirement as high-level need (e.g., reduce order processing time) and functional requirement as specific system behaviour (e.g., auto-validate address at checkout). Show clear distinction.

How would you use SQL to analyse customer purchase patterns for a retail client?

Mention SELECT, JOIN, GROUP BY, and aggregate functions. Example: query to find top-selling products by region or repeat purchase rate.

Explain the purpose of a SWOT analysis in a consulting engagement. When would you use it?

Describe SWOT as a strategic planning tool to assess internal and external factors. Use during market entry, competitive assessment, or turnaround strategy.

What are the key steps in a typical software development life cycle (SDLC) that a business analyst is involved in?

Cover requirements gathering, analysis, documentation, validation, and support during testing and implementation. Highlight BA's role in each phase.

Back to library

GCCs, consulting and the Big 4

Home Depot India GCC Business Analyst Interview: Rounds, Questions and Preparation

For Business Analyst roles at companies like Home Depot India GCC

Share with friends

Preparing together? Send them this role's questions.

https://www.cynchrony.in/library/home-depot-india-gcc-business-analyst

What the job involves

As a Business Analyst in a GCC or consulting firm, you will bridge business needs and technical solutions by gathering requirements, analysing processes, and recommending data-driven improvements. You will work with stakeholders across functions, document functional specifications, and support project delivery. In Big 4 or GCC settings, you may also assist in client engagements, process mapping, and feasibility studies.

Role and Technical Knowledge

1
What is the difference between a business requirement and a functional requirement? Give an example from a retail context.
Define business requirement as high-level need (e.g., reduce order processing time) and functional requirement as specific system behaviour (e.g., auto-validate address at checkout). Show clear distinction.
2
How would you use SQL to analyse customer purchase patterns for a retail client?
Mention SELECT, JOIN, GROUP BY, and aggregate functions. Example: query to find top-selling products by region or repeat purchase rate.
3
Explain the purpose of a SWOT analysis in a consulting engagement. When would you use it?
Describe SWOT as a strategic planning tool to assess internal and external factors. Use during market entry, competitive assessment, or turnaround strategy.
4
What are the key steps in a typical software development life cycle (SDLC) that a business analyst is involved in?
Cover requirements gathering, analysis, documentation, validation, and support during testing and implementation. Highlight BA's role in each phase.

Practical Scenarios and Case Problems

5
A retail client wants to reduce cart abandonment. How would you approach this problem?
Structure: define problem, analyse data (funnel drop-off points), identify root causes (shipping cost, checkout complexity), propose solutions (simplified checkout, reminders), and measure impact.
6
You are asked to map an 'as-is' process for invoice processing. What steps would you take?
Interview stakeholders, document current steps, identify bottlenecks and redundancies, and create a process flow diagram. Suggest 'to-be' improvements.
7
How would you prioritise features for a new analytics dashboard when multiple stakeholders have conflicting demands?
Use prioritisation frameworks like MoSCoW or weighted scoring based on business value, effort, and urgency. Communicate trade-offs clearly.
8
Given a dataset with missing values and outliers, how would you clean it before analysis?
Discuss handling missing data (imputation or removal), identifying outliers via box plots or z-scores, and documenting assumptions.

Behavioural and Situational Questions

9
Tell me about a time you had to explain a complex idea to someone with no technical background.
Use STAR method. Emphasise simplifying language, using analogies, and checking for understanding. Show patience and clarity.
10
Describe a situation where you worked in a team to meet a tight deadline. What was your role?
Highlight collaboration, task division, and your specific contribution. Mention how you handled pressure and communicated progress.
11
How do you handle feedback that you disagree with?
Show openness, ask clarifying questions, and focus on the goal. Give an example where you incorporated feedback after evaluating it.
12
Why do you want to work as a business analyst in a GCC or consulting environment?
Connect your interest in problem-solving and exposure to diverse industries. Mention structured learning, client interaction, and impact.

HR and Company Fit

13
What do you know about the GCC model and how it differs from traditional IT services?
Explain GCC as a captive centre serving the parent company, focusing on innovation and process ownership. Contrast with client-billing model of IT services.
14
Where do you see yourself in three years in this role?
Show ambition to deepen domain expertise, take on larger projects, and possibly lead small teams. Align with typical BA career path.
15
How do you keep yourself updated on business analysis trends and tools?
Mention blogs, webinars, certifications (e.g., CBAP, Agile), and practice with tools like JIRA, Tableau, or Power BI.
16
Are you comfortable with flexible work hours or occasional travel for client meetings?
Be honest but positive. Express willingness to adapt to business needs while maintaining productivity.

Ready to try it for real?

Take a timed test or talk through a mock interview for this role, then see your scores.

This is practice material for Business Analyst roles, written with AI. It is not a list of questions Home Depot India GCC or any other company has asked.