Data manager Interview Questions

1K

Data Manager interview questions shared by candidates

Top Interview Questions

Sort: Relevance|Popular|Date
Meta
Data Science Manager was asked...7 October 2020

A table with posts and a table with reactions to posts. Find the avg number of likes per post for the past 28 days.

3 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 avg(post.post_id), post_id, likes.reaction from post, likes left join post.post_id=likes.post_id and likes.reaction='like' and post.date systemdate-20 group by likes.reaction Less

Novartis

are you married?

3 Answers

I did not know what to say. I have never been asked this in an interview situation Less

What recruiting agency did you apply through?

I don't think that's a legal question to ask during an interview. The best solution is to state that the question has no connection to the position. Less

University College London Hospitals
Data Manager was asked...14 September 2015

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

Tata Consultancy Services

1. What do you mean by Phase 1 Clinical Trials?

2 Answers

In phase one we chacke only efficacy of drug

1. What are your skillets?

DISH

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

Build.com

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?

Meta

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

Meta

write a python program to count words?

2 Answers

sentence = "I am an engineer" sentenceList = sentence.split(sep=" ") print(len(sentenceList)) Less

txt = "I am an engineer" #converts the txt variable to a LIST and then does a LEN to get the number of words x = len(txt.split()) print(x) Less

Meta

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

BandPage

Who's your favorite band?

1 Answers

This was difficult because...I'm immediately thinking...is it a trap? Reluctantly I admitted that my favorite artist was Elton John. And, when I accepted my offer, it came with 2 tickets to see Elton John! Less

Viewing 1 - 10 of 1,149 Interview Questions

See Interview Questions for Similar Jobs

data coordinatoranalytics managerdata architectbi managerdata analystdigital asset manager