The first step in the selection process was a HACKERRANK based coding assignment. 6 questions of varying degrees of difficulty, a couple of them being SQL based. I could perfectly code 5 of them with a partial output on one of them.
Upon selection, I had a 15 min phone screen interview with the Chief Data Scientist of the company. This interview was to get to know me more, likes, interests and a brief summary of my personal projects pertaining to DS.
After about a week:
This was an hour long technical interview, that started with asking questions on the basics of Python and SQL (mostly joins) and gradually to more difficult problems.
On getting selected, I was provided with a take-home assignment with no deadline. The test comprised of a few datasets with irregularities and some questions pertaining to the dataset (such as summation of a field based on a column, summation and grouping based off of certain selected days truncated, etc.). The dataset needed to be cleaned and pre-processed as per instructions provided. I submitted it on the very same day.
About 10 days later, I received an invite to a video interview where I was expected to neatly explain my code for the take-home assignment, mention any challenges that came in the way. I made it a point to prepare a small presentation for the same with visualizations (that worked well). The interview was conducted by two of the smartest Data-scientists in the team, they were impressed by the quality of the presentation and the lucid explanation given.
I received a call from the Chief Data Scientist on the same day, late evening to inquire about my availability for an on-site interview.
The on-site interview comprised of me meeting the team and getting to know everyone. This meeting also involved some solid technical questions put forth by the CTO and the VP of Data Science. This was followed by a lunch with the Data-science team and a final meeting with the CEO and the Cheif Data Scientist regarding salary and benefits negotiations.
The very same day, just before I boarded my flight to return home, I received a call saying I'm selected.