I applied online. The process took 3 weeks. I interviewed at Zillow (New York, NY) in Jul 2024
Interview
Overall experience was good. The technical interview was difficult. The interviewer as nice and professional. The process took 3 weeks in total. Starting with a screening interview, technical interview with the hiring manager followed by behavioral interview.
I applied online. I interviewed at Zillow in Jul 2023
Interview
1) Recruiter Screener 2) Technical Screener 3) 4 - Panel Interviews I got cut at the technical screener. Overall interview experience was 2/5, probably the worst I've experienced, but the company looks great so obviously something you'll have to "get over". In the Recruiter Screener I was told that the first round I would be screened on my SQL skills, I asked which version of SQL I should 'code in', they told me whatever I'm comfortable. So my interview I used functions from SAS SQL as that's what I use normally. The technically screener had not seen the SAS SQL functions before and was unfamiliar with them (Outer Union Corr, 'ne', where <> functions includes nulls, etc.). In addition to this there were a few instances where the interviewer thought the function didn't work not realizing that the edge case he's mentioning didn't apply or was accounted for. Nobody's perfect, this will always happen but all combined it made for an uncomfortable experience. HAVING SAID THAT, I was still moderately worse at SQL than the interviewer and even had he known the SAS SQL functions, I would have failed the technical screener. I made a lot of stupid mistakes looking back and not making it to the next round is no fault but my own. The Technical Screener wasn't the reason this experience was awful. At the end of the interview, the interviewer did not inform me of what the next steps were or when I'd expect a response (probably because he knew I would be cut). I reached out the the recruiter the following day asking "when can I expect a timeline for the next steps" to which they ignored. I sent another follow up email two days later again wanting to know when I'd expect a timeline which they then again ignored until 3 days later. Between the recruiter ignoring me for some time and incorrectly being told I could code however I want, the entire experience was 2/5, very awful.
Interview questions [1]
Question 1
1.1) Given 2 data sets, write me a query that combines the datasets but excludes customers who are in both 1.2) Is there another way you can do that query? 2) Table 1 has userID and State, Table 2 has UserID, saved home, Date of saving home. Write me a query that tells me what percent of users in a state have saved a home 3) Table 1 has UserID and open Date, Table 2 has User ID, saved home, and date of saving home. Write me a function that tells me the average time it takes between a user makes an account and saves a home. 4) (Theory Question) If an executive asks you why our average saved homes droped YoY, how would you investigate the issue.
I applied through a recruiter. The process took 3 weeks. I interviewed at Zillow (Miami, FL) in May 2022
Interview
Zillow's interview experience is definitely the best experience I have ever had. I applied for the job through a recruiter, the entire process took around 2~3 weeks. Recruiters are extremely responsible and helpful: they provide useful resources and suggestions on interview preparations. During the interviews, I could tell that interviewers are welcoming and inclusive. I even was pleasantly surprised after the interview -- I received a digital postcard from ZG. From the process, I feel interviewees are truly cared.
Interview questions [1]
Question 1
Common behavioral questions and technical questions.
