Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by ShareChat Team. If you also belong to the team, you can get access from here

ShareChat Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

ShareChat Production Analyst Interview Questions and Answers

Updated 15 Jul 2024

ShareChat Production Analyst Interview Experiences

3 interviews found

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Company Website and was interviewed before Jun 2023. There were 3 interview rounds.

Round 1 - Aptitude Test 

SQL round and resume discussion

Round 2 - Case Study 

Guesstimates and RCA around sharechat itself - revenue drop RCA

Round 3 - One-on-one 

(4 Questions)

  • Q1. Resume discussion
  • Q2. Product design and general discussion
  • Q3. Experimentation
  • Q4. Behavioral questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Strong SQL is pre-req for this role, they will also look for mental aptitude via puzzles and product thinking.
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed before Jul 2023. There were 3 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. General SQL questions
  • Q2. Questions around past projects
Round 2 - Technical 

(2 Questions)

  • Q1. SQL questions & case study
  • Q2. Success metric questions
Round 3 - One-on-one 

(1 Question)

  • Q1. Cultural fit questions

Production Analyst Interview Questions Asked at Other Companies

asked in SPRINKLR
Q1. Minimum Time To Solve The Problems Given 'N' subjects, each conta ... read more
asked in SPRINKLR
Q2. Maximum of All Subarrays of Size K You are provided with an array ... read more
asked in CRED
Q3. you are PM of Netflix what will be the top 3 metrics you will loo ... read more
asked in SPRINKLR
Q4. LRU Cache Design Question Design a data structure for a Least Rec ... read more
asked in SPRINKLR
Q5. Shortest Path in a Binary Matrix Problem Statement Given a binary ... read more

I applied via Referral and was interviewed before Nov 2020. There was 1 interview round.

Interview Questionnaire 

4 Questions

  • Q1. Find average n days retention for all users given the user ID, date and activity table. Also another table with the date of joining for each user.
  • Ans. 

    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

  • Answered by AI
  • Q2. 25 horses, find 5 fastest horses, with the constraint that you're only allowed to race 5 horses at a time.
  • Ans. 

    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...

  • Answered by AI
  • Q3. Find nth item without using limit and rank Remove duplicates from combination of two columns, so A1 A2 a b b a Given two columns, remove duplicates for any combination. So the above would be duplicates...
  • Ans. 

    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;

  • Answered by AI
  • Q4. Discussion about skewed Normal distribution, types of skew, impact of skew on mean and median.

Interview Preparation Tips

What is your professional and academic background?At the time of the interview, I had 1 - 3 years of experience.Sharechat interview Rounds:Round 1
Round type - Technical
Round duration - 60 Minutes
Round description -
Round to test basic sql, probability, statistics, and general ability.

Round 2
Round type - Technical
Round duration - 60 Minutes
Round description -
Multiple sql questions, advanced stats and probability questions

Round 3
Round type - General discussion
Round description -
Discussion based on the work that you have done, in depth questions about share chat app and why you're a good fit for the role.
Sharechat interview Preparation:What topics did you prepare for the interview? - SQL, data warehouses, statistical testing.What resources did you refer to prepare for the interview? - Gfg puzzles, introductory books on statistics and probability.What tips would you give to other job seekers? - 1. Be proficient in sql and statistics.
2. Do have a look at the sharechat app and the ecosystem in which it operates.
3. Prepare for puzzles and general problem solving on gfg or some other platform.What was the final outcome of your interview?Selected

Skills evaluated in this interview

Interview questions from similar companies

I applied via Job Portal and was interviewed in Feb 2022. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all Resume tips
Round 2 - Aptitude Test 

1 hour test round, with topics like DSA, Computer Architectutre, DBMS, OS, TOC. C++ Compe Coding interview questions, past year work experience and projects.

Interview Preparation Tips

Interview preparation tips for other job seekers - Be Confident, it's a great place to work.
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
-

I applied via Job Portal and was interviewed before Jun 2022. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all Resume tips
Round 2 - One-on-one 

(1 Question)

  • Q1. Previous company experience and current company roles and responsibilities

Data Analyst Interview Questions & Answers

Meesho user image Abhilasa Barman

posted on 26 Dec 2024

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

I was asked a medium-level SQL question that involved the RANK function.

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Company Website and was interviewed before Feb 2023. There was 1 interview round.

Round 1 - Technical 

