OneCard Technologies Product Analyst Interview: Rounds, Questions and Preparation

What the job involves

Product Analysts at Indian unicorns and high-growth startups like OneCard Technologies work at the intersection of data, product, and business. Day to day, they write SQL queries, build dashboards, analyse user funnels, run A/B tests, and translate insights into product recommendations for credit cards, payments, and lending features. They also collaborate with product managers, engineers, and designers to define metrics and track feature impact.

Role and Technical Knowledge

1. 1

   How would you calculate the monthly active users (MAU) for a credit card app like OneCard, and what SQL query would you write?

   Define active user (e.g., logged in or transacted), use COUNT DISTINCT on user_id filtered by date, and group by month. Mention handling time zones and bot traffic.

2. 2

   What is a funnel analysis, and how would you apply it to a card application journey?

   Explain steps from app download to KYC to card issuance. Build a funnel with conversion rates at each stage and identify drop-off points.

3. 3

   Explain the difference between correlation and causation with an example from fintech product data.

   Use an example like higher spending correlates with higher credit limit, but limit increase may not cause spending. Suggest A/B test to establish causation.

4. 4

   What are cohort retention curves, and how would you use them to evaluate a new rewards feature?

   Define cohorts by signup month or feature adoption. Plot retention over time. Compare cohorts exposed to rewards vs control to see if retention improves.

Practical Scenarios

1. 5

   Daily active users dropped 15% week over week. How would you investigate?

   Segment by platform, geography, user tenure, and acquisition channel. Check for data pipeline issues, app release bugs, or external events. Validate with SQL and dashboards.

2. 6

   You want to test a new cashback offer on credit card bill payments. Design an A/B test.

   Define hypothesis, randomise users, choose primary metric (bill payment rate), set sample size and duration, and plan for guardrail metrics like fraud or support tickets.

3. 7

   A product manager asks you to measure the success of a new onboarding flow. What metrics would you track?

   Track completion rate, time to complete, drop-off per step, and downstream activation (first transaction). Use SQL to compare before and after launch.

4. 8

   How would you identify and handle outliers in transaction amount data?

   Use box plots or z-scores to detect outliers. Investigate if they are fraud, test transactions, or errors. Decide whether to exclude, cap, or treat separately.

Product Sense and Business Acumen

1. 9

   How would you improve the credit card application conversion rate for a startup like OneCard?

   Map the funnel, identify friction points (document upload, KYC), propose A/B tests, and estimate impact on approval rate and revenue.

2. 10

   Estimate the number of credit card transactions per day in a city like Bengaluru.

   Break down by population, card penetration, average transactions per card per day. State assumptions clearly and sanity-check the final number.

3. 11

   What is the difference between a lagging and a leading metric? Give examples for a fintech product.

   Lagging: revenue, churn. Leading: app opens, bill payment reminders set. Explain how leading metrics predict lagging ones and help proactive decisions.

4. 12

   If you had to prioritise between reducing fraud and increasing approval rates, how would you decide?

   Weigh business impact, customer trust, regulatory risk, and data. Suggest a balanced approach with thresholds and monitoring both metrics.

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, analysis method, and measurable outcome. Show curiosity and ownership.

2. 14

   Why do you want to work as a Product Analyst in a fintech startup like OneCard?

   Connect personal interest in credit and payments, desire for fast-paced learning, and how the role blends data with product decisions.

3. 15

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

   Show empathy, use simple visuals or analogies, and focus on the actionable insight. Mention feedback received.

4. 16

   How do you handle tight deadlines when multiple stakeholders ask for data?

   Prioritise by impact and urgency, communicate trade-offs, and use templates or automated dashboards to save time. Give a concrete example.