Apna Product Analyst Interview: Rounds, Questions and Preparation

What the job involves

A Product Analyst at an Indian unicorn or high-growth startup spends their day pulling data from SQL databases, building dashboards to track key metrics, and running experiments to understand user behavior. They work closely with product managers, engineers, and designers to translate business questions into data-backed insights that shape product decisions. In fast-paced environments like Apna, they also help define metrics, automate reporting, and support growth initiatives.

Role and Technical Knowledge

1. 1

   How would you write a SQL query to find the top 5 cities with the highest number of job applications on a platform like Apna?

   Mention using GROUP BY on city, COUNT of applications, ORDER BY DESC, and LIMIT 5. Also discuss handling duplicates or date filters if needed.

2. 2

   What are the key metrics you would track to measure the health of a job marketplace app?

   Cover metrics like daily active users, job applications per user, job fill rate, time to hire, and retention. Explain how they connect to business goals.

3. 3

   Explain the difference between an A/B test and a multivariate test. When would you use each?

   A/B test compares two versions of one change; multivariate tests multiple changes simultaneously. Use A/B for simple changes, multivariate for optimizing combinations.

4. 4

   How would you use Excel or Google Sheets to analyze a dataset of user sign-ups by source and week?

   Describe pivot tables, VLOOKUP or INDEX-MATCH, and charts. Highlight cleaning data, calculating week-over-week growth, and identifying top sources.

Practical Scenarios

1. 5

   You notice a sudden 20% drop in daily active users on a Monday. How would you investigate?

   Start by checking data pipelines for errors, then segment by platform, geography, and user cohort. Look for external events or recent releases.

2. 6

   A product manager asks you to measure the success of a new feature that allows employers to post jobs via WhatsApp. What metrics would you define?

   Define adoption rate, jobs posted via WhatsApp, time to post, and downstream metrics like applications per job. Include a comparison with other posting methods.

3. 7

   How would you estimate the number of daily job seekers in India for a blue-collar workforce?

   Use a guesstimate approach: start with population, segment by age and employment status, then narrow to blue-collar and job-seeking. State assumptions clearly.

4. 8

   You are asked to design a dashboard for the growth team. What would you include and why?

   Focus on key growth metrics like new users, activation rate, retention, and referral traffic. Suggest filters by channel and time period for actionable insights.

Behavioural and HR

1. 9

   Why do you want to work as a Product Analyst at a high-growth startup like Apna?

   Show passion for data-driven decisions and startup culture. Connect personal interest in solving real problems for India's workforce.

2. 10

   Describe a time when you used data to solve a problem in a college project or internship.

   Use STAR method: situation, task, action, result. Highlight data collection, analysis, and impact on the outcome.

3. 11

   How do you prioritize tasks when you have multiple deadlines from different stakeholders?

   Mention assessing urgency and impact, communicating with stakeholders, and using tools like prioritization matrices. Give a concrete example.

4. 12

   Tell me about a time you received critical feedback. How did you handle it?

   Show openness to feedback, a specific action taken to improve, and the positive result. Avoid being defensive.

Case Study and Product Sense

1. 13

   Apna wants to increase the number of job applications per user. How would you approach this problem?

   Break down the funnel: awareness, interest, application. Suggest experiments like personalized job recommendations, easier apply flow, or notifications.

2. 14

   How would you decide whether to launch a new feature that allows employers to chat directly with candidates?

   Define success metrics, run a pilot A/B test, measure impact on applications and hires, and consider qualitative feedback from both sides.

3. 15

   A competitor launches a feature that reduces time to hire by 30%. How would you respond as a Product Analyst?

   Analyze competitor feature, assess impact on your metrics, propose counter-features or improvements, and prioritize based on effort and impact.

4. 16

   What is one metric you would improve for a job marketplace and how?

   Pick a metric like application-to-hire rate. Identify root causes through data, suggest product changes, and outline how you would measure success.