ZS Associates BTSA interview: process, rounds and questions

Written by Mentari as typical of this process — not a record of questions ZS Associates has asked. Each comes with the follow-up a good interviewer asks next and what they listen for in the answer. Scenario details are our framing, chosen to fit ZS Associates’s sector.

1. 01 Pick a project on your résumé that stored data. Sketch its tables for me and tell me which query ran most often.

   Follow-up · That query now runs over fifty million rows and takes four minutes. What do you look at first, and what would you deliberately leave alone?

   Listens for · Knows their own schema without hedging; goes to the join and filter columns and the execution plan before "more hardware"; can say what an index costs on writes.

2. 02 Write a query that returns each customer’s second-most-recent order.

   Follow-up · Two orders share the same timestamp. What does your query return now, and is that acceptable?

   Listens for · Chooses a window function or a correlated subquery deliberately, and notices the tie case before being told.

3. 03 Estimate the number of insulin pens sold in Pune in a month.

   Follow-up · You assumed every diagnosed diabetic uses insulin. I think that is badly off — which way, and how do you fix it without starting again?

   Listens for · States a structure before any number; treats the challenge as input and repairs one branch instead of defending or restarting.

Compiled from 6 candidate reports (2024–2026) and the official hiring page. Where reports differ, the range is shown rather than one number.

Aptitude assessment — two reported versions — Reports describe two formats: 59 questions in 52 minutes across six sections, or roughly 50–60 questions in 75 minutes across four or five sections. Which one a campus gets appears to depend on the drive and the assessment vendor; sectional timers mean speed, not difficulty, is what eliminates.^9,5,6

1. Practise sectioned aptitude tests against a timer per section, not per test. The reported eliminator is the sectional clock — fourteen minutes for two unstructured problems, five minutes for twenty-five attention-to-detail items.
2. Be able to write and explain two SQL queries with joins and aggregation, out loud. SQL appears in the online test (two queries to write) and again in the interview, where it is the part candidates rate hardest.
3. Record yourself answering a prompt for ninety seconds; listen back. The communication assessment is recorded, impromptu and timed, and is the stage candidates most often say they underestimated.
4. Prepare one guesstimate and one puzzle, and rehearse having an assumption challenged. Both are reported in the interview; ZS’s own page says it assesses how you "apply feedback".
5. Know the second layer of every project on your résumé — your part, the numbers, what broke. Reports describe the interview opening with the résumé and staying there until the detail runs out.
6. Read what BTSA actually does. The role sits between consultants and engineers; a "why BTSA and not a developer role" answer that fits that is reported as a standard question.

What ZS Associates says it assesses

• How you structure problems, develop solutions, apply feedback and think creatively (case interviews)¹
• Fit for the role, assessed through behavioural interviews¹
• "Performance, leadership and problem-solving skills" — "critical thinkers with curiosity, creativity and an entrepreneurial drive"²
• Logical, quantitative and qualitative reasoning, plus big-data concepts such as cloud platforms, data management, analytics and coding languages (online assessment)¹

What candidates report being probed on

• SQL written and explained aloud — joins, grouping, window logic; rated medium-hard in interviews^4,6
• Every project line on the résumé, including the parts you did not personally build^4,6
• Guesstimates and puzzles, with the interviewer challenging one assumption^4,6,7
• Situational and "build a business" questions testing comfort with ambiguity⁴

ZS is a consulting firm that hires engineers, and the BTSA process shows it. The three online stages are pure filters — several reports describe funnels where most of the campus is eliminated before anyone speaks to a human — and the aptitude round eliminates on speed rather than difficulty, because each section carries its own timer and the unstructured-problem-solving section gives two questions fourteen minutes. Students who prepare for a standard aptitude test and meet sectional timers for the first time in the real thing are the ones who report being surprised.

The interview that follows is unusually mixed for an analytics role. Within one 30-to-60-minute conversation candidates report a SQL question answered aloud, a guesstimate, a puzzle and a business-situation question, then HR questions — the firm is checking that the person who passed a SQL test can also reason in front of a client. Reports also single out the communication assessment: a recorded speaking test is rare in engineering campus drives, and candidates from non-English-medium backgrounds describe it as the stage they wished they had practised.

Where the sources disagree

The official page and the candidate reports do not contradict each other so much as count differently. ZS says candidates "can expect two to four rounds of interviews"; students describe four or five stages, because they count the online assessments. On the assessment itself the reports disagree: one widely circulated pattern is 59 questions in 52 minutes across six sections, another is around 50 to 60 questions in 75 minutes across four or five; both are third-party compilations, and ZS's own page describes only the areas covered. Eligibility is the clearest case of campus variation — the same 70% / 7.0 CGPA figure appears in most places, yet a 2024 report describes a drive that admitted students with backlogs. Interview length is the widest range of all, from about twenty minutes to over an hour, which suggests the number of interviewers and their interest in the résumé matter more than a fixed format.

4. 04 You had to choose BTSA over a pure software role on the form. Why this one, and what would you be worse at in the other?

   Follow-up · Your résumé has three machine-learning projects and no SQL. Why should I believe this is where you want to be in two years?

   Listens for · A reason tied to the day-to-day of the role — client problems, data, delivery — and an honest weakness, not "both interest me".

