Ho presentato la mia candidatura tramite un selezionatore. La procedura ha richiesto 4 settimane. Ho sostenuto un colloquio presso Zillow nel mese di gen 2019
Colloquio
A recruiter reached out. We had a pleasant conversation about Zillow and she forwarded me to the hiring manager. It took a few weeks to schedule the second interview although I was quick to respond. The hiring manager was rude, impatient, and sounded incredibly uninterested in speaking with me. I was not unhappy when I heard nothing back afterwards, but it's disrespectful to candidates to not update them on the status of their application.
Ho presentato la mia candidatura online. La procedura ha richiesto 3 settimane. Ho sostenuto un colloquio presso Zillow (New York, NY) nel mese di lug 2024
Colloquio
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.
Ho presentato la mia candidatura online. Ho sostenuto un colloquio presso Zillow nel mese di lug 2023
Colloquio
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.
Domande di colloquio [1]
Domanda 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.
Ho presentato la mia candidatura tramite un selezionatore. La procedura ha richiesto 3 settimane. Ho sostenuto un colloquio presso Zillow (Miami, FL) nel mese di mag 2022
Colloquio
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.
Domande di colloquio [1]
Domanda 1
Common behavioral questions and technical questions.