Candidatei-me online. O processo levou 2 semanas. Fui entrevistado pela Avant (Chicago, IL) em mai. de 2018
Entrevista
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.
Perguntas de entrevista [1]
Pergunta 1
difference between where and having, types of joins.
Candidatei-me online. O processo levou 4 semanas. Fui entrevistado pela Avant (Chicago, IL) em fev. de 2018
Entrevista
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.
Perguntas de entrevista [1]
Pergunta 1
Difference between where and having? Difference between Inner join and outer join?
