i
ShareChat
Filter interviews by
Calculate the retention rate for a product using SQL by analyzing user activity over specific time frames.
Define retention: Measure of users who return after their first interaction.
Common formula: Retention Rate = (Returning Users / Total Users) * 100.
Example SQL query: SELECT COUNT(DISTINCT user_id) AS returning_users FROM user_activity WHERE activity_date BETWEEN '2023-01-01' AND '2023-01-31';
Identify cohorts: ...
Negative test cases for money transaction
Transaction amount exceeds account balance
Invalid account number provided
Transaction fails due to network issues
Transaction is blocked due to suspicious activity
Mobile app testing involves testing applications on mobile devices, while web app testing involves testing applications on web browsers.
Mobile app testing includes testing on various mobile devices with different screen sizes and operating systems.
Web app testing focuses on compatibility with different web browsers and screen resolutions.
Mobile app testing may involve testing for offline functionality and push not...
Use Floyd's Tortoise and Hare algorithm to detect loop in linked list.
Initialize two pointers, slow and fast, at the head of the linked list.
Move slow pointer by one step and fast pointer by two steps.
If they meet at any point, there is a loop in the linked list.
Reversing a linked list involves changing the direction of its nodes to point backwards.
1. Initialize three pointers: previous (prev), current (curr), and next.
2. Set prev to null and curr to the head of the list.
3. Iterate through the list: while curr is not null, do the following:
- Store the next node: next = curr.next.
- Reverse the link: curr.next = prev.
- Move prev and curr one step forward: prev = cu...
Event loop is a mechanism in programming that allows for asynchronous execution of code by continuously checking for and handling events.
Event loop is commonly used in JavaScript to handle asynchronous operations.
It allows for non-blocking I/O operations by delegating tasks to the operating system.
Event loop continuously checks the event queue for any pending events and executes them in a sequential manner.
Example...
Find the row with maximum number of 1's in a matrix
Iterate through each row of the matrix
Count the number of 1's in each row
Track the row with maximum number of 1's
Analyzing reasons for a decline in consumption metrics involves multiple factors, including user behavior and external influences.
Check for changes in user behavior, such as reduced engagement or usage frequency.
Investigate external factors like seasonality or economic conditions affecting consumption.
Analyze product or service changes, such as pricing adjustments or feature modifications.
Review marketing efforts ...
Integrate ads into Facebook feed for monetization
Utilize Facebook Audience Network for ad integration
Implement native ads for seamless user experience
Use targeting options to display relevant ads to users
There is no one-size-fits-all answer to which DB is the best choice, as it depends on the specific requirements of the project.
Consider the type of data being stored (structured, unstructured, etc.)
Evaluate the scalability and performance needs of the project
Take into account the budget and resources available for maintenance and support
Look at the existing technology stack and compatibility with other systems
Cons...
I applied via Company Website and was interviewed before Nov 2022. There were 2 interview rounds.
I applied via Referral and was interviewed in Oct 2024. There was 1 interview round.
Calculate the retention rate for a product using SQL by analyzing user activity over specific time frames.
Define retention: Measure of users who return after their first interaction.
Common formula: Retention Rate = (Returning Users / Total Users) * 100.
Example SQL query: SELECT COUNT(DISTINCT user_id) AS returning_users FROM user_activity WHERE activity_date BETWEEN '2023-01-01' AND '2023-01-31';
Identify cohorts: Analy...
2 Medium level DSA questions
Find the row with maximum number of 1's in a matrix
Iterate through each row of the matrix
Count the number of 1's in each row
Track the row with maximum number of 1's
Event loop is a mechanism in programming that allows for asynchronous execution of code by continuously checking for and handling events.
Event loop is commonly used in JavaScript to handle asynchronous operations.
It allows for non-blocking I/O operations by delegating tasks to the operating system.
Event loop continuously checks the event queue for any pending events and executes them in a sequential manner.
Example: In ...
Basic, Easy Assignments
I applied via Referral and was interviewed in May 2024. There was 1 interview round.
Chat support chatroom is a platform where customers can interact with support agents in real-time.
Chat support chatroom allows customers to ask questions and receive immediate assistance.
Support agents can handle multiple customer inquiries simultaneously in a chatroom.
Chat support chatroom can be integrated with AI chatbots to provide automated responses.
Customers can also share files, screenshots, and other relevant ...
I applied via Job Fair and was interviewed in Aug 2024. There were 2 interview rounds.
Assignment related to local language to know our local language skills
I am fluent in my local language and can communicate effectively in both spoken and written forms.
I am a native speaker of my local language
I have received formal education in my local language
I regularly use my local language in daily conversations and interactions
I applied via LinkedIn and was interviewed in May 2024. There were 2 interview rounds.
3 question only simple
Reversing a linked list involves changing the direction of its nodes to point backwards.
1. Initialize three pointers: previous (prev), current (curr), and next.
2. Set prev to null and curr to the head of the list.
3. Iterate through the list: while curr is not null, do the following:
- Store the next node: next = curr.next.
- Reverse the link: curr.next = prev.
- Move prev and curr one step forward: prev = curr; c...
Use Floyd's Tortoise and Hare algorithm to detect loop in linked list.
Initialize two pointers, slow and fast, at the head of the linked list.
Move slow pointer by one step and fast pointer by two steps.
If they meet at any point, there is a loop in the linked list.
DSA Problems from leetcode
I applied via Referral and was interviewed in Mar 2024. There were 2 interview rounds.
It was a leetcode medium, related BFS,
ViewModel is necessary in Android development to save and manage UI-related data during configuration changes.
ViewModel helps in retaining data during configuration changes like screen rotations
It separates UI-related data from UI controller (Activity/Fragment)
ViewModel survives configuration changes and can be shared between fragments
It helps in maintaining data consistency and prevents memory leaks
ViewModel is lifecy...
I applied via Referral and was interviewed in Mar 2024. There was 1 interview round.
Top trending discussions
Some of the top questions asked at the ShareChat interview -
The duration of ShareChat interview process can vary, but typically it takes about less than 2 weeks to complete.
based on 71 interview experiences
Difficulty level
Duration
based on 591 reviews
Rating in categories
Senior Associate Operations
154
salaries
| ₹4 L/yr - ₹9 L/yr |
Operations Associate
127
salaries
| ₹3.5 L/yr - ₹6.1 L/yr |
Lead Operator
72
salaries
| ₹6 L/yr - ₹12.7 L/yr |
Territory Sales Manager
66
salaries
| ₹4 L/yr - ₹9.1 L/yr |
Associate Product Manager
62
salaries
| ₹15 L/yr - ₹41 L/yr |
Udaan
Swiggy
CARS24
BlackBuck