J'ai postulé via un établissement d'enseignement supérieur ou universitaire. Le processus a pris 3 mois. J'ai passé un entretien chez Zillow (Seattle, WA) en nov. 2018
Entretien
I reached out to one of the data scientists at Zillow during an information session at my university. I gave her my resume and mentioned how passionate I am about the Zillow and their business models. Because as being a person having a real-estate background and now pursuing my career in data science I closely follow the company and its research division.
After 3 days I got a mail for an on-site interview in Boston which was far one of my greatest experience I ever had. The interviewer was highly professional and kinda person you can see yourself working for.
After that round, I got a take-home assessment test which I had to complete within a week. It was fairly simple if you know how to code and overall familiar with Zillow's business models.
After my submission, I got invited for an on-site interview at their Seattle office. The entire interview was of 4 around 2-2.5 hours with 4 managers from different teams. The overall experience was great but I would say it was kind of not what I expected it to be. It was confusing and I did not get the chance to make a connection with the first 2 of the manager because of the room in which had to give my interview was booked another team and then I had to wait for 20 minutes in order to find another available room. Thus, my first round was of only 5-7 minutes.
Overall, one of a lifetime experience with one of the most innovative and greatest company. However, I wished things during my last on-site interview could have gone in the desired manner. Zillow has always been the kind of company I always wanted to work.
The overall process took 2+ months with a rejection.
J'ai postulé en ligne. Le processus a pris 3 semaines. J'ai passé un entretien chez Zillow (New York, NY) en juil. 2024
Entretien
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.
J'ai postulé en ligne. J'ai passé un entretien chez Zillow en juil. 2023
Entretien
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.
Questions d'entretien [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.
J'ai postulé via un recruteur. Le processus a pris 3 semaines. J'ai passé un entretien chez Zillow (Miami, FL) en mai 2022
Entretien
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.
Questions d'entretien [1]
Question 1
Common behavioral questions and technical questions.
