Curefoods Product Analyst Interview: Rounds, Questions and Preparation

What the job involves

Product Analysts at Indian unicorns and high-growth startups work at the intersection of data, product, and business. They track funnel metrics, run experiments, build dashboards, and translate user behavior into recommendations for product managers and founders. In a fast-scaling foodtech or consumer startup, you might analyze order frequency, discount impact, or kitchen-level unit economics to improve retention and margins.

Role and company knowledge

1. 1

   What does a Product Analyst do differently from a Data Analyst or a Business Analyst in a consumer startup?

   Strong answers highlight product focus: defining success metrics, running experiments, and influencing roadmap decisions, not just reporting past data.

2. 2

   Why do you want to work as a Product Analyst at a fast-growing foodtech or consumer unicorn like Curefoods?

   Connect personal interest in consumer behavior and unit economics to the company's stage, and mention specific problem areas like retention or delivery efficiency.

3. 3

   How would you measure the health of a cloud kitchen brand's product, beyond just revenue?

   Cover metrics like order frequency, repeat rate, average order value, contribution margin per order, and kitchen-level throughput or prep time.

4. 4

   What is one product metric you would track daily if you joined a food delivery or D2C food brand, and why?

   Pick a leading indicator such as daily active users placing orders or first-time-to-second-order conversion, and explain how it links to growth.

Technical and analytical skills

1. 5

   Write a SQL query to find the second highest order value per city from an orders table.

   Use a window function like DENSE_RANK or ROW_NUMBER partitioned by city, and explain how you handle ties or nulls.

2. 6

   How would you design an A/B test to check if a new discount coupon increases repeat orders without hurting margins?

   Cover hypothesis, control and treatment groups, sample size, primary metric (repeat rate), guardrail metric (contribution margin), and duration.

3. 7

   Given a table with user_id, order_date, and order_amount, how would you calculate 7-day and 30-day retention cohorts?

   Explain cohort grouping by first order month, then counting active users in subsequent periods using date differences or self-joins.

4. 8

   How do you decide between using median and average when analyzing delivery times or order values?

   Discuss skewness and outliers in operational data, and why median often better represents typical customer experience.

Practical scenarios and case questions

1. 9

   A cloud kitchen brand sees a 20 percent drop in repeat orders in one city over two weeks. How would you investigate?

   Structure the answer: check data quality, segment by user cohort, kitchen, dish, and channel, then look at external factors like competition or delivery delays.

2. 10

   You are asked to improve the conversion rate from app open to order placed. What steps would you take?

   Map the funnel, identify drop-off points, form hypotheses (menu load time, pricing, offers), and propose experiments with clear success metrics.

3. 11

   How would you estimate the total addressable market for a new healthy meal subscription in a metro city?

   Use a top-down or bottom-up approach: target population, willingness to pay, frequency, and then sanity-check with competitor benchmarks.

4. 12

   The product team wants to launch a loyalty program. What data would you pull to forecast its impact on retention and revenue?

   Look at historical repeat purchase behavior, price sensitivity, and cohort-level frequency, then model scenarios for redemption rates and incremental orders.

Behavioural and HR questions

1. 13

   Tell me about a time you used data to convince someone to change their decision.

   Use STAR format, focus on the data you analyzed, how you presented it simply, and the measurable outcome or learning.

2. 14

   Describe a project where you had to learn a new tool or skill quickly. How did you manage?

   Show self-drive and resourcefulness, mention specific resources, and connect the learning to a concrete deliverable.

3. 15

   How do you handle feedback that your analysis was wrong or incomplete?

   Demonstrate ownership, willingness to re-check assumptions, and a focus on getting to the right answer rather than being right.

4. 16

   Why should we hire you as a fresher for this Product Analyst role over other candidates?

   Combine your analytical projects, any internship or freelance data work, and your comfort with ambiguity and fast iteration.