I applied online. I interviewed at Rapido (Bengaluru) in Jun 2026
Interview
They asked one question for the F2F Coding Round.
"1. Average Session Duration
Part A – Daily Average Session Duration
You are given a log file containing all login and logout events for a single day.
Implement a program that computes the average session duration for every user.
A session starts with a logged_in event and ends with a corresponding logged_out event.
Assumptions
Every login has a matching logout.
Logs are ordered by timestamp.
A user can have multiple sessions in a day.
Example
Input
user: Tejashree | action: logged_in | time: 1736503565
user: Tejashree | action: logged_out | time: 1736507165
user: Tejashree | action: logged_in | time: 1736510765
user: Tejashree | action: logged_out | time: 1736517965
Output
User: Tejashree, Avg Session Time: 5400
Explanation:
Session 1 = 3600 seconds
Session 2 = 7200 seconds
Average = (3600 + 7200) / 2 = 5400 seconds"
This was the question asked
Interview questions [1]
Question 1
The code has to be executable, we should explain time and space complexity
I applied through a recruiter. The process took 2 weeks. I interviewed at Rapido (Bengaluru) in Mar 2026
Interview
Round 1: Coding and SQL queries -- 2 DSA questions, 2 scenario based SQL questions
Round 2: Spark and Spark Structured Streaming -- internal workings, architecture
Round 3: System Design -- Which stack you would use, which Data modelling techniques would you select