Ho presentato la mia candidatura tramite l'università. La procedura ha richiesto 4 settimane. Ho sostenuto un colloquio presso Ripple (Toronto, ON) nel mese di mar 2023
Colloquio
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.
Domande di colloquio [1]
Domanda 1
Coderpad round - String Compression SQL query array sum to k
Ho presentato la mia candidatura online. La procedura ha richiesto 2 settimane. Ho sostenuto un colloquio presso Ripple nel mese di apr 2024
Colloquio
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
Domande di colloquio [1]
Domanda 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.
Domande di colloquio [1]
Domanda 1
Python question was about sorting data within dictionaries. SQL question was a basic join based on finding the price (cost*quantity)