6. Let's say you see data that looks at email sends by user state for a specific email: Dormant (not in last 30 days) 5% Core (DAU) 45% Casual (WAU) 30% Marginal (MAU) 15% Resurrected (wasn't in last 30 days, then came back as WAU) 5% The objective of email is to get people back to the site. What does this data tell you from a growth perspective? Are we under-sending to any user states?
1. Given a choice of 10 potential experiments, how do you determine which ones to do?
Go through job description and the company website and their products. 1. Tell me about yourself. 2. Previous work tasks. 3. SDLC/ Product lifecycle. 4. Questions on whatever mentioned on your resume. 5. Strength/Weakness.
The business test was for you to explain marketing related decision for a product like Hello Fresh, then you had an ERD with some table and 8 SQL questions to answer with the code, and finally some questions related to AB testing decisions.
Why not Tata or any other big giants, why Vivo?
Q (Technical): A SQL question wherein I was provided with a table having Customer ID, Sales Amount, Transaction ID and Date. I was asked to aggregate them as Total sales, No. of unique customers and total transactions on a monthly basis. The follow-up question was building on this same problem, wherein I was asked to do the same aggregation, but now, for new and recurring users.
Logical Reasoning Questions - If I have two buckets of 3 liter and 5 liter. Assuming there is an infinite supply of water, how can I measure 1 liter water?
Do you know SQL?
there is 30 m deep well and snail takes 1hour to move 3m and at the same time it glides downwards 2m how much time it will take to come out of well?
and many more puzzles
Viewing 261 - 270 interview questions