I applied online. The process took 5 weeks. I interviewed at Zillow (Seattle, WA) in Oct 2016
Interview
1. Phone screen with a recruiter (within a week after my application)
2. Technical Phone interview (Took about 2 weeks from the phone screen)
3. Onsite interview (Took about two more weeks). This process was about 5 hours. Meeting individuals from different groups.
They paid for the flight/ accommodation etc since I had to fly from a different state.
Interviewers were good and knowledgeable.
Interview process a good experience. But I think they were favoring on how they would have designed or solved a problem (basically their approach). My thought is that they can't expect candidate to give the exact same solution without having the same level of inputs, system knowledge, exposure, and TIME. :)
Interview questions [1]
Question 1
some were puzzles... Many of them were database related questions - technical, design, or problem solving..
I applied online. I interviewed at Zillow (Seattle, WA) in Oct 2016
Interview
The hiring process included three interview phases: initial phone screen, baseline product knowledge assessment over the phone, and a five hour in-person interview loop.
The initial phone screen went well. The recruiter was very energetic and did a great job of explaining the aspects of the position, as well as the overall company culture. My info was forwarded to another team member to coordinate the remainder of my interviews with staff at Zillow.
The second interview was a general product knowledge assessment over the phone. The bulk of the interview process was spent answering questions related to data types, built-in functions, and problem solving/query design. The interview lasted about 20 to 30 minutes. At the end of the interview, the interviewer pointed out a few areas of suggested improvement, which was very much appreciated. He then sent my information back to the coordinator to move on to the final phase of the process.
The final interview was in-person at the Seattle office. The interview lasted five hours, which included a working lunch with the hiring manager. I met with five individuals over the course of the five hour interview loop, and the questions varied in form and complexity. There were situational questions, data modeling design/questions, requests to design queries based on the data models created, query optimization suggestions, and debugging/tuning best practices. All of the modeling and query design was performed on a whiteboard as the problems were stated by the interviewer.
The lead recruiter met with me at the end of the interview loop and went over the details of the position one last time, and was told she would be in touch with me within two or three days. I was contacted by her with an offer within 36 hours of the in-person interview, and I formally accepted the position the following day.
I’ve graded the interview process as “difficult” given the breadth of topics covered during both the baseline product knowledge phone screen and the five hour in-person interview.
Interview questions [1]
Question 1
The questions asked were contextual to the problems presented.
I applied online. The process took 2 weeks. I interviewed at Zillow in Jul 2015
Interview
Applied for the position online and I got a call from the recruiter within 1 week, she was very nice and gathered all the relevant information about my job experience at my current position. After the call, I got an email from another recruiter from zillow who scheduled a 45 minute phone interview with the hiring manager next week along with a link to a website that lets the interviewer see the candidate code along with call. I prepared for the technical screening and waited for the call from hiring manager. First of all i got a call from a completely different person and he was very casual and was driving back from his vacation. His calls kept dropping between the interview and all questions related to coding were asked on the fly. In the end he was very arrogant about 2 questions that i coudn't get right and he didnt let me respond to him at all. Overall, very bad experience with the technical interview, i was really excited about interviewing for zillow but..
Interview questions [1]
Question 1
Left Right Inner Joins, ISNULL vs COALESCE, DELETE vs Truncate, some scenario based questions that were supposed to be presented on code share