Karvy Fintech Product Analyst Interview: Rounds, Questions and Preparation

What the job involves

A Product Analyst at Indian unicorns and high-growth startups works with product managers, engineers, and designers to use data to inform product decisions. Day to day, this involves writing SQL queries, building dashboards, analysing user funnels, running A/B tests, and translating findings into actionable recommendations. You act as the bridge between raw data and product strategy, often in a fast-paced, ambiguous environment.

Role and Technical Knowledge

1. 1

   What are the key metrics you would track for a fintech app like a digital lending platform?

   Mention activation rate, loan application completion rate, disbursal rate, repayment rate, default rate, and customer acquisition cost. Show how each metric links to business health.

2. 2

   How would you write a SQL query to find the top 5 cities by number of active users in the last 30 days?

   Use a GROUP BY on city, filter with a WHERE clause on last_active_date, COUNT DISTINCT user_id, ORDER BY count DESC, and LIMIT 5. Explain each clause clearly.

3. 3

   Explain the difference between a funnel analysis and a cohort analysis. When would you use each?

   Funnel analysis shows drop-offs at each step of a user journey; cohort analysis tracks behaviour of groups over time. Use funnels for conversion optimisation and cohorts for retention or churn studies.

4. 4

   What is an A/B test, and how would you design one for a new onboarding flow in a high-growth startup?

   Cover hypothesis, control and treatment groups, random assignment, sample size calculation, success metric (e.g., activation rate), and duration. Mention pitfalls like peeking and novelty effects.

Practical Scenarios

1. 5

   You notice that daily active users dropped by 15% week-over-week. How would you investigate?

   Start by segmenting by platform, geography, and user cohort. Check for data pipeline issues, recent releases, and external events. Form hypotheses and validate with SQL queries before recommending fixes.

2. 6

   A product manager asks you to measure the success of a new referral program. What metrics and method would you use?

   Define success metrics like referral sign-ups, conversion rate, and cost per acquisition. Set up a control group if possible, or use pre-post analysis with a holdout. Also track viral coefficient and payback period.

3. 7

   You have to prioritise between building a dashboard for the sales team and analysing user churn for the product team. How do you decide?

   Assess impact on business goals, urgency, and effort. Use a simple framework like RICE (Reach, Impact, Confidence, Effort). Communicate trade-offs to stakeholders and suggest a phased approach.

4. 8

   How would you detect and handle outliers in a dataset of user transaction amounts for a fintech product?

   Use visual methods (box plots, scatter plots) and statistical methods (IQR, z-score). Decide whether to remove, cap, or treat them separately based on business context, such as fraud detection.

Behavioural and HR

1. 9

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

   Use the STAR method. Highlight the data you gathered, how you presented it simply, and the positive outcome. Show empathy for the other person's perspective.

2. 10

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

   Show passion for data-driven decision making and comfort with ambiguity. Mention specific aspects of the company's product or sector (e.g., fintech inclusion) and how your skills fit.

3. 11

   Describe a situation where you had to learn a new tool or skill quickly for a project.

   Pick a real example, such as learning SQL or Tableau for a college project. Explain your learning approach, the challenges, and the result. Emphasise self-motivation and resourcefulness.

4. 12

   How do you handle feedback, especially when your analysis is challenged?

   Show openness to feedback, willingness to re-examine assumptions, and focus on finding the truth. Give an example where you incorporated feedback and improved your work.

Company and Sector Awareness

1. 13

   What do you understand about the Indian fintech and high-growth startup ecosystem?

   Talk about trends like UPI, digital lending, neobanking, and regulatory changes. Mention challenges like data privacy, scalability, and customer trust. Show awareness of major players without naming specific companies.

2. 14

   How would you explain the importance of data privacy and security in a fintech product to a non-technical stakeholder?

   Use simple analogies, focus on customer trust and regulatory compliance (e.g., RBI guidelines). Explain how data breaches can harm reputation and incur penalties. Suggest practical steps like encryption and access control.

3. 15

   If you had to improve one metric for our product, what would it be and why?

   Pick a relevant metric like activation or retention. Justify its impact on revenue and user experience. Outline a hypothesis and a quick experiment you could run to test an improvement.