Talked to Capital IQ recruiter coming to career fair on my college and I dropped off my resume. Later I was invited to the in person interview held in my college. I was pretty surprised when I walked in and got 5-6 pages of coding/database questions, which I had to write down the answers just like a CS class midterm. I didn't finish it and in the end the recruiter went over all the questions with me.

After that first interview, I was invited to the final interview in the New York office. Talked to a few developers and overall the process went well and smoothly.

The questions are basic coding and database. There is nothing really difficult if you prepared well.