Ho presentato la mia candidatura online. Ho sostenuto un colloquio presso Snowflake nel mese di feb 2023
Colloquio
The technical interview lasts for 200 minutes with 2 questions - a SQL and a DS-related question. The first one is not that hard - maybe in medium level. The second one definitely takes most of your time
Domande di colloquio [1]
Domanda 1
The second one asks you to build a model on jupyter notebook.
Hadn't expected the first round to feature a question so similar to one I had just studied on PracHub. The challenge was to design an A/B test for query latency, diving deep into unit analysis and variance reduction. Unfortunately, the interviewer seemed rushed and interrupted frequently, which made it hard to fully express my thoughts. The experimental design follow-ups felt particularly chaotic. Overall, the process left me feeling disconnected, and I walked away without an offer, despite having prepared thoroughly.
Recruiter call, followed by a discussion with the hiring manager. They didn't go past the hiring manager stage with me, but the next step would have been a technical panel
Domande di colloquio [1]
Domanda 1
Given tables of managers and reports, generate the number of reports in a director's organization.