Started with a skill test on hackerrank with about an equal number of Python questions and SQL questions. After that there were 2 phone interviews and upon completion of those I was given a take home assignment to work on and present on in-person. They usually got back to me later than promised. Finally, they told me they would let me know if the position opened up in the future. About 3 months later I started the process again with 2 more phone interviews and one final in-person interview. They were very accommodating with scheduling all the interviews, and the final in-person interview included lunch. After the whole process was over, they offered good constructive-criticism.

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.