Perguntas de entrevista de Data manager

1 mil

Perguntas de entrevista para o cargo de Data Manager compartilhadas pelos candidatos

Principais perguntas de entrevista

Ordenar: Relevância|Popularidade|Data
Novartis
Pergunta feita para Data Manager...13 de fevereiro de 2014

are you married?

3 respostas

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

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. Menos

Meta

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 respostas

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. Menos

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. Menos

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 Menos

University College London Hospitals

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 respostas

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) Menos

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? Menos

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? Menos

Tata Consultancy Services

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

2 respostas

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 respostas

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. Menos

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. Menos

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 respostas

Be Yourself

can you mention a few questions?

Meta

write a python program to count words?

2 respostas

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

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) Menos

Meta

Write a python program to remove duplicates , keep the first occurrance

2 respostas

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 Menos

Approach 1: simply use set() function because set() can't have duplicates list (set()) approach 2: Use inbuilt dictionary list(dict.fromkeys ()) Menos

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 respostas

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 Menos

Hi, could you please advise your experience and the type of onsite interviews you went through? I appreciate it. Thanks Menos

BandPage

Who's your favorite band?

1 respostas

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! Menos

Mostrando 1 a 10 de 1.142 Perguntas da entrevista

Veja perguntas de entrevista para vagas semelhantes

data coordinatordata architectanalytics managerbi managerdata analystdigital asset manager