Ho presentato la mia candidatura online. Ho sostenuto un colloquio presso Instacart (San Francisco, CA) nel mese di giu 2016
Colloquio
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.
Ho presentato la mia candidatura online. Ho sostenuto un colloquio presso Instacart
Colloquio
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.
Ho sostenuto un colloquio presso Instacart (Toronto, ON)
Colloquio
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
Domande di colloquio [1]
Domanda 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.