Me postulé en línea. Acudí a una entrevista en Instacart (San Francisco, CA) en jun 2016
Entrevista
I had a conversation with a hiring manager then received a data engineering challenge. The challenge consisted of two tasks: data modeling and programming. For data modeling I provided a designed schema in pdf files (facts, dimensions, relationships), description of designed tables and columns, ddls and sqls for metric calculations. For programming task I provided Python script, input and output files and two wrappers to run the Python script in Linux and Windows. After couple of days I received an email with the rejection if a form of standard explanation to proceed with other candidates. It's more than a year had passed since then and recently I found out that they put a permanent hiring ban on me. It's really weird that a company puts such permanent ban for just the engineering challenge.
Me postulé en línea. Acudí a una entrevista en Instacart
Entrevista
It started from an invitation to complete 6 questions on CodeSignal and took about 1.5 hour to complete. The topics include data schema, dbt, warehouse optimization, and SQL. SQL is at medium level.
Acudí a una entrevista en Instacart (San Francisco, CA)
Solicitud
Acudí a una entrevista en Instacart (Toronto, ON)
Entrevista
Step 1) Call with technical recruiter for details about role and compensation
Step 2) Technical assessment advanced SQL question and advanced python
Step 3) Data Modeling about marketplace experience, 2 steps
Preguntas de entrevista [1]
Pregunta 1
They asked me an SQL question about delivering orders on time.
In general, I have a great experience during the interview process interacting with talented people.
- 1 hour online challenge - SQL queries
- 30 min phone call with the recruiter
- 12 Hour online challenge- Data processing
- 30 min call with hiring manager
- Onsite interview (in my case 5 main interviews 30-45 min mostly technical)
- Unfortunately in the third interview, I did not feel good about it as the interviewer was little aggressive about asking questions as he wants to disqualify me which has impacted that round and the following two rounds. Recruiters were great during the whole process.