Practo Business Analyst interview questions & guide 2026

The following questions are representative of the patterns observed in recent Practo interview cycles. Use these to gauge the depth of technical and logical reasoning required.

SQL and Data Handling

These questions test your ability to manipulate datasets, handle joins, and aggregate data efficiently.

• Write a query to find the top 3 doctors in each specialty based on booking count.
• How would you handle null values in a join? Explain the difference between LEFT, RIGHT, and INNER JOIN.

Preparation should focus on bridging the gap between raw technical skill and business application. Do not just practice coding; practice explaining the "why" behind your code.

Technical Proficiency – You must be fluent in SQL and Python. Interviewers look for clean, error-free code and an understanding of how to optimize queries for performance.

Structured Problem Solving – When faced with a case study, use a framework to organize your thoughts. Start by clarifying the objective, breaking down the problem into smaller components, and then proposing data-driven solutions.

Business Acumen – Understand the Practo ecosystem. Be ready to discuss how healthcare marketplaces function, the importance of conversion metrics, and how data influences product roadmaps.

The interview process at Practo is designed to be efficient, focusing heavily on your practical skills and your ability to think on your feet. You can expect a mix of technical screening, deep-dive problem-solving, and managerial interviews. The culture is collaborative, and the interviewers generally aim to make candidates feel comfortable so they can perform at their best.

This timeline illustrates the progression from initial technical screening to final managerial decision-making. You should interpret this as a filter-based funnel where technical rigor is high in the beginning, shifting toward strategic thinking and cultural alignment in the final rounds.

Technical Rigor (SQL/Python)

You will be evaluated on your ability to write efficient code under pressure. Strong performance means you don't just solve the problem, but you also consider edge cases and code readability.

Be ready to go over:

• SQL Joins, window functions, and subqueries.
• Python data manipulation libraries (Pandas, NumPy).
• Basic algorithmic logic (arrays, loops, complexity).

Example scenarios:

• "Optimize this SQL query for a table with millions of rows."
• "Clean this dataset using Python; identify and handle outliers."

Analytical Thinking

This evaluates how you approach ambiguity. You are expected to ask clarifying questions before jumping into a solution.

Be ready to go over:

• Root cause analysis methodologies.
• KPI definition and tracking.
• Trade-off analysis (e.g., speed vs. accuracy in a model).

Example scenarios:

• "How would you define 'active user' for our platform?"
• "Analyze a dip in daily active users."

As a Business Analyst, you will be the bridge between the technical team and business stakeholders. Your day-to-day will involve querying databases to pull performance reports, creating dashboards to visualize trends, and proactively identifying areas where the business is leaking value.

You will frequently collaborate with product managers to define success metrics for new features. This means you must be able to translate technical constraints into business language and vice versa. You are expected to be an owner of your data, ensuring that the insights you provide are not just accurate, but also actionable.

A strong candidate for this role possesses a blend of analytical grit and communication skills.

Must-have skills:

• Advanced SQL (joins, window functions, aggregations).
• Proficiency in Python for data analysis.
• Ability to communicate complex data findings to non-technical stakeholders.
• Strong aptitude for logical reasoning and statistics.

Nice-to-have skills:

• Experience with visualization tools like Tableau or Power BI.
• Prior experience in a marketplace or healthcare-tech domain.
• Knowledge of A/B testing methodologies.

Q: How long should I prepare for the interview? A: Depending on your current proficiency, 2–4 weeks of focused practice on SQL and case studies is typically sufficient to feel confident.

Q: What is the most common reason for rejection? A: Lack of structured thinking in the case study round and failing to explain the thought process behind the code. Always talk while you solve.

Q: Is the interview process mostly remote? A: Yes, most interview stages are conducted virtually, though you should verify the specific format with your recruiter.

Q: Does Practo test for statistics? A: Yes, particularly in the later rounds, you may be asked to apply probability or statistics to business scenarios.

• Think Aloud: Your interviewer is more interested in your problem-solving logic than the final number. Narrate your steps clearly.
• Clarify Assumptions: If a question seems ambiguous, ask for clarification. This demonstrates maturity and professional rigor.
• Master the Basics: Don't get lost in complex algorithms; ensure your foundational knowledge of SQL clauses and Python syntax is error-free.
• Know the Product: Spend time using the Practo app and website. Understanding the user experience will make your business suggestions much more credible.

The Business Analyst role at Practo is a challenging yet rewarding position that offers a front-row seat to the transformation of the healthcare industry. By focusing on mastering your technical fundamentals, practicing structured problem-solving, and developing a deep understanding of the Practo business model, you can position yourself as a top-tier candidate.

Your ability to synthesize data and communicate it effectively is what will set you apart. Approach each interview round as a collaborative consultation rather than a test. With focused preparation and a clear, analytical mindset, you are well-equipped to succeed in this process. You can find more detailed case study frameworks and technical challenges on Dataford to further refine your preparation. Good luck.

The provided compensation data reflects industry standards for this role in the current market. Use this to set your expectations for salary negotiations, keeping in mind that total compensation may include performance bonuses or equity depending on your level.