5. 05 A pharma client’s sales-rep dashboard shows a 20% drop in calls logged last month. What do you check before you tell anyone?

   Follow-up · It turns out a software update changed how a call is counted. What do you say to the client, who has already seen the number?

   Listens for · Separates a data-pipeline cause from a real-world cause; communicates a correction plainly rather than burying it.

6. 06 Explain the difference between an inner join and a left join using the data in your own project.

   Follow-up · Tell me about a time the wrong join silently changed a number you reported.

   Listens for · Applies the concept to real tables; owns a mistake and names the check that now prevents it.

7. 07 Tell me about a time you were given an unclear problem and had to decide what it actually was.

   Follow-up · Who disagreed with your framing, and what did you do with their objection?

   Listens for · A specific situation, a stated assumption, and evidence of changing course on feedback — the three things ZS’s own page says it looks for.

8. 08 Here is a puzzle: you have eight identical-looking balls, one heavier, and a balance scale. Minimum weighings?

   Follow-up · Now you do not know whether the odd ball is heavier or lighter. How does your approach change?

   Listens for · Reasons aloud, generalises the method, and stays calm when the constraint changes.

9. 09 If we asked you to build a small business around college canteens, what would you build and how would you know in a month whether it was working?

   Follow-up · Your metric went up but the canteen owners are unhappy. What did you miss?

   Listens for · Picks one user and one metric, and recognises that a metric can move while the thing it stands for gets worse.

10. 10 What do you know about what ZS does for its clients?

    Follow-up · Name one problem a BTSA would plausibly work on in their first six months.

    Listens for · More than "consulting and analytics": life-sciences commercial work, data and technology delivery, and a concrete guess at a first project.

Estimate how many insulin pens are sold in Pune in a month.

Weak · Starts multiplying immediately: "Pune has about 70 lakh people, say 10% diabetic, so 7 lakh, each buys… maybe 4 pens a month, so 28 lakh." Defends the 10% when asked.

Stronger · Writes the formula first — population × diagnosed diabetics × share on insulin × pens per person per month — states each assumption with a reason, computes aloud, and ends with the weakest input: "the share on insulin is my shakiest number; most type-2 patients are on tablets, so this could be a third of what I said."

Why the follow-up lands · The interviewer then says "you assumed every diabetic uses insulin — I think that is badly off." The strong candidate repairs one branch and recomputes; the weak one restarts or argues. ZS’s own page names "apply feedback" as something it assesses.

Illustrative — yours must be true.

For a cell, the ZS BTSA drive is three online filters before any interview, so most of the cohort’s outcome is decided by test-taking under sectional timers and a recorded speaking assessment — two things a placement cell can rehearse at scale weeks in advance. Reported eligibility varies by campus, so the figure in your own invitation is the one that counts.

Mentari’s mock interviews cover the part that follows the filters — SQL explained aloud, a guesstimate with pushback, the résumé deep-dive — and show the cell who is ready for it. Run ZS Associates-pattern mocks for a whole batch.

• Data analyst mock interview
• Business analyst mock interview
• Consulting mock interview
• Tiger Analytics interview
• EXL interview
• Fractal Analytics interview
• Guesstimate Questions: Method + Worked Example
• STAR Method Answers That Survive Follow-ups
• All company guides →

1. Interview process — ZS Associates (official) · official · accessed 2026-10-23 · lists behavioural, case and subject-matter interviews and an online assessment; "may vary by role and location"
2. Recent graduates — ZS Associates (official) · official · accessed 2026-10-23
3. Business Technology Solutions Associate — job description — ZS Associates careers (official) · official · accessed 2026-10-23 · qualifications used for the eligibility row
4. ZS Associates interview experience, BTSA on-campus 2024 — GeeksforGeeks · candidate report, 2024-09 · accessed 2026-10-23
5. ZS Associates interview experience for BTSA — GeeksforGeeks · candidate report, 2024-10 · accessed 2026-10-23
6. ZS Associates interview experience for BTSA (on-campus, internship + FTE) — GeeksforGeeks · candidate report, 2025-07 · accessed 2026-10-23
7. ZS BTSA interview experience — 6-month internship + FTE — Medium (candidate) · candidate report, 2026-01 · accessed 2026-10-23 · summary-level account
8. Experience at ZS Associates — BTSA via Campus Beats Tech Challenge — The Interview Room · candidate report, 2025-10 · accessed 2026-10-23
9. ZS Associates syllabus and test pattern — placementpreparation.io · candidate report · accessed 2026-10-23 · preparation-site compilation of reported patterns; section counts approximate

Verified October 2026 by Sumit Mishra, Mentari founder. Spotted an error, or represent ZS Associates? Write to [email protected] — we acknowledge within two working days and correct or remove a disputed statement within 72 hours.

Mentari is not affiliated with ZS Associates. This page is pattern-based, compiled from the public sources listed, and is not insider information. Candidate-reported details are reproduced as patterns only, in our own words.