Dunzo logo
DunzoProduct Analyst
Updated · Reviewed by the Dataford team

Dunzo Product Analyst interview questions & guide 2026

Every question Dunzo interviewers actually ask, the frameworks that win the room, and the language hiring managers respond to.

2 rounds · ≈ 2-4 weeks
1
Technical Screening
2
Case Studies

1. What is a Product Analyst at Dunzo?

As a Product Analyst at Dunzo, you operate at the intersection of data science, business strategy, and product development. You are the critical link that translates raw operational data into actionable insights, helping teams optimize everything from delivery logistics to customer acquisition. Your work directly influences how Dunzo scales its hyperlocal services, ensuring the platform remains efficient, reliable, and user-centric.

This role is inherently fast-paced and high-impact. You will work closely with the growth, brand, and supply teams to solve real-world challenges, such as identifying new market growth categories or optimizing invoice processing. Because Dunzo operates in a complex, real-time ecosystem, your ability to extract meaningful patterns from large datasets is what allows the business to make data-driven decisions that impact thousands of daily transactions.

2. Common Interview Questions

The questions below represent the patterns observed in the Dunzo hiring process. While your specific experience may vary based on the team you are joining, you should prepare for a mix of technical rigor and strategic thinking.

Technical and SQL Proficiency

Expect to demonstrate your ability to manipulate complex datasets. The focus is on writing efficient queries to solve real business problems.

  • How do you handle NULL values when calculating price line items across multiple joined tables?
  • Explain the practical differences between LEFT JOIN and RIGHT JOIN, particularly regarding how they handle duplicate records.
Preparing for a niche company?

Access the full Product Analyst prep plan

  • Every Product Analyst question, updated weekly
  • Model answers with SQL and coding solutions
  • Recent, real interview reports
Get my prep plan
03 · Question bank

The questions most likely to come up

Sorted by relevance to this company
Using Window Functions in SQLMedium
Explain how window functions calculate across related rows without collapsing detail, enabling ranking, running totals, and comparisons.
Window Functionscalculationsdatabase querying
Designing an A/B Test for Feature ImpactMedium
Design an A/B test for a new platform feature, including success metrics, power, guardrails, and a clear ship decision.
experiment designfeature evaluationA/B Testing
Access the full Product Analyst prep plan
Everything you need to walk in ready.
Get my prep plan

3. Getting Ready for Your Interviews

Preparation for Dunzo requires a balance of "hard" technical skills and "soft" business acumen. You should view your interviewers as future colleagues who are looking for someone who can not only write a query but also explain the "why" behind the data.

Technical Competency – You must be comfortable with advanced SQL and data manipulation. Interviewers will assess your ability to write clean, performant code that handles edge cases like NULL values or complex joins.

Analytical Problem-Solving – You will be evaluated on your ability to structure ambiguous problems. When faced with a case study, focus on creating a clear framework, defining your assumptions, and explaining your methodology before diving into the solution.

Business Intuition – Dunzo values candidates who understand the hyperlocal delivery ecosystem. Demonstrate that you can connect your analytical output to business outcomes like growth, supply-chain efficiency, or customer retention.

4. Interview Process Overview

The hiring process at Dunzo is designed to evaluate both your technical depth and your ability to navigate real-world business scenarios. Depending on the seniority of the role, you may face a process that ranges from a single, focused round to a more comprehensive five-round series. The common thread across all stages is a focus on high-utility skills—specifically, how you use data to solve the operational problems that keep the company running.

You should expect the process to be rigorous, focusing heavily on SQL mastery, logical problem-solving, and your ability to communicate complex findings to non-technical stakeholders. The interviewers are looking for evidence that you can hit the ground running and contribute to team goals immediately.

06 · The loop

The interview process, end to end

≈ 2-4 weeks · 2 rounds
1
Technical Screening

Initial evaluation of technical skills, particularly in SQL and problem-solving.

2
Case Studies

Deep-dive into business scenarios to assess practical application of data analysis.

This visual timeline highlights the progression from technical screening to deep-dive case studies. Use this to pace your preparation, ensuring you dedicate enough time to both coding practice and business-case frameworks.

5. Deep Dive into Evaluation Areas

SQL and Data Manipulation

This is the foundational skill for the role. You are expected to be fluent in writing complex queries that join multiple tables and perform window calculations.

  • Key Focus: Joins, aggregation, and window functions.
  • Strong Performance: Writing code that is not just correct, but optimized for readability and efficiency.
  • Example: "Given these four related tables, write a query that identifies the top 10 customers by spend excluding specific categories."
