Me postulé a través de un reclutador. El proceso tomó 2 meses. Acudí a una entrevista en Skyscanner (Edimburgo, Escocia) en sept 2010
Entrevista
Initial phone interview for around 40 minutes -- bit of background and some simple SQL SERVER specific questions -- easy to weed out people who truly don't know much. Then a face to face with two interviewers -- with one of the founders; which was pretty tough, getting indepth and writing code (with paper and pen!). Finally a 3rd interview with Head of Engineering and a colleague just to get a personal feel
Preguntas de entrevista [1]
Pregunta 1
Code an any level recursive search algorithm in sql that traverses routes specified in a multi million row table. Bonus points if your query actually performs adequately (and runs in n log(n)) time.