Applied through their recruitment website. Overall process was fast.
Received a call from HR a few days later and HR scheduled an interview for me with one of their data scientist on the following week. Didnt receive any confirmation email after phone call. Received a email few days later and noticed the interview date was pushed forward.
Interview was done over SKYPE. 1 hour duration and 3 SQL question were provided through Collabedit. An SQL dump of a database was provided and I had to prepared 3 SQL DML statement to query the database.
For the first question, had to return bookings received by a driver on a specific date. Managed to answer the question but interviewer rather focus on minute details such as date conversion mistake in the WHERE clause.
Come on, a test database was not provided and a console to the test the query was not provided and they expect me to get a 100% correct syntax? The main idea to compare the date was provided in the WHERE clause and that should more then enough to demonstrate "know how".
For the second question, test was focused on GROUP BY, HAVING clause. Completed in with minor mistake.
For the third question, had to prepare a SQL statement that list drivers with a day on day decrease in completed rides. Gave up on this question as I didnt know how to compare total rides of each day with the previous day, previous day with the day before and so on, like an infinite loop.
But when the solution was shown, turns out all I had to prepare was a list of drivers whose rides were lesser then the day before, i.e using a hardcoded date.
None the less, no excuse for not knowing and last minute preparation. A few days after the interview, received an email stating that I didnt pass the interview. Wrote back a lengthy email to them stating how much I really want to work for them and how much I knew about the organization despite not working for them. Didn't receive any reply. But its really their lost.