I was contacted by a recruited who scheduled me for a technical interview. The recruiter were very nice and informative but I do need to say that the recruiter my not be fully informed about technical interview. I would advise future candidate to study as much as possible about SQL and little bit about Python and algorithm before the interview.
The interview includes 2 technical exercises:
- 2 SQL questions about joining table
- Simple Python exercise: return count of distinct values in array
And a lot of questions which I listed below. The interviewer was very nice and she even explain to me some of the question where I got wrong.
One thing I do need to say is that the recruiter will ghost you if you fail this interview. So if you don’t hear back from them, you know their answer
Me postulé en línea. El proceso tomó 2 semanas. Acudí a una entrevista en Antra (Denver, CO) en jul 2022
Entrevista
Applied online with your resume
phone screening with HR, and they tell you what you are gonna do next
OA (easy level, Python coding problem, just sharing screen)
tech video call with one of the tech trainers
then two weeks training with a final evaluation.
Preguntas de entrevista [1]
Pregunta 1
Python:
define dictionary and if a key not in the dictionary what is the output
lambda function/ why use it/ vs normal function
error handling
list vs tuple
SQL:
primary key/ necessary?
left/inner join (A, B)
many-to-many relationship
junction table
a view vs a table
find the emp_id with the highest/11th highest salary