Virtusa Business Analytics Interview Questions & Answers
Curated interview practice questions with answers. These are practice scenarios, not a verified list of past interview questions.
About Virtusa hiring for Business Analytics roles
Virtusa is a digital engineering and IT services company providing application development, testing, cloud and data services. It has a strong client base in banking, financial services, healthcare and telecom. Its India centres in Hyderabad, Chennai and Bengaluru hire for software engineers, test engineers and data professionals.
For Business Analytics roles, this Virtusa practice set focuses most on Requirements and Agile (8), Case Studies and Guesstimates (7), SQL for Business Analysis (5), Product Analytics (5). It has 22 easy, 18 medium questions, so you can start easy and work up to the harder ones.
Company type
IT services
Headquarters
Southborough, Massachusetts, USA
Main India offices
Hyderabad, Chennai, Bengaluru
Virtusa Business Analytics interview process
Online assessment (aptitude + reasoning)
Coding test
Technical interview
HR round
Typical pattern based on public candidate experiences. Rounds vary by role, team and year.
Solved for VirtusaStart practicing
3 QUESTIONS FREESign up to unlock the full question bank and track your progress.Unlock every question and answer, then continue practising company-wise and package-wise.
✓ 3 questions free • Unlock the rest in seconds
01
What are window functions in SQL and how are they different from GROUP BY?
A window function calculates across a set of related rows using OVER(), but it keeps every original row instead of collapsing them. GROUP BY returns one row per group. For example, SUM(amount) OVER (PARTITION BY region) shows each order next to its region total, which helps compute share of total, rankings, running totals and month-over-month change. Common window functions are ROW_NUMBER, RANK, LAG, LEAD and SUM.
A live connection queries the source database every time the view changes, so data is current but speed depends on the database. An extract (.hyper file) is a compressed snapshot stored by Tableau that is fast to query and can be refreshed on a schedule, but it is only as fresh as the last refresh. Extracts suit large, slow or remote sources; live suits fast warehouses and real-time needs.
05
What is product analytics and how is it different from business reporting?
Product analytics studies how users behave inside a digital product, using event data such as sign-ups, clicks, feature use and purchases, to improve activation, engagement and retention. Business reporting usually summarises outcomes like revenue, cost and orders by period. Product analytics answers questions like where users drop off, which features retained users adopt, and whether a change worked, often through funnels, cohorts and experiments.
MECE means Mutually Exclusive and Collectively Exhaustive. When you break a problem into parts, the parts should not overlap and together should cover every possibility. For example, profit splits into revenue and cost, and revenue into price times volume. A breakdown of customers into 'young' and 'students' is not MECE because they overlap. MECE structures prevent double counting and missed causes, which is what interviewers check.
XLOOKUP can look left or right, uses exact match by default, returns a custom value if nothing is found and doesn't break when columns move. VLOOKUP only looks right and needs a column number.
Uncontrolled growth of requirements. Control it with a clear scope statement, change control process, impact analysis and sponsor approval for additions.
A BA bridges business and technology: gathers requirements, analyses data and processes, documents BRD/FRD and makes sure the final solution actually solves the business problem.
A language for querying databases. BAs use it to pull data themselves, validate numbers, check reports and answer questions without waiting for engineers.
11
What is the difference between correlation and causation in product analytics?
Correlation means two metrics move together; causation means one actually changes the other. Users who use the wishlist feature may retain better, but they may simply be more engaged users already. Acting on correlation alone can waste effort, such as forcing everyone into the wishlist. To establish causation, run an A/B test, or use quasi-experimental methods such as difference-in-differences when a test is not possible, and always check for confounders like user tenure or acquisition channel.
A use case describes the full interaction between an actor and the system (main and alternate flows). A user story is a short statement of need from the user's point of view, refined with acceptance criteria.
13
What is backlog refinement and what is the BA's role in it?
Backlog refinement, also called grooming, is a regular session where the team reviews upcoming backlog items to clarify, split, estimate and order them, so the next sprints have ready work. The BA prepares the stories in advance with business context, acceptance criteria, rules and examples, answers questions from developers and testers, and captures follow-ups. It is usually a short weekly session, not a sprint ceremony.
14
What is the difference between a pool and a lane in BPMN?
A pool represents a separate participant in a process, such as the customer, your company or an external bank. A lane is a subdivision inside a pool, usually a department, role or system, such as Sales, Finance and Warehouse within your company. Sequence flows can cross lanes within one pool, but communication between two pools must be shown with message flows, because separate participants do not share one controlled flow.
CAC is total sales and marketing spend in a period divided by new customers acquired in that period. If you spend 10 lakh and gain 2,000 customers, CAC is 500 rupees. CAC payback period is how many months of gross profit from a customer it takes to recover that CAC. A shorter payback means the business can reinvest faster; many subscription businesses aim for under 12 months.
17
Guesstimate: how many cars are sold in India every year?
Structure it: households × car-owning share ÷ replacement cycle + first-time buyers + commercial fleet. State each assumption clearly and sanity-check the final number.
18
A quick-commerce company wants to expand into Tier-2 cities. What would you analyse before recommending it?
Demand: population density, smartphone and digital payment penetration, average basket size and how often people buy groceries. Supply: dark store rent, rider availability and local sourcing. Unit economics: orders per store per day needed to break even, given lower average order values. Competition: local kirana delivery and other apps. Then propose a pilot in two or three cities with clear success metrics such as orders per day, contribution margin per order and repeat rate before scaling.
19
Write an Excel formula to extract the domain from an email address.
All three number rows within a window ordered by a column. ROW_NUMBER gives a unique sequence 1, 2, 3 even for ties. RANK gives ties the same number and then skips, so 1, 1, 3. DENSE_RANK gives ties the same number without gaps, so 1, 1, 2. Use ROW_NUMBER to pick exactly one row per group, such as the latest order, and DENSE_RANK for 'top 3 distinct salary levels' type questions.
21
Tell me about a time poor or outdated documentation caused a problem. How did you fix it?
Situation: a new developer built a GST calculation from an old FRD version, and the error was caught only in UAT. Task: fix the defect and prevent repeats. Action: I moved all requirement documents into one shared space with version history, added a change log and status labels such as draft or approved, and linked each user story to the latest approved section. Result: in the next two releases we had no defects caused by outdated specifications.
22
Write Given-When-Then acceptance criteria for applying a discount coupon at checkout.
Given a cart of 1,200 rupees and a valid coupon SAVE10 with a minimum order of 1,000 rupees, when the user applies it, then 10 percent is deducted and the new total is shown. Given an expired coupon, when applied, then the message 'This coupon has expired' appears and the total is unchanged. Given a cart below the minimum, when applied, then the user is told how much more to add.
Map the steps first: which files arrive, what cleaning is done and which outputs are needed. Move the import and cleaning into Power Query so a refresh replaces copy-paste. Base calculations on Excel Tables and PivotTables that update automatically, and keep a fixed template for the output. Use a small macro or Office Script only for the remaining formatting or emailing. Add checks such as row counts and totals so errors surface quickly.
25
What is the difference between churn rate and retention rate?
Churn rate is the percentage of customers who leave in a period: customers lost divided by customers at the start. Retention rate is the percentage who stay, roughly 100 minus churn for the same cohort. If you start a month with 1,000 subscribers and 50 cancel, churn is 5 percent and retention 95 percent. Count new customers separately, otherwise growth hides churn. Revenue churn can differ from customer churn.
A short requirement written as 'As a user, I want X so that Y', backed by acceptance criteria. Good stories follow INVEST: independent, negotiable, valuable, estimable, small and testable.
PESTEL scans the external environment across Political, Economic, Social, Technological, Environmental and Legal factors. For an electric vehicle maker in India it would cover subsidies and policy, fuel prices and interest rates, consumer attitudes, battery technology, emission targets and safety regulations. It is useful in market entry and strategy cases to spot opportunities and risks beyond the company's control, and pairs well with SWOT.
28
What are the four basic categories of elements in BPMN?
BPMN groups its shapes into four categories. Flow objects are events (circles), activities (rounded rectangles) and gateways (diamonds). Connecting objects are sequence flows, message flows and associations. Swimlanes are pools and lanes that show participants and roles. Artifacts are data objects, groups and text annotations that add context without changing the flow. Knowing these four groups lets you read almost any BPMN diagram quickly.
29
What is the difference between a sprint review and a sprint retrospective?
A sprint review is held at the end of the sprint with stakeholders to demonstrate completed work, gather feedback and adjust the backlog; it is about the product. A sprint retrospective is an internal team meeting afterwards to discuss what went well, what did not and what to improve in the way of working; it is about the process. The BA often helps demo stories in the review.
30
What do interviewers evaluate in a business case interview?
They assess how you think, not just the final answer. Key areas are clarifying the problem before solving, building a clear and MECE structure, handling numbers accurately with sanity checks, using business sense to prioritise, adapting to new information, and ending with a crisp recommendation with risks and next steps. Thinking aloud and communicating clearly matter as much as getting the right number.
31
Tell me about a time careful listening helped you uncover a hidden requirement.
Situation: during interviews for a new order system, a warehouse supervisor kept mentioning that Friday evenings were chaotic. Task: understand whether this mattered for the requirements. Action: instead of moving on, I asked what happened on Fridays and learned that bulk orders were split manually because of truck capacity limits. Result: we added an automatic order-splitting rule that nobody had listed, which saved the team about four hours a week and avoided a likely UAT failure.
32
How do you calculate the percentage contribution of each category?
Assume a population of about 144 crore and an average life expectancy of about 70 years, so roughly 2 crore people reach a typical marriage age each year. If about 95 percent of them marry at some point, that is around 1.9 crore people, or about 95 lakh weddings, since each wedding involves two people. A reasonable estimate is around 1 crore weddings per year, concentrated in the winter wedding season.
35
Write an Excel formula that lists all North region orders above 50,000 rupees.
=FILTER(Orders[[OrderID]:[Amount]],
(Orders[Region]="North") * (Orders[Amount]>50000),
"No matching orders")
# Multiplying the two conditions acts as AND.
# Use + instead of * for OR logic.
# Wrap with SORT(..., 3, -1) to sort by the third column descending.
AARRR breaks the customer lifecycle into five stages: Acquisition, how users find you; Activation, their first good experience; Retention, whether they come back; Referral, whether they recommend you; and Revenue, whether they pay. Each stage gets one or two metrics, such as sign-ups by channel, activation rate, Day-30 retention, invite rate and conversion to paid. It helps find which stage is the weakest bottleneck.
A RAID log tracks Risks, Assumptions, Issues and Dependencies for a project. Each entry has an ID, description, owner, impact, status, mitigation or action, and due date. A risk is something that may happen, an issue is something that has already happened, an assumption is believed true but unverified, and a dependency is something the project needs from others. A BA uses it to record requirement assumptions and dependencies, and reviews it weekly so nothing is silently forgotten.
39
Write a SQL query to calculate the DAU to MAU stickiness ratio for a month.
WITH daily AS (
SELECT event_date, COUNT(DISTINCT user_id) AS dau
FROM events
WHERE event_date >= '2026-10-01' AND event_date < '2026-11-01'
GROUP BY event_date
),
monthly AS (
SELECT COUNT(DISTINCT user_id) AS mau
FROM events
WHERE event_date >= '2026-10-01' AND event_date < '2026-11-01'
)
SELECT ROUND(AVG(d.dau) * 1.0 / MAX(m.mau), 3) AS stickiness
FROM daily d CROSS JOIN monthly m;
40
What is Net Promoter Score (NPS) and what are its limitations?
NPS asks customers how likely they are to recommend you on a 0 to 10 scale. Scores of 9 to 10 are promoters, 7 to 8 passives and 0 to 6 detractors. NPS equals percent promoters minus percent detractors, ranging from minus 100 to plus 100. Limitations: it is one question, sensitive to survey timing and sample bias, and does not explain why. Pair it with open-text reasons and behavioural metrics like retention.
Tips to crack the Virtusa Business Analytics interview
Revise banking and healthcare domain basics, which are important industries in Virtusa's client portfolio.
Practise coding questions and SQL queries for both the online test and technical interview.
Learn about its engineering-first positioning and be ready to describe how you approach learning new tools.
Keep a one-minute story ready for every project on your CV: problem, your part, tools, result.
Practise the hard questions on this page aloud; Virtusa interviewers usually ask follow-ups on your first answer.
Frequently asked questions
How many rounds are there in the Virtusa Business Analytics interview?
Candidates usually go through 4 stages: Online assessment (aptitude + reasoning); Coding test; Technical interview; HR round. The exact rounds change with the role, team, location and your experience, so confirm the process with the recruiter.
Which topics should I prepare for the Virtusa Business Analytics interview?
This practice set leans on Requirements and Agile (8), Case Studies and Guesstimates (7), SQL for Business Analysis (5), Product Analytics (5). Revise those first, then practise explaining one or two of your own projects end to end, because most Virtusa interviewers ask you to walk through real work.
Are these the exact questions asked at Virtusa?
No. These are curated practice questions that match the skills and difficulty usually tested in it services interviews like Virtusa's. They are not a leaked or verified list of past questions.
Where does Virtusa hire Business Analytics professionals in India?
Virtusa has large teams in Hyderabad, Chennai, Bengaluru. Openings and locations change often, so check the Virtusa careers page and filter by city and experience.
Business Analytics questions for similar companies