Upload Button Icon Add office photos
Engaged Employer

i

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

Flipkart Verified Tick

Compare button icon Compare button icon Compare
4.0

based on 10.4k Reviews

Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards

zig zag pattern zig zag pattern

Filter interviews by

Flipkart Senior Data Analyst Interview Questions and Answers for Experienced

Updated 25 Jul 2024

Flipkart Senior Data Analyst Interview Experiences for Experienced

1 interview found

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via LinkedIn and was interviewed in Jun 2024. There was 1 interview round.

Round 1 - Assignment 

1. round was about handling data where interviewer asked to build the database for the 4 wheeler showroom and find out number of visitor who had 5+ test drive in last 6 months but haven't purchased car yet ?


2. difference between CTE and subquery, where and why we use these ?
3. difference dimensional table and factual table designing
4. how can you optimize query

Interview Preparation Tips

Topics to prepare for Flipkart Senior Data Analyst interview:
  • Database Management
Interview preparation tips for other job seekers - read more about data base management
data manipulation
SQL queries - join and CTE, subquery

Interview questions from similar companies

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

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

Round 1 - Coding Test 

SQL and Math are judged in this round

Round 2 - Case Study 

Analytical and Presentation skills are judged in this round

Round 3 - One-on-one 

(1 Question)

  • Q1. Stakeholder management, situational questions, STAR methodology
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
4-6 weeks
Result
No response

I applied via AmbitionBox and was interviewed in Nov 2024. There were 3 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. I have finished Btech in Cse AI&ML taken datascience course looking for job
Round 2 - Case Study 

NLP is my favorite subject. Is relatated medical and sign language. I have done reseach with mechien learning and AI TOOLS used for problem solving approach.

Round 3 - Group Discussion 

A group discussion was conducted on data-based management regarding Mr. Adani's food industry products in the state of Gujarat and their exports to other countries, utilizing data analytics.

Interview Preparation Tips

Interview preparation tips for other job seekers - I am willing to work hard and invest ample time in the company's development, demonstrating effective time management while sincerely engaging in daily scheduled project-based research and maintaining team spirit.
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
-
Result
No response

I was interviewed in Aug 2024.

Round 1 - Technical 

(2 Questions)

  • Q1. Calculate no of rows after join
  • Ans. 

    Calculate the number of rows after joining two datasets.

    • Count the number of rows in each dataset

    • Perform the join operation

    • Count the number of rows in the resulting dataset

  • Answered by AI
  • Q2. Split person name in excel
  • Ans. 

    Use Excel's text to columns feature to split person names into separate columns.

    • Select the column containing the full names

    • Go to the Data tab and click on Text to Columns

    • Choose 'Delimited' and select the delimiter that separates the names (e.g. space)

    • Click Finish to split the names into separate columns

  • Answered by AI

Skills evaluated in this interview

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

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

Round 1 - One-on-one 

(2 Questions)

  • Q1. About previous experience situation based questions excel problem solving
  • Q2. Tell me about yourself difference between data quality and data validity

Interview Preparation Tips

Interview preparation tips for other job seekers - excel skills and data analysis basics
Interview experience
5
Excellent
Difficulty level
Hard
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed before Feb 2023. There were 3 interview rounds.

Round 1 - Group Discussion 

24 Nov 2023- The Central Armed Police (CAPFS) and other paramilatiry groups in india hire General Duty ( GD) Constables
through the staff.........

Round 2 - Assignment 

Appĺy To 35099 Assessment Text Jobs On Naukari.com, #1 Job Portal In India. Explore Assessment Text Job Openings In Your Desired Now! 12 August 2023 - First Naukari Aptitude Questions and Answers 2023 is given here on this page along with Frst Naukari Aptitude Text Practice Questions.

Round 3 - Assignment 

The meaning of "Job Assignments" differs based on where it is used.

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepared to Face Concern
Keep your yourself
Know Your Audience
Use An Online Resume Builder
Do You Research.
Back-Up Your Claims
Be Specific.
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed before May 2023. There were 2 interview rounds.

Round 1 - Aptitude Test 

It been for 45 mins. question asked from python,ML,Deep learning and maths.

