I applied through an employee referral. The process took 3 weeks. I interviewed at Shipt
Interview
3 stages to the process-
1. intro phone call - introduction round with the recruiter, beware introduction can turn into an rejection also
2. live coding round (SQL,python)/HR round - joins, subqueries, string manipulation, pandas, numpy.
3. panel interview
Interview questions [1]
Question 1
1) SQL queries
2) string manipulation using any library that you are comfortable with
I applied online. I interviewed at Shipt (Birmingham, AL) in Oct 2020
Interview
Had a initial discussion with the recruiter after applying to the job. The call was pretty straight forward which described the job role and the interview process in brief. Wasn't really spared time to ask any questions regarding the team or the on going projects.
Got a technical assessment which was used to gauge my knowledge on sql, python, data modelling and etc. I almost spent 10hrs completing the assignment and later got an email stating, my experience doesn't match the requirement.
I mean seriously, if my experience wasn't really match then why did you guys even give me a call.
Disappointed with the process, communication could have been much better.
I applied online. I interviewed at Shipt in Jul 2020
Interview
First Round - Brief conversation with recruiter about experiences and fit for the role.
Second Round - In depth technical discussion with hiring manager.
Third Round - Technical SQL screening.
Final Round - Panel interview with few members with the team.
Interview questions [1]
Question 1
First Round - Brief conversation with recruiter about experiences and fit for the role.
Second Round - In depth technical discussion with hiring manager. A few technical questions about database design, query performance improvement and other similar concepts.
Third Round - Technical SQL screening. Easy to medium level questions from HackerRank, try not to overthink too much and keep it simple.
