Stellapps Product Analyst Interview: Rounds, Questions and Preparation

What the job involves

Product Analysts at Indian unicorns and high-growth startups like Stellapps work at the intersection of data, product, and business. They define and track product metrics, run experiments, and translate user behaviour into actionable insights for product and engineering teams. Day to day involves SQL, dashboards, cohort analysis, and working closely with product managers on feature launches.

Role and technical knowledge

1. 1

   How would you measure the success of a new feature for a dairy-tech startup like Stellapps that helps farmers track milk quality?

   Define a north star metric (e.g., daily active farmers, quality alerts acted upon), then supporting metrics like retention, adoption rate, and time to first value. Mention baseline and target.

2. 2

   Explain the difference between a funnel analysis and a cohort analysis. Give an example from an Indian e-commerce or fintech app.

   Funnel shows step-by-step drop-off in a single journey (e.g., cart to payment). Cohort groups users by signup month to track retention over time. Use a concrete Indian app example.

3. 3

   Write a SQL query to find the top 5 cities by number of active users in the last 30 days from a table with user_id, city, and last_active_date.

   Use WHERE last_active_date >= DATE_SUB(CURRENT_DATE, INTERVAL 30 DAY), GROUP BY city, ORDER BY COUNT(DISTINCT user_id) DESC LIMIT 5.

4. 4

   What is a p-value in A/B testing? How would you explain it to a non-technical product manager?

   Say it is the probability of seeing the result if there were no real difference. A low p-value (under 0.05) suggests the change likely had an effect, not due to chance.

Practical scenarios

1. 5

   Daily active users of a Stellapps-like farmer app dropped 15% week over week. How would you investigate?

   Check data pipeline issues first, then segment by geography, device, app version, and user cohort. Look for recent releases, seasonal farming cycles, or competitor actions. Propose a fix and monitor.

2. 6

   You are asked to design an A/B test for a new onboarding flow. What steps will you take before launching?

   Define hypothesis, primary and guardrail metrics, sample size, randomisation unit, and duration. Ensure no seasonality or novelty effect. Get stakeholder buy-in.

3. 7

   A product manager wants to add a new dashboard for milk collection centres. How do you decide what metrics to include?

   Start from the user goal (e.g., reduce spoilage, improve payment speed). Choose 3-5 actionable metrics, avoid vanity metrics, and validate with centre managers.

4. 8

   You notice that users who complete profile setup have 3x higher retention. How would you use this insight?

   Suggest experiments to nudge profile completion (e.g., progress bar, incentives). Track lift in retention and watch for unintended drop in signup completion.

Product sense and business context

1. 9

   How would you prioritise features for a B2B dairy startup that has limited engineering resources?

   Use a framework like RICE (Reach, Impact, Confidence, Effort). Align with business goals (revenue, retention). Consider dependencies and quick wins.

2. 10

   What is unit economics? Why does it matter for an Indian unicorn like Stellapps?

   Unit economics is revenue and cost per unit (e.g., per farmer, per litre). It matters because startups need sustainable growth, not just user growth. Mention CAC, LTV, payback period.

3. 11

   If you could track only three metrics for a new payments feature in a fintech app, what would they be and why?

   Choose activation rate (first transaction), success rate (completed vs failed), and repeat usage (transactions per user per month). Explain why each drives business value.

4. 12

   How would you assess whether a new referral program is working for a hyperlocal delivery startup?

   Track referral sends, conversion to first order, cost per acquired user, and retention of referred users vs organic. Compare against baseline and watch for fraud.

Behavioural and HR questions

1. 13

   Tell me about a time you used data to solve a problem in a college project or internship.

   Use STAR format. Highlight the data source, your analysis method, the insight, and the outcome. Quantify impact if possible.

2. 14

   Why do you want to work as a Product Analyst at a high-growth startup instead of a large MNC?

   Show comfort with ambiguity, ownership, and fast learning. Mention desire to see direct impact of your work on product decisions.

3. 15

   Describe a situation where you had to explain a technical concept to a non-technical person.

   Pick a real example. Emphasise simplifying without losing accuracy, using analogies, and checking for understanding.

4. 16

   Where do you see yourself in three years? How does this role fit into that plan?

   Show a path toward product management or senior analytics. Link it to gaining deep user and business understanding at a startup like Stellapps.