Ho presentato la mia candidatura online. La procedura ha richiesto 2 settimane. Ho sostenuto un colloquio presso Avant (Chicago, IL) nel mese di mag 2018
Colloquio
Got an email from hr to set up a phone screen. However, didn't get a call on the specified day; had to email the hr and they rescheduled the interview due to some urgent work that came up. Phone screen was with Analytics Manager. Basic SQL questions and questions based on analytics projects in Resume.
Domande di colloquio [1]
Domanda 1
difference between where and having, types of joins.
Ho presentato la mia candidatura online. La procedura ha richiesto 4 settimane. Ho sostenuto un colloquio presso Avant (Chicago, IL) nel mese di feb 2018
Colloquio
The first round was a phone screen which included very basic sql and python questions, followed by a Data Challenge which was comparatively tough and interesting to solve. After clearing that I was called for an onsite interview.
Domande di colloquio [1]
Domanda 1
Difference between where and having? Difference between Inner join and outer join?