I applied online. The process took 1+ week. I interviewed at Advise Technologies LLC (New York, NY) in Sept 2013
Interview
The interview was very long. First there is a phone screening and then they set up the in-person interview. For the in-person interview you will meet one on one with some managers and then some of the team members. It wasn't bad. They ask about whatever you have on your resume and then they ask some technical questions on excel and sql.
Interview questions [1]
Question 1
Asked why I want to work there. Asked some technical questions.