Infogain Business Analytics Interview Questions & Answers
Curated interview practice questions with answers. These are practice scenarios, not a verified list of past interview questions.
About Infogain hiring for Business Analytics roles
Infogain is a digital engineering and IT services company serving clients in technology, travel, retail, insurance and healthcare. It offers software engineering, cloud, data and analytics, experience design and customer engagement solutions. It is part of the Apax Funds portfolio and has large delivery centres in India, where it hires developers, testers, data engineers and cloud specialists for global client projects.
For Business Analytics roles, this Infogain practice set focuses most on Excel for Business Analysts (7), SQL for Business Analysis (6), Stakeholder Communication (5), Case Studies and Guesstimates (5). It has 18 easy, 22 medium questions, so you can start easy and work up to the harder ones.
Company type
IT services
Headquarters
California, USA
Main India offices
Noida, Gurugram, Pune, Bengaluru
Infogain Business Analytics interview process
Online assessment (aptitude + technical MCQs)
Technical interview
Client or managerial round
HR round
Typical pattern based on public candidate experiences. Rounds vary by role, team and year.
Solved for InfogainStart 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 is a power-interest grid and how do you use it?
A power-interest grid maps stakeholders by how much influence they have over the project and how interested or affected they are. High power and high interest: manage closely with regular involvement. High power, low interest: keep satisfied with concise updates. Low power, high interest: keep informed, for example end users. Low power, low interest: monitor. It helps a BA decide who to consult, how often and in what format.
02
What is a KPI and give examples for an e-commerce business?
ARPU, Average Revenue Per User, is total revenue in a period divided by the average number of users in that period. If a telecom-style app earns 50 lakh in a month from 25,000 average users, ARPU is 200 rupees. It is tracked to see whether growth comes from more users or more value per user. ARPPU, revenue per paying user, is used when only some users pay.
04
Write an Excel formula to count the number of unique customers in a column.
// Excel 365
=COUNTA(UNIQUE(A2:A500))
// unique customers in the North region only
=COUNTA(UNIQUE(FILTER(A2:A500, B2:B500="North")))
// older versions (no blanks in range)
=SUMPRODUCT(1/COUNTIF(A2:A500, A2:A500))
05
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.
06
What does GROUP BY do and how is HAVING different from WHERE?
Severity describes the impact of a defect on the system or business, such as critical when payments fail or low for a spelling mistake. Priority describes how urgently it must be fixed, which is a business decision. They can differ: a wrong company logo on the login page is low severity but high priority before a launch, while a crash in a rarely used year-end report may be high severity but lower priority if the report is months away.
11
How would you build a simple financial model in Excel?
Situation: my manager asked why customer complaints were rising, but complaints were stored as free text with no categories. Task: give an answer within a week. Action: I sampled 300 complaints, created categories, tagged them manually and used keyword rules in Excel to classify the rest, then validated with the support lead. Result: late refunds were 40 percent of complaints, the refund process was fixed, and categorised tagging was added to the support tool.
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.
17
What are the steps to publish and share a Power BI report with your team?
Save the .pbix and click Publish, choosing the team workspace. In the Service, set data source credentials and, for on-premises data, configure the gateway. Schedule refresh. Then share by giving workspace access to editors, or package it as an app for viewers, and apply row-level security roles if needed. Finally, check it on web and mobile and send the link with a short note on what each page answers.
18
You receive two customer lists from sales and billing and must reconcile them. How do you do it?
Standardise both first: trim spaces, fix case, convert IDs to the same type and remove duplicates. Use a unique key like customer ID, or a combined key of phone and email if IDs differ. Then use XLOOKUP or COUNTIFS to mark each record as matched, only in sales or only in billing, or a Power Query merge with anti joins. Summarise mismatches by type and share the exception list with both owners.
A UAT test plan defines how acceptance testing will be run. It covers scope and out-of-scope items, business processes to be tested, entry and exit criteria, roles such as testers, UAT lead and sign-off authority, test environment and test data, schedule and cycles, defect management process with severity definitions, communication and reporting, and risks. The BA usually drafts it with business owners so testers know exactly what they are accepting and when.
20
How do you adapt your communication for executives versus technical teams?
Executives want outcomes, impact, risk and decisions needed, in a one-page summary or a few slides with clear numbers. Technical teams need precise details: data fields, business rules, edge cases, acceptance criteria and dependencies. Operations users need process steps and what changes in their daily work. Same facts, different depth and vocabulary. Ask each group how they prefer to receive updates and adjust.
Decide whether and how to enter a market by evaluating attractiveness, competition, capabilities and entry mode (build, buy, partner), then risks and next steps.
22
What is an impact-effort matrix and how do you use it to prioritise recommendations in a case?
An impact-effort matrix is a 2x2 grid that plots options by expected business impact against effort, cost or time. High impact and low effort are quick wins to do first; high impact and high effort are major projects to plan; low impact and low effort are fill-ins; low impact and high effort should be dropped. In a case interview, it helps you end with a clear, prioritised recommendation rather than a long list of ideas.
23
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.
EBITDA is earnings before interest, taxes, depreciation and amortisation. It approximates operating profit generated by the core business before financing choices, tax rules and non-cash accounting charges. It is useful for comparing companies with different debt levels or asset ages and is used in valuation multiples such as EV/EBITDA. Its weakness is that it ignores capital expenditure and working capital needs, so a company can show strong EBITDA and still burn cash.
25
Write non-functional requirements for an online payment page.
NFR-01 Performance: the payment page loads within 2 seconds for 95 percent of requests at 500 concurrent users. NFR-02 Availability: 99.9 percent monthly uptime outside planned maintenance. NFR-03 Security: card data is never stored by the application, and all traffic uses TLS 1.2 or higher. NFR-04 Compliance: the flow meets PCI DSS and RBI payment guidelines. NFR-05 Usability: works on mobile screens from 360 pixels wide. NFR-06 Audit: every transaction attempt is logged with a timestamp.
26
What are functional and non-functional requirements?
Functional requirements describe what the system does (login, reports); non-functional ones describe how well it does it (speed, security, availability, usability).
27
Write a SQL query to find the second-highest salary in an employees table.
SELECT MAX(salary) AS second_highest
FROM employees
WHERE salary < (SELECT MAX(salary) FROM employees);
-- or with a window function
SELECT DISTINCT salary FROM (
SELECT salary, DENSE_RANK() OVER (ORDER BY salary DESC) AS rk
FROM employees
) t WHERE rk = 2;
Both stack the results of two queries with the same number and type of columns. UNION removes duplicate rows, which needs a sort or hash step and is slower. UNION ALL keeps every row and is faster. Use UNION ALL when combining data such as online and store sales where duplicates are genuine or impossible, and UNION only when you specifically need a distinct list, such as unique customer IDs from two sources.
Start with the main conclusion or recommendation, then give the two or three supporting reasons, and only then the detailed data. Senior stakeholders have little time, so a summary like 'Churn rose because of payment failures; fixing retries can save 4 lakh a month' should come first. Detail goes in the appendix. It is the opposite of a chronological walk through every step of the analysis.
32
What is user story mapping and how does it help plan releases?
User story mapping arranges stories in two dimensions. Across the top is the user journey as a sequence of activities, for example search, compare, buy and track. Below each activity, stories are stacked by priority. Drawing horizontal lines across the map creates release slices, where the first slice is a thin end-to-end MVP that covers every step at a basic level. It prevents a flat backlog where teams build one area deeply while the journey stays incomplete.
33
What is feature adoption rate and how do you measure it?
Feature adoption rate is the share of eligible active users who used a feature in a period. For example, if 4,000 of 20,000 monthly active users used saved searches, adoption is 20 percent. Measure it against eligible users only, track first use and repeat use separately, and compare retention of adopters versus non-adopters. High first use with low repeat use often means the feature is discoverable but not valuable.
34
Write a SQL query to calculate the repeat purchase rate.
WITH per_customer AS (
SELECT customer_id, COUNT(DISTINCT order_id) AS orders
FROM orders
GROUP BY customer_id
)
SELECT
ROUND(100.0 * SUM(CASE WHEN orders >= 2 THEN 1 ELSE 0 END)
/ COUNT(*), 2) AS repeat_rate_pct
FROM per_customer;
Link your answer to real experience. For example: during my internship I noticed reports were rebuilt manually every week, so I mapped the process and automated it with Power Query, saving the team a day each week. I enjoyed understanding the problem, talking to users and seeing the result used. A BA role combines that problem solving, communication and data work, which is where my strengths are, and I want to build deeper domain knowledge.
36
How do you calculate cycle time, touch time and process efficiency? Give an example.
Cycle time (lead time) is the total elapsed time from the start to the end of a case. Touch time is the time someone actually works on it. Process cycle efficiency is touch time divided by cycle time. Example: a refund takes 5 working days (40 working hours) end to end, but the agents spend only 2 hours in total working on it. Efficiency is 2 / 40 = 5 percent, so 95 percent of the time is waiting, and queues are the main target.
37
What is the difference between SQL and Excel for analysis?
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.
39
What does expectation management mean for a business analyst?
It means making sure stakeholders know realistically what will be delivered, when, and with what limits, before they form their own assumptions. A BA confirms scope in writing, states assumptions and dependencies, shares estimates with ranges, and flags risks early. When something changes, they update stakeholders immediately with options. Most stakeholder conflict comes from surprises, not from bad news itself.
A UML diagram showing actors and the actions (use cases) they perform with the system, giving a quick view of scope.
Tips to crack the Infogain Business Analytics interview
Revise one programming language, SQL and REST API basics, and be ready to solve a simple coding problem live.
Prepare examples of working in a team, handling deadlines and communicating clearly, since many projects involve direct client interaction.
Read about Infogain's focus on digital engineering and the industries it serves to answer why you want to join.
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; Infogain interviewers usually ask follow-ups on your first answer.
Frequently asked questions
How many rounds are there in the Infogain Business Analytics interview?
Candidates usually go through 4 stages: Online assessment (aptitude + technical MCQs); Technical interview; Client or managerial round; 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 Infogain Business Analytics interview?
This practice set leans on Excel for Business Analysts (7), SQL for Business Analysis (6), Stakeholder Communication (5), Case Studies and Guesstimates (5). Revise those first, then practise explaining one or two of your own projects end to end, because most Infogain interviewers ask you to walk through real work.
Are these the exact questions asked at Infogain?
No. These are curated practice questions that match the skills and difficulty usually tested in it services interviews like Infogain's. They are not a leaked or verified list of past questions.
Where does Infogain hire Business Analytics professionals in India?
Infogain has large teams in Noida, Gurugram, Pune, Bengaluru. Openings and locations change often, so check the Infogain careers page and filter by city and experience.
Business Analytics questions for similar companies