I applied through college or university. The process took 4 weeks. I interviewed at Ripple (Toronto, ON) in Mar 2023
Interview
The interview process is supposed to be of 3 weeks for intern profile. I received an email to schedule a call with the HR as part of initial screening. The next round was technical.
Interview questions [1]
Question 1
Coderpad round - String Compression SQL query array sum to k
I applied online. The process took 2 weeks. I interviewed at Ripple in Apr 2024
Interview
1st round was very easy it's just to check if your background aligns with their job requirements.
2nd round is of more technical and highly concentrated on SQL.
They are looking for very strong SQL background
Interview questions [1]
Question 1
First round - Telephonic interview
Why Ripple?
What interests me most about blockchain?
Tell me about your work experience as a Data Engineer what ETL tools you had experience, any idea on Kubernetes, Git?
Relevant courses you are taking now?
Salary expectation
Second Round - Interview with Sr. Data Scientist
Walkthrough Resume
4 SQL queries ( concentrated on basic joins, aggregations, window functions. rank over and partition )
How to build CI/CD pipelines, what is crucial to see that pipelines do not break. why do u think data has to be partitioned?
On what variable data can be partitioned other than date variable.
Round 1 - HR
Round 2- Basic python dictionary and 2 SQL questions. Python question was about sorting data within dictionaries. SQL question was a basic join.
I did both questions but did not get to the next round.
Interview questions [1]
Question 1
Python question was about sorting data within dictionaries. SQL question was a basic join based on finding the price (cost*quantity)