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

ShareChat Senior Data Analyst Interview Questions and Answers

Updated 28 Jul 2024

ShareChat Senior Data Analyst Interview Experiences

1 interview found

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(2 Questions)

  • Q1. SQL Basic Questions
  • Q2. RCA question if consumption metric goes down

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident and straight forward

Interview questions from similar companies

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-

I applied via Naukri.com and was interviewed in Apr 2024. There was 1 interview round.

Round 1 - Coding Test 

Test was based on SQL, coding and MCQ. Coding involved nested query.

Data Analyst Interview Questions & Answers

Meesho user image vinay kalikota

posted on 2 Sep 2024

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

There are 2 coding challenges and 7 objective questions

Round 2 - Technical 

(1 Question)

  • Q1. Technical questions related to role
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(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)
Round 2 - Coding Test 

In the second technical round interview asked me about advanced sql topics, theory questions and two coding questions in joins and window functions.

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
No response

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

Round 1 - Aptitude Test 

Quant, LR, puzzles, cat based level 2 questions

Round 2 - Technical 

(2 Questions)

  • Q1. Difference between tuple nd list
  • Ans. 

    Tuple is immutable and ordered, while list is mutable and ordered in Python.

    • Tuple is created using parentheses () while list is created using square brackets []

    • Tuple elements cannot be changed once assigned, while list elements can be modified

    • Tuple is faster than list for iteration and accessing elements

    • Example: tuple = (1, 2, 3) and list = [1, 2, 3]

  • Answered by AI
  • Q2. How will you cut a cake into 8 equal pieces by 3 cuts
Round 3 - HR 

(2 Questions)

  • Q1. Walk me through ur cv
  • Ans. 

    I have a strong background in data analysis with experience in various industries.

    • Bachelor's degree in Statistics with a focus on data analysis

    • Proficient in SQL, Python, and data visualization tools like Tableau

    • Experience working with large datasets and conducting statistical analysis

    • Completed internships at XYZ Company and ABC Organization

    • Presented findings at industry conferences

  • Answered by AI
  • Q2. What have learnt from this experience?
  • Ans. 

    I have learned to effectively analyze and interpret data to derive meaningful insights and make informed decisions.

    • Developed strong analytical skills through hands-on experience with various data analysis tools and techniques

    • Improved ability to identify trends, patterns, and outliers in data sets

    • Enhanced communication skills by presenting findings and recommendations to stakeholders

    • Learned to collaborate with team memb

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - just be honest , calm

Skills evaluated in this interview

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
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 tips
Round 2 - One-on-one 

(1 Question)

  • Q1. Previous company experience and current company roles and responsibilities
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
Selected Selected

I applied via Referral and was interviewed in Aug 2023. There were 2 interview rounds.

Round 1 - Coding Test 

SQL query optimisation

Round 2 - HR 

(1 Question)

  • Q1. Regular discussion, about job role, why swiggy

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare excel, and sql

ShareChat Interview FAQs

How many rounds are there in ShareChat Senior Data Analyst interview?
ShareChat interview process usually has 1 rounds. The most common rounds in the ShareChat interview process are One-on-one Round.
What are the top questions asked in ShareChat Senior Data Analyst interview?

Some of the top questions asked at the ShareChat Senior Data Analyst interview -

  1. RCA question if consumption metric goes d...read more
  2. SQL Basic Questi...read more

Tell us how to improve this page.

ShareChat Senior Data Analyst Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more

Interview Questions from Similar Companies

Swiggy Interview Questions
3.8
 • 428 Interviews
Udaan Interview Questions
4.0
 • 334 Interviews
CARS24 Interview Questions
3.5
 • 333 Interviews
Meesho Interview Questions
3.7
 • 328 Interviews
BlackBuck Interview Questions
3.8
 • 178 Interviews
Tata 1mg Interview Questions
3.6
 • 146 Interviews
Digit Insurance Interview Questions
3.9
 • 142 Interviews
Paisabazaar.com Interview Questions
3.4
 • 139 Interviews
Urban Company Interview Questions
3.4
 • 135 Interviews
Ninjacart Interview Questions
4.0
 • 95 Interviews
View all
ShareChat Senior Data Analyst Salary
based on 7 salaries
₹10.8 L/yr - ₹20.6 L/yr
34% more than the average Senior Data Analyst Salary in India
View more details
Senior Associate Operations
137 salaries
unlock blur

₹4 L/yr - ₹8.4 L/yr

Operations Associate
125 salaries
unlock blur

₹3.5 L/yr - ₹6.1 L/yr

Lead Operator
87 salaries
unlock blur

₹6 L/yr - ₹12.7 L/yr

Territory Sales Manager
68 salaries
unlock blur

₹4 L/yr - ₹8.8 L/yr

Associate Product Manager
61 salaries
unlock blur

₹15 L/yr - ₹41 L/yr

Explore more salaries
Compare ShareChat with

Udaan

4.0
Compare

Swiggy

3.8
Compare

CARS24

3.5
Compare

BlackBuck

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