Refinitiv India Business Analyst Interview: Rounds, Questions and Preparation

What the job involves

Business Analysts in GCCs, consulting and Big 4 firms work with client or internal teams to gather requirements, map processes, analyse data and translate business needs into clear functional specifications for technology or operations teams. The role sits between business stakeholders and delivery teams, so you spend time in workshops, documentation, data validation and status reporting. In an established GCC like Refinitiv India, the work often supports global financial data, risk or compliance products, so accuracy and domain context matter.

Role and domain knowledge

1. 1

   Walk me through how you would gather requirements for a new reporting dashboard for a financial data client.

   Cover stakeholder identification, current process pain points, data sources, success metrics and a traceability matrix. Mention how you would validate requirements with both business and technology teams.

2. 2

   What is the difference between a business requirement, a functional requirement and a non-functional requirement? Give an example from a GCC or consulting context.

   Define each clearly and use a financial data example, such as a business need for faster trade reconciliation, a functional need for an automated matching rule and a non-functional need for sub-second latency.

3. 3

   How would you map an as-is process and design a to-be process for a client onboarding workflow?

   Explain using a flowchart or BPMN, identifying handoffs, delays and manual steps. Show how you would quantify time saved or error reduction in the to-be state.

4. 4

   In a Big 4 or GCC project, why is data lineage important for a Business Analyst?

   Link data lineage to auditability, regulatory reporting and trust in dashboards. Mention how you would document source to target mapping and flag gaps to data owners.

Technical and analytical skills

1. 5

   Write a SQL query to find the top 5 clients by total transaction value from a transactions table.

   Use SELECT, SUM, GROUP BY, ORDER BY and LIMIT. Explain how you would handle nulls or duplicate transaction IDs before finalising the result.

2. 6

   How would you use Excel to validate whether a monthly revenue report from two systems matches?

   Mention VLOOKUP or XLOOKUP, pivot tables, conditional formatting for mismatches and a reconciliation summary. Show awareness of row limits and when to move to SQL or Python.

3. 7

   What is a user story, and how do acceptance criteria differ from business rules?

   Define user story format, then explain acceptance criteria as testable conditions and business rules as constraints. Give a financial data example such as a price validation rule versus a story for viewing price history.

4. 8

   How would you prioritise a backlog when a client wants a regulatory report in two weeks but the data quality issues are unresolved?

   Use a framework like MoSCoW or impact versus effort, flag the dependency on data quality and propose a phased release with a manual workaround if needed.

Practical scenarios

1. 9

   A stakeholder tells you the dashboard numbers are wrong, but the data team says the logic is correct. How do you resolve this?

   Start by reproducing the issue, checking filters, time zones and aggregation logic. Then facilitate a joint review with the stakeholder and data team to agree on the definition of the metric.

2. 10

   You are asked to write a business case for automating a manual reconciliation process. What would you include?

   Cover current cost and effort, error rates, proposed solution options, estimated benefits, risks and a simple payback calculation. Mention assumptions and sensitivity analysis.

3. 11

   Mid-project, the client adds a new regulatory requirement that changes the data model. What do you do?

   Assess impact on scope, timeline and cost, document a change request and get sign-off. Communicate the trade-offs clearly and update the requirements traceability matrix.

4. 12

   How would you prepare a weekly status report for a project with multiple workstreams and a tight deadline?

   Use a RAG status, list completed and upcoming milestones, highlight blockers with owners and include decisions needed. Keep it concise and tailored to an executive audience.

Behavioural and HR questions

1. 13

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

   Use STAR format, choose a college project or internship example and focus on how you simplified the message and checked understanding.

2. 14

   Why do you want to work as a Business Analyst in a GCC or consulting environment rather than a pure technology role?

   Show awareness of the client-facing, problem-solving nature of the role and mention exposure to global stakeholders, domain learning and structured career paths.

3. 15

   Describe a situation where you received critical feedback. How did you respond?

   Pick a genuine example, state the feedback clearly, explain the action you took and the measurable improvement. Avoid blaming others.

4. 16

   Are you comfortable with flexible shifts or working across time zones, and what are your salary expectations?

   Be honest about flexibility and research typical fresher bands for GCCs and Big 4 firms. Give a reasonable range and show willingness to learn over negotiating hard.