I applied online. The process took 3 weeks. I interviewed at Urban Science (Detroit, MI) in July 2013
Interview
First was HR interview which was standard. Then a team of 2 people, a senior consultant and a manager. Asked basic situational and background questions. Next was Account Executive, asked more challenging questions. Last was hiring manager, asked me to write TSQL queries on the spot among other technical questions.
Interview questions [1]
Question 1
How many Ford trucks were sold in the US last year?