Data manager Interview Questions
2K
Data Manager interview questions shared by candidates
A table with posts and a table with reactions to posts. Find the avg number of likes per post for the past 28 days.
4 Answers↳
You have a metric, then some UI have changed over time, your metric increased by 20%. How do you measure the change?? This was what he said word for word. Indeed it sounded weird to me at first: the changed was measured, its 20%, but I went ahead and assumed the question was on attribution analysis. But eventually it seems the question was just how to do a AB test if something needs to change. Less
↳
Yeah, odd. They probably wanted something like a pre-post analysis I guess with a t-test to show significance in the difference? But that should never be the case - you should always experiment first you said. Less
↳
Select p.postid, ,sum(case when reaction =’likes’ then 1 else 0 end) /count(*) Posts p Join likes r on p.postid = r.postid where data = currentdate – interval ’28 day’ group by p.postid, Less
1. What do you mean by Phase 1 Clinical Trials?
3 Answers↳
1. What are your skillets?
↳
In phase one we chacke only efficacy of drug
↳
Test the efficacy of Drug
are you married?
3 Answers
Q: Research nurse went out for a few minutes. A patient rang and is ill and needs to speak to her. You pick up phone what would you do.
3 Answers↳
Keep the patient calm and inform them that the research nurse has just stepped out. Take name and contact details so that the research nurse can call them when they get back. (Probably wrong I am a recent uni grad) Less
↳
Hi, I have an interview next week for a Clinical Trials Assistant role. I will have a test that is 30 minutes long. What was your assessment like? Is there any way in which to prepare? Less
↳
Hi, I have an interview next week for a Clinical Trials Assistant role. I will have a test that is 30 minutes long. What was your assessment like? Is there any way in which to prepare? Less
Do you have experience managing projects involving developers located on another continent?
2 Answers↳
yes, when working with off-shore teams it's critical to ensure that the problem is clearly defined, don't leave anything to guess work. Agile works best for off-shore to ensure resource/team is making good progress, keep on task and can provide guidance/clarification when needed early on. Also recommend that there is an off-shore project manager that you work with if possible. Less
↳
yes, when working with off-shore teams it's critical to ensure that the problem is clearly defined, don't leave anything to guess work. Agile works best for off-shore to ensure resource/team is making good progress, keep on task and can provide guidance/clarification when needed early on. Also recommend that there is an off-shore project manager that you work with if possible. Less
Be prepared for questions that try to judge who *you* are as a person. The managers at Build really want to see the individual come out in an interview, so occasionally the questions can be pretty random.
2 Answers↳
Be Yourself
↳
can you mention a few questions?
Data Model: LinkedIn data model - model for 1st degree connection Python: 1. Dedup items in the list - retaining the order of items. ==> cannot use dict/set since order will not be retained. Follow up question on this - How would you handle nested lists? (they are looking for recursion) 2. Find the number of words in a sentence /avg length of word SQL On the product-sales-customers data model that is preloaded in coderpad.io, write the following queries 1. Count of stores in OR state with area_sqft > 25000 2. avg number of Female Customers group by state 3. Customer FirstName, Last Name and count of unqiue products purchased by state followup question - Return the top customer by state based on diverse product purchased (diverse = count(distinct product_id))
2 Answers↳
Python: 1. dedup - create new list and append items from input list while checking it is not in the output list. this will retain order. to handle nested lists, 2 approached. option 1 Flatten the input_list as Flat_Input_List and run thro' the same logic. option 2 recursion by declaring output_list in outer scope. TIPS: They don't expect you to use Set / Dict to de-dup since it doesn't retain the order They don't expect you to use all built in functions, since they are looking to test ur logical thinking Use the right data structure Use recursion logic 2. this is straight forward. Already in glassdoor and worked out answers in geekforgeeks. TIP: make sure to do input_validation/handling corner cases like empty string / None etc SQL Just need to be familiar with 1. Window functions using Partition by State / dense_rank() to get rank = 1 2. logic to get % 3. logic with CASE statement with in COUNT or SUM 4. use ROUND () 5. use Left join when needed - see results if it has all states with 0 for non-matching rows. select round((sum((case when promotion_id > 0 then store_sales else 0.0 end)) / sum(store_sales))*100,2) promoted, round((sum((case when promotion_id = 0 then store_sales else 0.0 end)) / sum(store_sales))*100,2) non_promoted from sales select count(*), sum(area_sqft), state from stores group by state having sum(area_sqft)>25000 # select p.product_id, sum(store_sales) from sales s inner join products p on s.product_id = s.product_id group by p.product_id order by sum(store_sales) desc Less
↳
Hi, could you please advise your experience and the type of onsite interviews you went through? I appreciate it. Thanks Less
Write a python program to remove duplicates , keep the first occurrance
2 Answers↳
def remove_duplicates(input_list): unique_list = [] count_num = set([]) for num in input_list: if not count_num or i not in count_num: unique_list.append(num) count_num.add(num) return unique_list Less
↳
Approach 1: simply use set() function because set() can't have duplicates list (set()) approach 2: Use inbuilt dictionary list(dict.fromkeys ()) Less
