Cigna 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 technology teams, gathering requirements, documenting processes, and supporting data-driven decisions. Day to day, they conduct workshops, write user stories and functional specs, create process maps, and validate solutions through testing and stakeholder feedback. In an established GCC like Cigna India, the role often supports healthcare, insurance, or shared-services operations, requiring comfort with both business metrics and basic technical tools.

Role and Domain Knowledge

1. 1

   What is the difference between a business requirement and a functional requirement? Give an example from an insurance or healthcare process.

   A strong answer distinguishes the high-level business need (e.g., reduce claim processing time) from the specific system function (e.g., auto-validate policy number against the claims system). Use a concrete example.

2. 2

   How would you map an as-is process for a claims intake team in a GCC, and what would you look for to identify waste?

   Mention tools like flowcharts or BPMN, interviewing process owners, and looking for delays, rework, manual handoffs, and duplicate data entry. Show awareness of GCC cost and quality goals.

3. 3

   What are the key sections of a Business Requirements Document (BRD) or a user story, and why does each matter?

   Cover problem statement, scope, stakeholders, assumptions, functional and non-functional requirements, acceptance criteria, and traceability. Explain how each reduces rework.

4. 4

   In a Big 4 or GCC context, what does 'requirement traceability' mean and how would you maintain it?

   Explain linking each requirement to its source, design, test case, and sign-off. Mention tools like JIRA, Excel matrices, or requirement management tools and the benefit for audits and change control.

Technical and Analytical Skills

1. 5

   Write a SQL query to find the top 5 customers by total premium paid in the last year from a table with customer_id, premium_amount, and payment_date.

   Show SELECT, SUM, WHERE with date filter, GROUP BY customer_id, ORDER BY total DESC, LIMIT 5. Explain how you would validate the result against a known total.

2. 6

   How would you use Excel to analyze a dataset of 10,000 claim records to find the average processing time by claim type?

   Mention pivot tables, AVERAGEIFS or SUMIFS, and data cleaning steps like removing duplicates and handling blanks. Discuss how you would present findings in a chart or dashboard.

3. 7

   What is the difference between a process flow diagram and a data flow diagram? When would you use each?

   Process flow shows steps, decisions, and actors; data flow shows how data moves between systems, stores, and processes. Give a scenario for each, such as onboarding vs. system integration.

4. 8

   How would you validate that a new reporting dashboard meets business needs before full rollout?

   Talk about defining acceptance criteria, doing a pilot with a small user group, checking data accuracy against source systems, and collecting structured feedback for iteration.

Practical Scenarios and Case Questions

1. 9

   A stakeholder keeps changing requirements mid-sprint. How would you handle this while keeping the project on track?

   Show empathy for changing business needs, then explain impact analysis, prioritization with the product owner, documenting changes, and using a change control process to avoid scope creep.

2. 10

   You are asked to improve the turnaround time of a policy issuance process that currently takes 5 days. How would you approach this?

   Structure your answer: map the current process, identify bottlenecks and manual steps, propose quick wins and automation, estimate impact, and define metrics to track improvement.

3. 11

   The development team says a requirement is not feasible within the timeline. How do you respond to the business stakeholder?

   Show you would gather technical constraints, explore alternatives or phased delivery, quantify trade-offs, and communicate transparently with options rather than just saying no.

4. 12

   You notice a discrepancy between two reports used by different teams. How would you investigate and resolve it?

   Describe tracing data sources, checking definitions and filters, involving data owners, documenting the root cause, and aligning both teams on a single source of truth.

Behavioural and HR Questions

1. 13

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

   Use STAR format: describe the audience, how you simplified using analogies or visuals, and the positive outcome such as agreement or faster decision-making.

2. 14

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

   Show awareness of GCC and consulting work: diverse projects, exposure to global stakeholders, structured processes, and learning across domains. Connect it to your long-term goals.

3. 15

   Describe a situation where you worked in a team under a tight deadline. What was your contribution?

   Highlight planning, prioritization, clear communication, and supporting teammates. Quantify the result if possible, such as meeting the deadline or reducing errors.

4. 16

   Where do you see yourself in three years, and how does this role fit into that plan?

   Show realistic progression such as deepening domain expertise, leading small projects, or moving into senior BA roles. Align your answer with the company's career paths without overpromising.