ZS Associates Data Analyst (often titled BTSA I) interviews typically combine an online aptitude or case-based screening test with three to five rounds covering SQL, business case analysis, guesstimates, and behavioral questions.
$84K
Avg. Base Comp
$105K
Avg. Total Comp
3-5 rounds
Typical Rounds
Not reported
Process Length
ZS Associates' Data Analyst interviews, often reported under the BTSA I title, typically open with an online assessment covering aptitude and verbal reasoning, and in some processes a case-based screening test. One candidate instead started with an HR screening. From there, candidates describe three to five rounds, and SQL is the most repeated technical skill across the reports. Candidates were asked about joins, window functions, delete queries, sorting optimization, and how they structured databases in their own projects.
Beyond SQL, expect guesstimates and logic puzzles: one candidate compared a prompt to the 8 queens problem, and another described an hourglass puzzle. Expect a case study or case interview too, where you analyze a business scenario. One report described a profitability case at a food outlet, with the follow-up case interview building directly on the written analysis. Several candidates also described resume deep-dives and HR rounds with behavioral and situational questions, including direct prompts like "why should we hire you" or "why ZS." Outcomes varied: some candidates accepted offers and called the process welcoming, while others were rejected or found back-to-back, same-day scheduling exhausting. Treat each report as one candidate's path rather than a fixed script, and prepare broadly across SQL fundamentals, case reasoning, and quick mental-math puzzles.
Synthesized from 9 candidate reports by our editorial team.
Had an interview recently?
Share your experience. Unlock the full guide.
Real interview reports from people who went through the Zs Associates process.
Share your own interview experience to unlock all reports, or subscribe for full access.
Sourced from candidate reports and verified by our team.
Topics based on recent interview experiences.
Featured question at Zs Associates
What are the assumptions of linear regression?
| Question | |
|---|---|
| Late Deliveries | |
| Data Preparation for Imbalanced Data | |
| Your Strengths and Weaknesses | |
| PCA and K-Means | |
| Docs Metrics | |
| Creating Companies Table | |
| Interpreting Fraud Detection Trends | |
| 2nd Highest Salary | |
| Top Three Salaries | |
| Rolling Bank Transactions | |
| Closest SAT Scores | |
| Employee Salaries | |
| Prime to N | |
| Largest Salary by Department | |
| First Touch Attribution | |
| Experiment Validity | |
| First to Six | |
| Top 3 Users | |
| Bagging vs Boosting | |
| Raining in Seattle | |
| Find the Missing Number | |
| Size of Joins | |
| 500 Cards | |
| Over-Budget Projects | |
| Month Over Month | |
| Encoding Categorical Features | |
| Longest Streak Users | |
| Maximum Profit | |
| Paired Products |
Synthesized from candidate reports. Individual experiences may vary.
Most candidates report starting with one to three online tests covering aptitude, logical reasoning, verbal ability, and occasionally guesstimate-style questions. Some describe a dedicated case-based test in this stage, where you analyze a business scenario and write up findings before being invited to interviews. One candidate instead began with an HR screening.
Most candidates describe a technical round centered on SQL, including joins, window functions, delete queries, and sorting optimization, often tied to how you built a database in a personal project. A few reports mention lighter DSA questions, such as polymorphism, or basic Java/Python familiarity. Interviewers reportedly treat SQL as the essential skill rather than algorithmic coding depth.
Several candidates describe a case study round where you're given a business problem and asked to analyze data and present conclusions; one report mentioned a profitability case at a food outlet. In some processes, a later case interview builds directly on that same case, with interviewers asking follow-up questions about your reasoning.
Guesstimates and brainteaser-style puzzles show up across most reports, sometimes layered on top of the case or SQL rounds rather than appearing as a standalone step. Candidates mention examples like an 8-queens-style logic puzzle, an hourglass puzzle, binary number manipulation, and basic probability questions. Interviewers reportedly care more about how you talk through your reasoning than whether you land the exact number.
The later rounds typically involve a resume-focused discussion of your internships and projects, plus behavioral or situational questions such as why you want to join ZS or why they should hire you. One candidate also described a brief, more conversational segment with basic personal questions. Outcomes after this stage ranged from accepted offers to rejections.
