I applied through university. I interviewed at Urban Science (Herndon, VA) in Feb 2014
Interview
Met the HRs at a career fair. Got an email within 1 week from Urban Science for a campus interview on Feb 21, 2014.
The interviewers were friendly. It was a fun interview.
Interview questions [1]
Question 1
Nothing out of the box. Questions asked -
1. What do you know about this company?
2. Tell me about yourself?
3. Did you ever have a conflict with one of your teammates? How did you resolve it?
4. What are the different clauses in sql ? (Eg. where, in , not in, exists etc.)
5. Difference between left and right outer join?
6. What are the steps you follow for SQL Optimization? Can you give me an example where you have optimized a query? (I had sql optimization on my resume)
THey did not ask me any puzzle or fermi question(how many cars were sold in the US etc.).
I have another on site round scheduled for later this week.
I applied online. I interviewed at Urban Science (Long Beach, CA) in Aug 2016
Interview
This was the best interview experience I have had. Everyone I spoke to was extremely welcoming and knowledgeable, especially Laura, the recruiter. I applied for the position on LinkedIn, then she reached out to me and I had a few phone calls with her about the position and the company. She was very friendly but also very professional. I asked her a lot of questions and she gave me great insight into what the position would entail, what skills are needed, the company's history, etc. I did not live in the area so she accommodated me by allowing my interviews to be on the phone and through Skype. I interviewed with the recruiter, the team I would be working for, and then completed a short logic test. The whole process was very organized and only took a few weeks from start to finish. Laura also sent me some information about Long Beach and some resources for SQL, which I really appreciated. I ended up being offered a position and accepted, in part due to the great interview experience I had.
Interview questions [1]
Question 1
Are you familiar with SQL? Where do you see yourself in 5 years? What skills do you have that you think will help you in this role? What are your interests?
I applied online. The process took 2 days. I interviewed at Urban Science
Interview
I applied through internet and got a voice message after 3 or 4 weeks to make an appointment for phone screen, and I called back to make an appointment, but a HR person asked me all the questions right away. I wasn't really prepared, and I just got out from a gym, so the phone screen didn't go well.
