Ripple Interview Questions

Ripple Interview Guides

Click or hover over a slice to explore questions for that topic.
Data Structures & Algorithms
(117)
SQL
(86)
Machine Learning
(83)
Product Sense & Metrics
(36)
Probability
(34)

Ripple Interview Questions

Practice for the Ripple interview with these recently asked interview questions.

QuestionTopicDifficulty
SQL
Medium

Given a table of transactions and products, write a query to get the month_over_month change in revenue for the year 2019. Make sure to round month_over_month to 2 decimal places.

Note: Return month_over_month as a fraction of the previous month’s revenue (0.04, not 4), and NULL for the first month since it has no prior month.

Example:

Input:

transactions table

Column Type
id INTEGER
user_id INTEGER
created_at DATETIME
product_id INTEGER
quantity INTEGER

products table

Column Type
id INTEGER
name VARCHAR
price FLOAT

Output:

Column Type
month INTEGER
month_over_month FLOAT
SQL
Hard
Data Structures & Algorithms
Easy
Loading pricing options

View all Rippling questions

Challenge

Check your skills...
How prepared are you for working at Rippling?

Ripple Salaries by Position

Product Manager*
$225K
Product Manager
Median: $225K
Mean (Average): $225K
Data points: 1
$50K
$241K
Software Engineer
Median: $159K
Mean (Average): $157K
Data points: 60
Data Analyst*
$62K
Data Analyst
Median: $62K
Mean (Average): $62K
Data points: 1

Most data science positions fall under different position titles depending on the actual role.

From the graph we can see that on average the Product Manager role pays the most with a $225,000 base salary while the Data Analyst role on average pays the least with a $62,000 base salary.

Discussion & Interview Experiences

?
There are no comments yet. Start the conversation by leaving a comment.