I applied online. The process took 4 weeks. I interviewed at CERN (Geneva) in Mar 2017
Interview
* online test
* video interview (recording your answers of written questions, bit weird but practical I guess)
* on place interview - it was whole day, rather exhausting, but overall interesting experience. Take a watch with you since in my room there was no clock and during the case study written test, you are not allowed to have a phone with you. What I found redundant is the apart of the case study questions, there were other small things that they could have included in the online test.
Interview questions [1]
Question 1
To write more advanced SQL DB statement, for which you have to train well your SQL knowledge (don't rely only on your daily work - it won't be sufficient). There was a task to implement data structure in Java (from what I remember was BlockingQueue), for which I didn't have the time and a bunch of small other easy java related questions.