I applied through LinkedIn. They reached out to me on email and asked me complete the 3 tests on Hackerrank. Tests were Python (Beginner), Problem Solving (Beginner and Intermediate). After passing the test, they ghosted me for a month and after that they reached out regarding the rest of the procedure. An interview was scheduled and I was asked SQL Scripting questions. I did great in oral questions but did terrible in writing code. Later on they asked me to have an interview next day with the President of the company. Interview with him was quite easy, he asked basic database, oop and data science questions. Due to my terrible performance in coding they ask me to appear in another interview. That interview included problem solving questions and sql scripts. I did better this time and 2 days after they reached out to me saying that I have passed the test.