Fi Money Data Analyst Interview: Rounds, Questions and Preparation

What the job involves

As a Data Analyst at an Indian unicorn or high-growth startup like Fi Money, you will work with product, growth, and risk teams to extract insights from user and transactional data. Day to day involves writing SQL queries, building dashboards, analyzing funnel metrics, and presenting actionable recommendations to drive business decisions. You will also collaborate with data engineers and product managers to define metrics and track experiments.

Role & Technical Knowledge

1. 1

   How would you write a SQL query to find the second highest transaction amount per user from a transactions table?

   Use a window function like ROW_NUMBER() or DENSE_RANK() partitioned by user_id and ordered by amount descending, then filter for rank 2. Mention handling ties and NULLs.

2. 2

   What is a cohort analysis and how would you use it to measure user retention for a fintech app?

   Define cohorts based on sign-up month, track retention over time (e.g., monthly active users), and visualize with a heatmap. Explain how it helps identify churn patterns and product improvements.

3. 3

   Explain the difference between a LEFT JOIN and an INNER JOIN. Give an example where each is useful in a fintech context.

   LEFT JOIN keeps all rows from the left table (e.g., all users, even those without transactions), while INNER JOIN only returns matching rows (e.g., users with at least one transaction). Provide clear examples.

4. 4

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

   Discuss methods like IQR, z-scores, or box plots. Explain whether to remove, cap, or transform outliers based on business context (e.g., fraudulent transactions should not be removed).

Practical Scenarios

1. 5

   You notice a sudden 20% drop in daily active users for a mobile banking app. How would you investigate?

   Break down by platform, version, geography, and user segments. Check for app updates, server issues, or external events. Use funnel analysis to pinpoint where drop-off occurs.

2. 6

   The product team wants to launch a new feature that offers cashback on bill payments. How would you design an A/B test to measure its impact?

   Define control and treatment groups, primary metric (e.g., bill payment frequency), secondary metrics (e.g., retention), sample size, duration, and significance level. Mention potential pitfalls like novelty effect.

3. 7

   You are asked to create a dashboard for the growth team to track user acquisition. What metrics would you include and why?

   Include CAC, conversion rate by channel, sign-up to first transaction rate, and payback period. Explain how each metric informs acquisition strategy and budget allocation.

4. 8

   A stakeholder claims that users who use the app more frequently have higher credit scores. How would you validate this?

   Clarify correlation vs causation. Suggest analyzing the relationship with scatter plots and correlation coefficients, then control for confounders like income or age. Recommend a longitudinal study if needed.

Behavioural & HR

1. 9

   Tell me about a time you used data to solve a problem. What was your approach and what did you learn?

   Use STAR format: describe the situation, your data-driven action, and the measurable outcome. Highlight tools used and any insights that led to a decision.

2. 10

   Why do you want to work as a data analyst at a high-growth fintech startup like Fi Money?

   Show passion for fintech and data-driven decision making. Mention specific aspects like fast-paced environment, ownership, and impact on millions of users. Avoid generic answers.

3. 11

   Describe a time you had to explain a complex data insight to a non-technical audience. How did you ensure they understood?

   Emphasize simplifying jargon, using visualizations, and focusing on the 'so what'. Mention checking for understanding and tailoring the message to the audience's goals.

4. 12

   How do you prioritize multiple data requests from different teams?

   Discuss assessing impact, urgency, and effort. Mention communicating with stakeholders to align on deadlines and using a prioritization framework like RICE or Eisenhower matrix.

SQL & Coding Deep Dive

1. 13

   Write a SQL query to calculate the month-over-month growth rate of new users.

   Use a subquery or CTE to count new users per month, then use LAG() window function to get previous month's count and compute percentage change. Handle division by zero.

2. 14

   Given a table of user sessions with start and end timestamps, how would you find the average session duration per user?

   Calculate duration as end_time - start_time, then group by user_id and average. Mention handling overlapping sessions or outliers.

3. 15

   How would you use Python pandas to merge two dataframes and handle missing values?

   Use pd.merge() with appropriate how parameter (inner, left, etc.), then use fillna(), dropna(), or interpolation based on context. Explain trade-offs.

4. 16

   What are window functions in SQL? Give an example of using RANK() to identify top customers.

   Explain that window functions perform calculations across a set of rows related to the current row. Show RANK() OVER (PARTITION BY region ORDER BY total_spend DESC) to rank customers within each region.