Assistant Scientist Interview Questions

54,225 assistant scientist interview questions shared by candidates

Q1. SQL Given tables: employees(id, unixname,team,role,days_since_started) projects(id,name,....) commits(id,file_path,proj_id,auth_id,timestamp) Find the number of unique employees per project per month? Q2. Imagine you have a CSV file: john_doe,android,ios,infra bob_law,is,backend jane_doe,frontend ------------------------------ Containing,for each employee, a list of projects he/she works on Write a script/function/else that reads data from CSV file and creates a data structure that stores, for each project, a list of employees who work on it.
avatar

Data Scientist Infrastructure

Interviewed at Meta

3.6
Feb 13, 2018

Q1. SQL Given tables: employees(id, unixname,team,role,days_since_started) projects(id,name,....) commits(id,file_path,proj_id,auth_id,timestamp) Find the number of unique employees per project per month? Q2. Imagine you have a CSV file: john_doe,android,ios,infra bob_law,is,backend jane_doe,frontend ------------------------------ Containing,for each employee, a list of projects he/she works on Write a script/function/else that reads data from CSV file and creates a data structure that stores, for each project, a list of employees who work on it.

given a table massenger_sends, date | ts | sender_id | receiver_id| message_id | has_reaction Q1) how many unique conversation threads are there ? note that there are threads that sender_id and receiver is inverse. this should be one thread
avatar

Data Scientist

Interviewed at Meta

3.6
Jan 3, 2022

given a table massenger_sends, date | ts | sender_id | receiver_id| message_id | has_reaction Q1) how many unique conversation threads are there ? note that there are threads that sender_id and receiver is inverse. this should be one thread

Viewing 101 - 110 interview questions

Glassdoor has 54,225 interview questions and reports from Assistant scientist interviews. Prepare for your interview. Get hired. Love your job.