The Razorpay Data Analyst Interview Guide
Razorpay (based in Bangalore) is the premier B2B FinTech company in India. They provide the payment infrastructure for millions of businesses. As a Data Analyst here, your "customer" is another business (a merchant), which completely shifts how you approach data analysis compared to a B2C company.
The Interview Stages
Razorpay's process is highly technical and places a premium on communication, as Analysts often interact directly with product managers and sometimes large enterprise clients.
- Take-Home Assignment: A complex dataset requiring Python/SQL and a summary presentation.
- Technical Deep Dive: Defending your assignment and live SQL coding.
- Business/Product Case Study: Optimizing B2B metrics.
- Values Round: Assessing fit with Razorpay's core cultural pillars.
Round 1 & 2: Technical Mastery (SQL + Python)
Razorpay expects clean, scalable code.
- SQL Question: "Write a query to calculate the MoM (Month-over-Month) retention rate of merchants based on their transaction volume."
- Python Focus: You might be asked to explain how you handled outliers in the take-home dataset using Pandas. Did you use standard deviation, IQR, or domain logic?
Round 3: The B2B Product Case Study
This round tests your understanding of the payment gateway business.
- The Scenario: "A large enterprise merchant (e.g., Swiggy) is complaining that their checkout conversion rate on Razorpay has dropped by 3%. Walk me through your investigation."
- The Approach:
- Analyze API response times (Latency).
- Break down success rates by payment methods (Cards vs. Netbanking vs. UPI).
- Check downtime of specific acquiring banks.
- Look for changes in the merchant's UI that might be causing user drop-offs before hitting Razorpay's servers.
Round 4: Risk and Compliance Analytics
B2B FinTech requires strict merchant monitoring.
- Question: "Design a dashboard for the Risk Team to monitor newly onboarded merchants for potential money laundering."
- Focus: What metrics matter? Velocity of transactions, average ticket size vs. industry average, and the ratio of international vs. domestic cards used.
Round 5: Behavioral (The "Transparency" Round)
Razorpay heavily values transparency and extreme ownership.
- "Tell me about a time you made a significant analytical error that impacted a business decision. How did you communicate it, and how did you fix it?"
- "Describe a situation where you had to learn a completely new technical tool over a weekend to deliver a project."
Final Advice: Familiarize yourself with standard B2B SaaS metrics (MRR, Churn, CAC) as well as Payment metrics (TTV - Total Transaction Volume, Take Rate, Authorization Rate). Using this vocabulary naturally during the interview will score you massive points.
