Skip to contentSkip to footer

Senior Scientist Interview Questions

Salaries
Interviews

5,801 senior scientist interview questions shared by candidates

SQL A/B testing question: Q: You are tasked to analyze an experiment called thanksgiving-coupon. Instacart users in this experiment are randomly assigned to “incentive” group or “nonincentive” group. Users in the “incentives” group get an email with $10 off for their next order, and users in the “no incentives” group get an email reminding them to stock up groceries for the Thanksgiving weekend. The $10 off coupon expires on 11/29/2020 (Sunday) 11:59pm PST. How would you analyze this experiment? You have the table Experiments, which contains experiment assignments for Instacart users. Fields:
user_id
experiment: experiment name
group_ind: experiment group a user is assigned to
assigned_at_utc: assignment timestamp. You also have the Orders table, which contains all orders from a user. Fields:
user_id
 order_id
 order_created_timestamp_utc
 order_amount_usd You can use this code to convert time zones: order_created_timestamp_utc at time zone 'utc' at time zone 'pst' You also have the Coupon_spend table, which contains the redeemed thanksgiving-coupon for an order. Fields:
user_id
 order_id
 coupon_spend
avatar

Senior Data Scientist

Interviewed at Instacart

3.6★
Jan 13, 2022

SQL A/B testing question: Q: You are tasked to analyze an experiment called thanksgiving-coupon. Instacart users in this experiment are randomly assigned to “incentive” group or “nonincentive” group. Users in the “incentives” group get an email with $10 off for their next order, and users in the “no incentives” group get an email reminding them to stock up groceries for the Thanksgiving weekend. The $10 off coupon expires on 11/29/2020 (Sunday) 11:59pm PST. How would you analyze this experiment? You have the table Experiments, which contains experiment assignments for Instacart users. Fields:
user_id
experiment: experiment name
group_ind: experiment group a user is assigned to
assigned_at_utc: assignment timestamp. You also have the Orders table, which contains all orders from a user. Fields:
user_id
 order_id
 order_created_timestamp_utc
 order_amount_usd You can use this code to convert time zones: order_created_timestamp_utc at time zone 'utc' at time zone 'pst' You also have the Coupon_spend table, which contains the redeemed thanksgiving-coupon for an order. Fields:
user_id
 order_id
 coupon_spend

Viewing 251 - 260 interview questions

Glassdoor has 5,801 interview questions and reports from Senior scientist interviews. Prepare for your interview. Get hired. Love your job.