i
ShareChat
Filter interviews by
Clear (1)
I applied via Company Website and was interviewed before Jun 2023. There were 3 interview rounds.
SQL round and resume discussion
Guesstimates and RCA around sharechat itself - revenue drop RCA
I applied via Referral and was interviewed before Jul 2023. There were 3 interview rounds.
I applied via Referral and was interviewed before Nov 2020. There was 1 interview round.
Calculate the average n days retention for all users given their user ID, date, activity table, and a table with the date of joining for each user.
Join the activity table with the user table using the user ID
Calculate the number of days between the date of joining and the activity date
Filter out the activities that occurred after n days
Calculate the average retention for all users
Race 5 horses at a time to find the 5 fastest horses out of 25.
Divide the horses into 5 groups of 5 horses each.
Race all the horses in each group and note down the timings.
The top 3 horses from each group move to the next round.
Race all the horses that made it to the next round and note down the timings.
The top 2 horses from this round move to the final round.
Race these 2 horses and the fastest one is the winner.
The to...
To remove duplicates from two columns, use DISTINCT keyword in SELECT statement.
Use SELECT DISTINCT to retrieve unique combinations of two columns.
Combine the two columns using CONCAT function before applying DISTINCT.
Example: SELECT DISTINCT CONCAT(column1, column2) FROM table_name;
Top trending discussions
posted on 27 Aug 2022
I applied via Job Portal and was interviewed in Feb 2022. There were 2 interview rounds.
1 hour test round, with topics like DSA, Computer Architectutre, DBMS, OS, TOC. C++ Compe Coding interview questions, past year work experience and projects.
I applied via Job Portal and was interviewed before Jun 2022. There were 2 interview rounds.
I was asked a medium-level SQL question that involved the RANK function.
I applied via Company Website and was interviewed before Feb 2023. There was 1 interview round.
Types of join in SQL include inner join, left join, right join, and full outer join.
Inner join returns only the matching records from both tables.
Left join returns all records from the left table and the matching records from the right table.
Right join returns all records from the right table and the matching records from the left table.
Full outer join returns all records when there is a match in either the left or rig
A left join is used to combine data from two tables based on a common column, including all records from the left table.
Left join returns all rows from the left table and the matching rows from the right table.
It is useful when you want to retrieve all records from the left table, even if there are no matches in the right table.
The result of a left join will have NULL values in the columns from the right table where th...
The number of rows after applying join operations depends on the type of join used and the data in the tables being joined.
Inner join retains only the rows that have matching values in both tables
Left join retains all rows from the left table and the matched rows from the right table
Right join retains all rows from the right table and the matched rows from the left table
Full outer join retains all rows when there is a
VLOOKUP in Excel is used to search for a value in a table and return a corresponding value, while SQL functions like JOIN and WHERE are used to retrieve data from multiple tables based on specified conditions.
VLOOKUP is specific to Excel and works on a single table, while SQL functions can work on multiple tables.
VLOOKUP requires the table to be sorted in ascending order, while SQL functions do not have this requiremen...
I applied via Company Website and was interviewed before Feb 2023. There were 2 interview rounds.
Simple SQL & Excel test
I applied via Company Website and was interviewed in Apr 2024. There was 1 interview round.
HackerRank Test - Python, SQL
I applied via Company Website and was interviewed in Jul 2023. There were 4 interview rounds.
Number sires, clock, logic, arithmetic, geometry
Code test basic, ans the basic knowledge, write code
Python is a high-level programming language known for its simplicity and readability.
Python is widely used for web development, data analysis, artificial intelligence, and scientific computing.
It emphasizes code readability and uses indentation to define code blocks.
Python has a large standard library and a vibrant community of developers.
Example: print('Hello, World!')
Example: import pandas as pd
Python is a versatile programming language used for data analysis, web development, artificial intelligence, automation, and more.
Data analysis and visualization
Web development (Django, Flask)
Artificial intelligence and machine learning (TensorFlow, PyTorch)
Automation and scripting
Scientific computing (NumPy, SciPy)
Python is a high-level programming language known for its simplicity and readability.
Python is an interpreted language, meaning it does not need to be compiled before running.
It supports multiple programming paradigms, including object-oriented, imperative, and functional programming.
Python has a large standard library and a thriving community, making it versatile and widely used.
Example: Python is used for web develop...
Object-oriented programming (OOP) is a programming paradigm based on the concept of 'objects', which can contain data and code.
OOP allows for the organization of code into reusable components called classes.
Classes can have attributes (variables) and methods (functions) associated with them.
In Python, everything is an object, and classes can be defined using the 'class' keyword.
Encapsulation, inheritance, and polymorph
An array in Python is a data structure that stores a collection of elements of the same type.
Arrays can store elements such as integers, floats, or strings.
Arrays are indexed starting from 0, with elements accessed using their index.
Example: arr = ['apple', 'banana', 'cherry']
Some of the top questions asked at the ShareChat Production Analyst interview -
based on 3 interviews
Interview experience
based on 4 reviews
Rating in categories
Senior Associate Operations
134
salaries
| ₹0 L/yr - ₹0 L/yr |
Operations Associate
122
salaries
| ₹0 L/yr - ₹0 L/yr |
Lead Operator
87
salaries
| ₹0 L/yr - ₹0 L/yr |
Associate Manager
69
salaries
| ₹0 L/yr - ₹0 L/yr |
Territory Sales Manager
68
salaries
| ₹0 L/yr - ₹0 L/yr |
MOJ
Chingari
Roposo
MX Takatak