Fi Production Analyst Interview Questions and Answers

Online test on Hackerrank 7 questions in 120 minutes. 4 questions were easy last 3 were mainly focused on Retention and retained user definition that was too specific to the cred use case.

Q1. You are PM of Netflix what will be the top 3 metrics you will look at and why?
Ans. 
The top 3 metrics I would look at as the PM of Netflix are subscriber growth, user engagement, and content performance.
• Subscriber growth: This metric indicates the success of Netflix in acquiring new customers and expanding its user base. It helps measure the effectiveness of marketing strategies and the overall popularity of the platform.

• User engagement: This metric measures how actively users are interacting with the...read more
Answered by AI
View 3 more answers
Q2. Differentiate between row number and dense rank?
Ans. 
Row number is a sequential number assigned to each row, while dense rank assigns a unique rank to each distinct value.
• Row number is assigned in sequential order to each row in a result set.

• Dense rank assigns a unique rank to each distinct value in a result set.

• Row number is not affected by ties, while dense rank is affected by ties.

• For example, if there are two rows with the same value in a dense rank, they will both r...read more
Answered by AI
Add your answer
Q3. Find out the total time spent by the employees if you have the data for their sign-in and sign-out.
Ans. 
To find the total time spent by employees, calculate the difference between sign-in and sign-out times for each employee and sum them up.
• Iterate through the data for each employee

• Calculate the time difference between sign-in and sign-out for each employee

• Sum up the time differences to get the total time spent by all employees
Answered by AI
Add your answer
Q4. You have country name rank the names so that one particular company comes on top always
Add your answer

Q1. Swiggy revenue is dropping in the last 3 months. Do and RCA as an analyst. What are all the different things you will look at?
Add your answer

Would give data and stats and tell us to interpret or metric

Q1. Basics and general
Add your answer
Q2. All general once only
Add your answer