The first round was very easy; it's just to check if your background aligns with their job requirements.

The second round is more technical and highly concentrated on SQL.

They are looking for a very strong SQL background.

First Round - Telephonic Interview

• Why Ripple?
• What interests you most about blockchain?
• Tell me about your work experience as a Data Engineer. What ETL tools have you used? Do you have any experience with Kubernetes or Git?
• What relevant courses are you taking now?
• Salary expectation.

Second Round - Interview with Sr. Data Scientist

• Walk through your resume.
• Four SQL queries (concentrated on basic joins, aggregations, window functions, RANK() OVER(), and PARTITION BY).
• How would you build CI/CD pipelines? What is crucial to ensure pipelines do not break?
• Why do you think data has to be partitioned?
• On what variables can data be partitioned, other than a date variable?