SQL test was given as first step and a coding challenge was sent. The emphasis of the process was to understand the knowledge level of the candidate. It was an open ended challenge and required some interesting brain storming to complete it.