Aptiv India Business Analyst Interview: Rounds, Questions and Preparation

What the job involves

As a Business Analyst in a GCC, consulting firm, or Big 4, you will bridge business needs and technical solutions by gathering requirements, analysing processes, and supporting data-driven decisions. Day to day, you might document functional specifications, create process maps, build dashboards, and coordinate with developers and stakeholders to ensure project goals are met.

Role and Technical Knowledge

1. 1

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

   Define business requirement as high-level need (e.g., reduce order processing time) and functional requirement as specific system behaviour (e.g., automate order entry via API). Use an example like a supply chain dashboard for an automotive GCC.

2. 2

   How would you use SQL to analyse customer churn data for a consulting client?

   Explain steps: identify tables (customers, transactions), write queries to calculate churn rate, segment by demographics, and join tables. Mention using GROUP BY, JOIN, and subqueries.

3. 3

   What are the key elements of a Business Requirement Document (BRD) and how does it differ from a Functional Requirement Document (FRD)?

   BRD covers business objectives, scope, stakeholders, and high-level needs; FRD details system functionalities, inputs, outputs, and rules. Emphasize that BRD is from business perspective, FRD from technical.

4. 4

   In Agile, what is the role of a Business Analyst during sprint planning and backlog grooming?

   BA helps prioritise user stories, clarifies requirements, ensures acceptance criteria are clear, and assists in estimating effort. Mention collaboration with Product Owner and Scrum Master.

Practical Scenarios

1. 5

   A client in the manufacturing sector wants to reduce inventory costs but has no clear data. How would you approach this problem?

   Start by identifying data sources (ERP, spreadsheets), conduct stakeholder interviews, map current inventory process, and suggest quick wins like ABC analysis. Highlight iterative data collection and validation.

2. 6

   You are asked to create a dashboard for tracking project KPIs for a Big 4 consulting engagement. What steps would you take?

   Define KPIs with stakeholders (e.g., budget variance, milestone completion), choose a tool (Power BI), design mockups, validate with users, and iterate. Mention data modelling and refresh schedules.

3. 7

   During a process mapping workshop, two departments disagree on the current process flow. How do you handle it?

   Facilitate a session to document both views, use a swimlane diagram to visualize, and identify common ground. Suggest a follow-up with data to validate the actual process.

4. 8

   You notice that a proposed solution will increase costs but may not deliver expected benefits. How do you communicate this to the project sponsor?

   Prepare a cost-benefit analysis with scenarios, present alternatives, and recommend a phased approach. Emphasize data-backed reasoning and alignment with business goals.

Behavioural and HR

1. 9

   Tell me about a time you worked in a team to solve a problem. What was your role?

   Use STAR format: describe situation, task, action (e.g., coordinated with teammates to analyse data), and result (e.g., improved process efficiency). Highlight collaboration and communication.

2. 10

   Why do you want to work as a Business Analyst in a GCC or consulting environment?

   Show awareness of GCC/consulting work: diverse projects, client exposure, and analytical challenges. Link to your skills and long-term career goals in business analysis.

3. 11

   Describe a situation where you had to learn a new tool or technology quickly. How did you manage?

   Pick a relevant example (e.g., learning SQL for a project). Explain your learning approach, resources used, and how you applied it effectively within deadlines.

4. 12

   How do you handle feedback or criticism from a senior stakeholder?

   Emphasize active listening, not taking it personally, asking clarifying questions, and implementing changes. Provide an example where feedback improved your work.

Company and Sector Awareness

1. 13

   What do you understand about the role of a Business Analyst in a Global Capability Centre (GCC)?

   Explain that GCCs provide offshore support for global operations, and BAs act as liaisons between onshore clients and offshore teams, ensuring requirements are accurately translated and delivered.

2. 14

   How do consulting firms like the Big 4 add value to clients through business analysis?

   Discuss how BAs in consulting identify inefficiencies, recommend process improvements, and support digital transformation. Mention frameworks like SWOT, Porter's Five Forces, and data-driven insights.

3. 15

   What are some current trends in business analysis that companies like Aptiv India might leverage?

   Mention trends like AI in requirements gathering, low-code tools, remote collaboration, and data privacy. Relate to automotive/tech sector if possible, but avoid claiming specific company practices.

4. 16

   Why are you interested in working for a company like Aptiv India?

   Research Aptiv's industry (automotive technology) and values. Express interest in contributing to innovative projects, and align your skills with the company's focus on safe, green, and connected solutions.