They will do an over-the-phone interview, then an in-person, then another in-person interview. The over-the-phone is to see if you could manage, the 1st in person is a logic and reasoning interview, 2nd in person is a personality interview to see how you would fit as a person at the company.

Applied for the job via the careers section of the Clearwater Analytics website, for a job based in their Edinburgh office. Submitted my CV with no cover letter. After a day or so I received an e-mail inviting me to take part in an online, self-timed numeracy/problem solving test via "Surveymonkey". The content was straightforward. Subsequent e-mail from recruiter based in Boise, ID to arrange a telephone interview. Interviewed for roughly 30 minutes with the recruiter who had e-mailed, mainly covered CV and relevant experience, a couple of quick maths questions (I guess to catch out anyone who had used a calculator etc for online test) and a couple of basic finance questions (this was not a finance specific role). After this stage, a face to face panel interview with three members of staff, one of whom was normally based in Boise. This interview involved me talking through my CV and general experience and a bit about my other interests. A few questions about what I enjoy at work and dealing with co-worker conflicts. Then on to maths/problem solving questions on the whiteboard. The questions varied in difficulty and complexity, some took a minute to answer and others were 10-15 minutes. I found one of these particularly abstract and struggled to answer it, but the guys were keen to talk through the problems and focused upon the working method which alleviated any awkward silences at the very least. Finally a question about my SQL experience. This role was not specifically related to database design or SQL however I had mentioned some prior experience so I guess they decided to check if I actually knew anything about this. A question about setting up a SQL database of films and actors and writing a query to produce a list of actors in a certain film. Felt I managed this OK on the hop, but hadn't written an SQL query for nigh on a year so a little rusty on setting up the JOIN conditions in the FROM statement. Overall, the guys who interviewed me were very pleasant. I felt I had not performed as well as I could have with the problem solving and that this likely would result in a rejection. I heard within a week that I would not have a further interview or receive an offer. Still a good experience. I would say that you could probably find a list of all questions they may ask in the problem solving interview and prepare the answers in advance, however I think the nature of the interview probably reflects the day to day work and you may find yourself quickly under pressure if you do not perform well in this environment.