Preparing for a niche company?

Access the full Product Analyst prep plan

  • Every Product Analyst question, updated weekly
  • Model answers with SQL and coding solutions
  • Recent, real interview reports
Get my prep plan
08 · Topic breakdown

What they actually test for

Topic distribution
All topics
SQLCase Study AnalysisMySQLWindow FunctionsPARTITION BY Clause

6. Key Responsibilities

As a Product Analyst, you will be embedded within cross-functional squads, working closely with Product Managers, Engineers, and Business Operations. Your primary responsibility is to provide the data backbone for their decision-making.

  • You will translate business requirements into SQL queries to track product performance, user behavior, and delivery metrics.
  • You will drive the analysis of new product features, determining whether they are meeting adoption targets and identifying areas for iteration.
  • You will participate in regular "deep-dive" sessions where you present findings to leadership, translating complex datasets into clear, actionable business recommendations.

7. Role Requirements & Qualifications

A competitive candidate for the Product Analyst position at Dunzo brings a mix of strong technical skills and a proactive, problem-solving mindset.

  • Technical Skills: Expert-level SQL is non-negotiable. Proficiency in data visualization tools (like Tableau or Looker) and basic statistical modeling is highly expected.
  • Experience: Most successful candidates have a background in data-heavy roles, often with experience supporting growth or operations teams in a fast-paced environment.
  • Soft Skills: You must be an excellent communicator. You will often have to explain technical findings to people who may not be data-fluent, so clarity and brevity are essential.

8. Frequently Asked Questions

Q: How difficult are the technical rounds? A: The technical rounds are generally considered to be of average to high difficulty. They focus on practical, real-world SQL applications rather than obscure theoretical problems.

Q: What is the best way to prepare for the case studies? A: Focus on building frameworks. Practice identifying the "North Star" metric for a business problem and then brainstorming the secondary metrics that influence it.

Q: How long does the process take? A: The process can vary from a single round to five, depending on the role level. Generally, you can expect a decision within a few weeks of your final interview.

Q: Is there a specific focus for the behavioral rounds? A: Dunzo looks for candidates who are comfortable with ambiguity and thrive in a fast-changing environment. Be ready to discuss times you handled a fast-moving project or managed conflicting priorities.

9. Other General Tips

  • Structure your thoughts: In case study rounds, always state your assumptions clearly before you start building your logic.
  • Be vocal: During the puzzle and coding rounds, speak your thoughts out loud. Interviewers care as much about your process as they do about your final answer.
  • Know the product: Use the Dunzo app, understand its delivery model, and be prepared to discuss how you would improve its efficiency from an analytical perspective.
  • Ask clarifying questions: If a case study prompt seems vague, take a moment to ask questions to narrow the scope. This shows you are a thoughtful, analytical thinker.

10. Summary & Next Steps

The Product Analyst role at Dunzo is a high-visibility position that puts you at the heart of one of India's most dynamic hyperlocal platforms. By mastering your SQL fundamentals, practicing structured case study frameworks, and demonstrating a clear understanding of the business, you will be well-positioned to succeed.

Candidates can explore additional interview insights, practice questions, and preparation resources on Dataford. Remember that your ability to communicate your analytical process is just as important as the accuracy of your results. Stay confident, be methodical, and focus on the impact your data can have on the business.

The compensation data provided above reflects typical ranges for this role. Candidates should interpret these figures as a starting point, noting that total compensation often includes base salary, performance bonuses, and other benefits commensurate with seniority and local market standards.

16 · FAQ

Dunzo Product Analyst interview FAQ

Answered from real candidate and compensation data
How many rounds is the Dunzo Product Analyst interview process?
Candidates report 2 stages: Technical Screening and Case Studies. The interview process section above breaks down what each stage covers.
What topics come up in the Dunzo Product Analyst interview?
Dunzo Product Analyst interviews most often cover SQL, Case Study Analysis, MySQL, Window Functions, and PARTITION BY Clause, based on topics extracted from real candidate reports.
What questions does Dunzo ask Product Analyst candidates?
Recent candidates report questions like "Using Window Functions in SQL" and "Designing an A/B Test for Feature Impact". The question bank above tracks 20 questions for this role, ranked by how often they come up in Dunzo interviews.