(5 Questions)

  • Q1. SQL related questions like joins
  • Q2. Types of join in sql
  • Ans. 

    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

  • Answered by AI
  • Q3. Practical use of left join
  • Ans. 

    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...

  • Answered by AI
  • Q4. Number of rows after applying certain join operations
  • Ans. 

    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

  • Answered by AI
  • Q5. Difference between vlookup in excel and some function in sql
  • Ans. 

    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...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well for SQL

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Company Website and was interviewed before Feb 2023. There were 2 interview rounds.

Round 1 - Coding Test 

Simple SQL & Excel test

Round 2 - One-on-one 

(1 Question)

  • Q1. Will Face hiring Manager
Interview experience
1
Bad
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Company Website and was interviewed in Apr 2024. There was 1 interview round.

Round 1 - Coding Test 

HackerRank Test - Python, SQL

Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Company Website and was interviewed in Jul 2023. There were 4 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all Resume tips
Round 2 - Aptitude Test 

Number sires, clock, logic, arithmetic, geometry

Round 3 - Coding Test 

Code test basic, ans the basic knowledge, write code

Round 4 - Technical 

(5 Questions)

  • Q1. What is python?
  • Ans. 

    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

  • Answered by AI
  • Q2. What is python used for?
  • Ans. 

    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)

  • Answered by AI
  • Q3. What type of language is python?
  • Ans. 

    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...

  • Answered by AI
  • Q4. What is oops in python?
  • Ans. 

    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

  • Answered by AI
  • Q5. What is array in python?
  • Ans. 

    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']

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Swiggy Data Analyst interview:
  • Advanced Excel
  • SQL Server
  • Python
Interview preparation tips for other job seekers - online interview

Skills evaluated in this interview

Contribute & help others!
anonymous
You can choose to be anonymous

ShareChat Interview FAQs

How many rounds are there in ShareChat Production Analyst interview?
ShareChat interview process usually has 3 rounds. The most common rounds in the ShareChat interview process are One-on-one Round, Technical and Aptitude Test.
How to prepare for ShareChat Production Analyst interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at ShareChat. The most common topics and skills that interviewers at ShareChat expect are Data Mining, SQL, Business Objects, Database Design and Javascript.
What are the top questions asked in ShareChat Production Analyst interview?

Some of the top questions asked at the ShareChat Production Analyst interview -

  1. Find average n days retention for all users given the user ID, date and activit...read more
  2. Find nth item without using limit and rank Remove duplicates from combination ...read more
  3. 25 horses, find 5 fastest horses, with the constraint that you're only allowe...read more

Recently Viewed

INTERVIEWS

CPM India Sales & Marketing

No Interviews

LIST OF COMPANIES

Discover companies

Find best workplace

INTERVIEWS

ICICI Bank

No Interviews

INTERVIEWS

BlackBuck

No Interviews

DESIGNATION

INTERVIEWS

GlobalLogic

No Interviews

INTERVIEWS

Accenture

No Interviews

INTERVIEWS

Jyote Motors

No Interviews

INTERVIEWS

Capgemini

No Interviews

INTERVIEWS

Infosys

No Interviews

Tell us how to improve this page.

ShareChat Production Analyst Interview Process

based on 3 interviews

Interview experience

4
  
Good
View more

Interview Questions from Similar Companies

Swiggy Interview Questions
3.8
 • 439 Interviews
Udaan Interview Questions
4.0
 • 335 Interviews
Meesho Interview Questions
3.7
 • 329 Interviews
CARS24 Interview Questions
3.6
 • 328 Interviews
Blinkit Interview Questions
3.7
 • 183 Interviews
BlackBuck Interview Questions
3.8
 • 174 Interviews
Tata 1mg Interview Questions
3.6
 • 146 Interviews
Paisabazaar.com Interview Questions
3.4
 • 139 Interviews
Urban Company Interview Questions
3.4
 • 135 Interviews
Ninjacart Interview Questions
4.0
 • 94 Interviews
View all
ShareChat Production Analyst Salary
based on 36 salaries
₹12 L/yr - ₹24 L/yr
63% more than the average Production Analyst Salary in India
View more details

ShareChat Production Analyst Reviews and Ratings

based on 4 reviews

4.7/5

Rating in categories

4.0

Skill development

4.0

Work-life balance

4.5

Salary

3.3

Job security

4.5

Company culture

3.8

Promotions

4.3

Work satisfaction

Explore 4 Reviews and Ratings
Senior Associate Operations
134 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Operations Associate
122 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Lead Operator
87 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Associate Manager
69 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Territory Sales Manager
68 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare ShareChat with

MOJ

3.4
Compare

Chingari

3.7
Compare

Roposo

4.3
Compare

MX Takatak

5.0
Compare
Did you find this page helpful?
Yes No
write
Share an Interview