AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
ShareChat
Compare
Filter interviews by
ShareChat Production Analyst Interview Questions and Answers
ShareChat Production Analyst Interview Experiences
3 interviews found
Anonymous
Selected
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
(4 Questions)
- Q1. Resume discussion
- Q2. Product design and general discussion
- Q3. Experimentation
- Q4. Behavioral questions
Interview Preparation Tips
Selected
I applied via Referral and was interviewed before Jul 2023. There were 3 interview rounds.
(2 Questions)
- Q1. General SQL questions
- Q2. Questions around past projects
(2 Questions)
- Q1. SQL questions & case study
- Q2. Success metric questions
(1 Question)
- Q1. Cultural fit questions
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
- 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...
- 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;
- Q4. Discussion about skewed Normal distribution, types of skew, impact of skew on mean and median.
Interview Preparation Tips
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 questionsRound 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
Production Analyst Interview Questions & Answers
Amazon MX Player
Aditya Kumar
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.
Interview Preparation Tips
Gautham Reddy
(2 Questions)
- Q1. Interviewer asked me basic SQL questions
- Q2. In the second technical round he asked me advanced SQL topics (Windows Functions, Joins & Subqueries)
In the second technical round interview asked me about advanced sql topics, theory questions and two coding questions in joins and window functions.
Selected
I applied via Referral and was interviewed in Mar 2023. There were 2 interview rounds.
(2 Questions)
- Q1. What’s your previous experience
- Ans.
I have 3 years of experience as a data analyst in the finance industry.
Worked with large datasets to extract meaningful insights
Performed data cleaning, transformation, and visualization
Created and maintained dashboards and reports for stakeholders
Conducted statistical analysis and built predictive models
Collaborated with cross-functional teams to identify business opportunities
- Q2. What’s your skills for the current role
- Ans.
I have strong skills in data analysis, including proficiency in statistical analysis, data visualization, and programming languages such as Python and SQL.
Proficient in statistical analysis techniques
Skilled in data visualization using tools like Tableau
Strong programming skills in Python and SQL
Experience with data cleaning and preprocessing
Ability to interpret and communicate insights from data
Familiarity with machin...
Interview Preparation Tips
- SQL
- Python
I applied via Naukri.com and was interviewed before Apr 2021. There were 4 interview rounds.
Technica questions related to sql
(1 Question)
- Q1. Some technical questions related to sql and advance excel .
(1 Question)
- Q1. Some questions related to cars insurance and second cars
(1 Question)
- Q1. Salary discussion and some hr questions
Interview Preparation Tips
Selected
I applied via Referral and was interviewed in Aug 2023. There were 2 interview rounds.
SQL query optimisation
(1 Question)
- Q1. Regular discussion, about job role, why swiggy
Interview Preparation Tips
I applied via Naukri.com and was interviewed in Apr 2024. There was 1 interview round.
Test was based on SQL, coding and MCQ. Coding involved nested query.
I applied via Job Portal and was interviewed in Oct 2024. There was 1 interview round.
(1 Question)
- Q1. SQL query use join
ShareChat Interview FAQs
Some of the top questions asked at the ShareChat Production Analyst interview -
Tell us how to improve this page.
ShareChat Interviews By Designations
- ShareChat Senior Software Engineer Interview Questions
- ShareChat SDE-2 Interview Questions
- ShareChat Associate Product Manager Interview Questions
- ShareChat Software Developer Interview Questions
- ShareChat Production Analyst Interview Questions
- ShareChat Operations Associate Interview Questions
- ShareChat Data Analyst Interview Questions
- ShareChat Senior Associate Operations Interview Questions
- Show more
Interview Questions for Popular Designations
- Production Engineer Interview Questions
- Production Supervisor Interview Questions
- Production Manager Interview Questions
- Production Officer Interview Questions
- Executive Production Interview Questions
- Production Interview Questions
- Senior Production Engineer Interview Questions
- Production Graduate Engineer Trainee Interview Questions
- Show more
ShareChat Production Analyst Interview Process
based on 3 interviews
Interview experience
Production Analyst Interview Questions from Similar Companies
Fast track your campus placements
ShareChat Production Analyst Reviews and Ratings
based on 4 reviews
Rating in categories
|
Senior Associate Operations
138
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
- Home >
- Interviews >
- ShareChat Interview Questions >
- ShareChat Production Analyst Interview Questions
