I applied through a recruiter. The process took 4 weeks. I interviewed at EY (London, England) in Jul 2014
Interview
There were three interviews. First was telephone screening interview with 3 detailed technical questions.
The second was onsite with a manager. It was a very technical interview using whiteboard to demonstrate SQL skills and also doing a test in front of the manager about software in general, algorithms, development, and regular expressions. If you have CS background, it is a very easy test. Also, they would go through the answers with you and discuss them helping you to answer correctly.
Third interview is with directors, business and technical. The latter gave a case study on how to apply advanced data analytics techniques on a problem within a fraud suspicion case in financial services. The other would ask typical competency questions and your motivation to join the team.
Interview questions [1]
Question 1
In SQL when you do a join with another table where column value can be NULL, what would be the outcome of join in respect to NULL values.