I was told there are two rounds of technical interviews followed by a client interview and culminating in a HR round. The first round is an online test where they ask you to browse to a URL and appear for a test. I got 10 MCQs and 13 questions needing me to write small code snippets on MS SQL. Once you submit the test, there’s a panel of analysts in South Africa (as I was told) who evaluate (I don’t know if they actually run the codes or just have a look at them to see if they’re correct). Once you’re through this, you need to appear for the next rounds.
As mentioned above, I’m not sure about their evaluation process because I am pretty sure atleast 10 of my 13 code snippets were correct because I ensured I ran them on my personal SQL Server instance by creating similar data objects. However, I was told my score was ‘not close to what is expected’!