I applied online. I interviewed at Instacart in Oct 2018
Interview
Extremely unprofessional. Applied online, got a response asking for a phone screen with recruiter fairly fast; it went well so we scheduled a Google Hangouts call with the hiring manager. No one answered during the scheduled meeting time so I emailed back my recruiter and asked for an update. She said she would check with the hiring manager and didn't get back to me until I emailed her again asking for another update. She didn't apologize for me waiting an hour for the hiring manager but we set up another time for me to talk with him. Second time comes, no one answers again so I email my recruiter again. She says she'll check in with the hiring manager and again didn't get back to me. I emailed her again a couple days ago asking for an update, but no response so I guess Instacart basically stood me up twice then ghosted me? lol. Honestly, the very first initial phone screen with the recruiter was fine, she was really nice, but in general the company seems disorganized and unprofessional. 0/10 would apply again.
Interview questions [1]
Question 1
Walk through resume - normal phone screen questions
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.
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
Interview questions [1]
Question 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.