Round 2 - Technical 

(1 Question)

  • Q1. 1) explain correlation and convaraince 2) how logistic differ from linear regression
  • Ans. 

    Correlation measures the strength and direction of a linear relationship between two variables, while covariance measures the extent to which two variables change together.

    • Correlation ranges from -1 to 1, where 1 indicates a perfect positive relationship, -1 indicates a perfect negative relationship, and 0 indicates no relationship.

    • Covariance can be positive, negative, or zero. A positive covariance indicates that as o...

  • Answered by AI

I applied via LinkedIn and was interviewed in Aug 2020. There were 3 interview rounds.

Interview Questionnaire 

4 Questions

  • Q1. Questions on SQL involving Joins, ranker over() partition by, Group by, Coalesce.
  • Q2. Python basic questions for rank and group by and the same to do in excel.
  • Q3. Some logical thinking ability questions.
  • Q4. Any project related to online customer data.
  • Ans. 

    I have worked on a project related to online customer data for a retail company.

    • Analyzed customer behavior on the company's website using Google Analytics

    • Identified popular products and pages visited by customers

    • Created customer segments based on demographics and behavior

    • Provided recommendations to improve website navigation and product offerings

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - It was overall an easy interview.

I applied via Walk-in and was interviewed before Jul 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Some general knowledge question regarding shoping and what is justdial

Interview Preparation Tips

Interview preparation tips for other job seekers - It was good
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. SQL Window function- hard
  • Q2. Case study questions answers

Flipkart Interview FAQs

How many rounds are there in Flipkart Senior Data Analyst interview for experienced candidates?
Flipkart interview process for experienced candidates usually has 1 rounds. The most common rounds in the Flipkart interview process for experienced candidates are Assignment.
How to prepare for Flipkart Senior Data Analyst interview for experienced candidates?
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 Flipkart. The most common topics and skills that interviewers at Flipkart expect are Data Analysis, Python, SQL, Analytical and QlikView.

Tell us how to improve this page.

People are getting interviews through

based on 1 Flipkart interview
Job Portal
100%
Low Confidence
?
Low Confidence means the data is based on a small number of responses received from the candidates.

Interview Questions from Similar Companies

Amazon Interview Questions
4.1
 • 4.9k Interviews
BigBasket Interview Questions
3.9
 • 345 Interviews
JustDial Interview Questions
3.5
 • 326 Interviews
Zomato Interview Questions
3.8
 • 314 Interviews
Info Edge Interview Questions
4.0
 • 313 Interviews
PolicyBazaar Interview Questions
3.5
 • 307 Interviews
Myntra Interview Questions
4.0
 • 207 Interviews
Naukri Interview Questions
4.0
 • 178 Interviews
Uber Interview Questions
4.2
 • 157 Interviews
View all
Flipkart Senior Data Analyst Salary
based on 137 salaries
₹4.5 L/yr - ₹15 L/yr
20% less than the average Senior Data Analyst Salary in India
View more details

Flipkart Senior Data Analyst Reviews and Ratings

based on 14 reviews

3.8/5

Rating in categories

3.5

Skill development

3.9

Work-Life balance

3.2

Salary & Benefits

4.0

Job Security

3.7

Company culture

3.0

Promotions/Appraisal

3.6

Work Satisfaction

Explore 14 Reviews and Ratings
Senior Executive
2.5k salaries
unlock blur

₹2.2 L/yr - ₹9 L/yr

Operations Executive
1.8k salaries
unlock blur

₹1.1 L/yr - ₹6.5 L/yr

Team Lead
1.8k salaries
unlock blur

₹1.2 L/yr - ₹9.8 L/yr

Assistant Manager
1.6k salaries
unlock blur

₹6 L/yr - ₹21 L/yr

Executive
1.3k salaries
unlock blur

₹1.2 L/yr - ₹6.5 L/yr

Explore more salaries
Compare Flipkart with

Amazon

4.1
Compare

Myntra

4.0
Compare

Snapdeal

3.9
Compare

Meesho

3.7
Compare

Calculate your in-hand salary

Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and get your in-hand salary
Did you find this page helpful?
Yes No
write
Share an Interview