ThetaRay Data Engineer interview questions

The interviewer was kind . I was asked some personal questions and in the end basic / intermidiate sql questions . The questions i remember is finding duplicated rows and outputing the 3rd highest value of one of the columns

The first step was a call from the HR to discuss my past experience. After that, I was called for an onsite interview where I first got an data exploration assignment mainly using SQL and python tools. After the assignment I met 2 people form the team which discussed with me the thought process I had during solving the assignment, and than asked about my past experience. The next step on the same day was a short interview with the team lead, where we only discussed my past experience and he described the team's focus. After that I was called back for an interview with the CTO which for me felt more like a formality. The next day I talked with the CEO which let me know that I was accepted. The final step was again a discussion with the HR about the terms and contract which they offered.