Zillow Data Scientist interview questions

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.

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.