Micron India Business Analyst Interview: Rounds, Questions and Preparation

What the job involves

Business Analysts in GCCs, consulting, and Big 4 firms act as the bridge between business stakeholders and technical teams. They gather requirements, analyse processes, document functional specifications, and support data-driven decisions to improve efficiency and solve client problems. Day to day, they run workshops, create user stories, validate data, and coordinate with developers and testers to deliver solutions.

Role and Technical Knowledge

1. 1

   What is the difference between a functional requirement and a non-functional requirement? Give an example from a manufacturing or IT services context.

   A strong answer defines functional as what the system does (e.g., calculate yield) and non-functional as how it does it (e.g., response time under 2 seconds). Use a relevant example like a production dashboard.

2. 2

   How would you use SQL to find the top 5 customers by revenue from a sales table?

   Mention SELECT, SUM, GROUP BY, ORDER BY DESC, and LIMIT. Show awareness of joining tables if customer names are in another table.

3. 3

   What is a user story, and how do you write acceptance criteria for it?

   Use the 'As a [role], I want [feature] so that [benefit]' format. Acceptance criteria should be specific, testable conditions using Given-When-Then or a checklist.

4. 4

   Explain the purpose of a process flow diagram in business analysis.

   It visually maps steps, decision points, and handoffs to identify bottlenecks, redundancies, and automation opportunities. Mention standard notations like BPMN.

Practical Scenarios

1. 5

   A client says their inventory reports are always late and inaccurate. How would you approach diagnosing and fixing the problem?

   Start by interviewing stakeholders, mapping the current data flow, checking data sources for errors, and proposing quick wins like automated validation or a revised reporting schedule.

2. 6

   You are asked to reduce operational costs by 15 percent in a shared services centre. What data would you collect and what analysis would you perform?

   Collect cost drivers, headcount, process cycle times, and volumes. Perform Pareto analysis, benchmark against industry, and suggest process automation or outsourcing non-core tasks.

3. 7

   Midway through a project, a key stakeholder changes a major requirement. How do you handle it?

   Assess impact on scope, timeline, and cost. Document the change request, discuss trade-offs with the stakeholder, and follow the change control process before updating the plan.

4. 8

   How would you validate that a new software feature meets business needs before full rollout?

   Suggest user acceptance testing with a pilot group, define success metrics like error rate or time saved, and gather feedback through surveys or interviews.

Business Case and Guesstimate

1. 9

   Estimate the market size for business analytics services in India for the manufacturing sector.

   Break down by number of manufacturers, average spend on analytics as a percentage of IT budget, and growth rate. State assumptions clearly and sanity-check the final number.

2. 10

   A retail client wants to increase online sales by 20 percent in one year. What factors would you analyse and what recommendations would you make?

   Analyse website traffic, conversion rates, cart abandonment, competitor pricing, and customer feedback. Recommend A/B testing, loyalty programs, or improved mobile experience.

3. 11

   How would you decide whether to build a custom reporting tool or buy an off-the-shelf solution for a mid-sized company?

   Compare total cost of ownership, time to deploy, scalability, and fit with existing systems. Consider build for unique needs, buy for speed and lower maintenance.

Behavioural and HR

1. 12

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

   Use STAR format. Highlight your specific contribution, how you handled disagreements, and the measurable outcome.

2. 13

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

   Show understanding of diverse client projects, exposure to multiple industries, and structured problem-solving. Mention interest in bridging business and technology.

3. 14

   Describe a situation where you had to explain a technical concept to a non-technical person.

   Focus on simplifying without losing accuracy, using analogies or visuals, and confirming understanding. Highlight patience and clarity.

4. 15

   Where do you see yourself in three years, and how does this role fit your goals?

   Align with growing into a senior BA or consultant role, deepening domain expertise, and taking on more client-facing responsibilities. Show commitment to learning.