WinZO Interview Questions, Process, and Tips

Q1. All about your self.......................................
Add your answer

Q1. Metric to determine the new users in a platform
Ans. 
One metric to determine new users in a platform is the number of unique sign-ups within a specific time period.
• Track the number of unique users who sign up for an account on the platform.

• Monitor the growth rate of new users over time to identify trends.

• Compare the number of new users to the total number of active users to assess the platform's user acquisition effectiveness.
Answered by AI
Add your answer

Q1. Low level design of workflow engine
Ans. 
Designing a workflow engine involves creating a system to manage and execute a series of tasks in a specific order.
• Identify the different steps or tasks in the workflow

• Define the dependencies between tasks

• Implement logic for task execution and error handling

• Consider scalability and performance requirements

• Use a state machine or graph-based approach for modeling workflows
Answered by AI
Add your answer

Q1. Design a notification system which supports immediate, delayed and repeated notifications
Ans. 
Design a notification system supporting immediate, delayed, and repeated notifications
• Use a queue to manage notifications with different delivery times

• Include options for immediate, delayed, and repeated notifications

• Allow users to set preferences for notification timing and frequency

• Implement a scheduling algorithm to handle repeated notifications

• Consider incorporating user feedback mechanisms for notification customi
Answered by AI
Add your answer

Q1. Resume walk through and questions from past work ex. Overview of the app, what can be improved.
Add your answer

Intermediate SQL Topics - Window Function, Subquery, Joins

Tables:
registration (userid string, regdate date);
txn(txndate date, userid string, amt int, game string);

1. Write a query to get proportion of users who have played a game within 2 days of registration
2. Find the most money spent on a game for each user
3. Get the list of users who played poker but not ludo