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

Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards

zig zag pattern zig zag pattern

Filter interviews by

Flipkart Data Engineer 2 Interview Questions and Answers

Updated 28 Jun 2024

Flipkart Data Engineer 2 Interview Experiences

1 interview found

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

(1 Question)

  • Q1. Provided a json file and needed to write code to ingest, transform and write data in a specified format in order to answer multiple related questions.
Round 2 - Technical 

(2 Questions)

  • Q1. Design a datawarehouse for an e-commerce for buy and sell transaction.
  • Ans. 

    Design a datawarehouse for an e-commerce platform to store buy and sell transactions.

    • Create separate tables for customers, products, transactions, and orders.

    • Use a star schema with a central fact table for transactions and dimension tables for customers, products, and time.

    • Include columns for transaction ID, customer ID, product ID, quantity, price, timestamp, etc.

    • Implement data normalization to reduce redundancy and i...

  • Answered by AI
  • Q2. 3 medium-level SQL problems.

Skills evaluated in this interview

Interview questions from similar companies

I applied via Walk-in and was interviewed in Sep 2020. There was 1 interview round.

Interview Questionnaire 

2 Questions

  • Q1. Aptitude question
  • Q2. Interview panalam questions

Interview Preparation Tips

Interview preparation tips for other job seekers - How many rounds of interview and aptitude questions models

I appeared for an interview before Nov 2019.

Interview Questionnaire 

4 Questions

  • Q1. How do you know about this company?
  • Q2. I have research about this company from various ways and collect a good bunch of information and decided to hire job from this company.
  • Q3. In which skill you are fit to perfect?
  • Q4. Well, iam a quick learner i grab new things at early stage i like to learn new things and perfection is my desire i try to get learn fast and getting knowledge is my aim.

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

Interview Questionnaire 

1 Question

  • Q1. Introducing your self

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident

I applied via Company Website and was interviewed in Oct 2020. There was 1 interview round.

Interview Questionnaire 

2 Questions

  • Q1. I went as a fresher for the job. They asked me technical skills and good cummication skills.
  • Q2. I am interested to do in it

Interview Preparation Tips

Interview preparation tips for other job seekers - I am bathula suresh yadav from medchal
I am pursuing my graduation final year (bcom
Computer)
I have technical skills and good at computer knowledge
I have good cummication skills
Thanking you
Yours careingly

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
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Campus Placement and was interviewed before Aug 2022. There were 3 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 - Aptitude Test 

The aptitude questions were bit easy and there were questions about SQL, and also excel sheets.

Round 3 - Technical 

(1 Question)

  • Q1. Questions about sql

Interview Preparation Tips

Topics to prepare for Uber Data Analyst interview:
  • SQL
  • Excel
Interview preparation tips for other job seekers - Practice well for the interview and put best projects in resume
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed before Feb 2023. There were 4 interview rounds.

Round 1 - Aptitude Test 

Approx 30 questions which are to be solved in 1 hour. Questions include logical and mathematical questions along with basic ML and stats questions

Round 2 - Technical 

(1 Question)

  • Q1. Basic questions related to Python and SQL
Round 3 - Technical 

(1 Question)

  • Q1. Advance SQL questions and 1 case study
Round 4 - Stakeholder Round 

(1 Question)

  • Q1. Basic ML questions and Business acumen questions
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

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

Round 1 - Coding Test 

It was basic MCQ related to Javascript

Round 2 - One-on-one 

(1 Question)

  • Q1. Asked basic questions related to array and SQL
Round 3 - HR 

(1 Question)

  • Q1. Asked question to test the business context
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Basic Apititude Questions

Round 2 - Technical 

(2 Questions)

  • Q1. Difference between WHERE and HAVING??
  • Ans. 

    WHERE is used to filter rows before grouping, HAVING is used to filter groups after grouping.

    • WHERE is used with SELECT statement to filter rows based on a condition

    • HAVING is used with GROUP BY statement to filter groups based on a condition

    • WHERE is applied before data is grouped, HAVING is applied after data is grouped

    • Example: SELECT * FROM table WHERE column = 'value'

    • Example: SELECT column, COUNT(*) FROM table GROUP B

  • Answered by AI
  • Q2. Where- Row Level Filters Having-Aggregate Filters
  • Ans. 

    Row level filters are applied before aggregations, while aggregate filters are applied after aggregations.

    • Row level filters are used to filter individual rows of data before any aggregations are performed.

    • Aggregate filters are used to filter the aggregated results after the data has been grouped and summarized.

    • Row level filters are typically applied using WHERE clause in SQL, while aggregate filters are applied using H...

  • Answered by AI
Round 3 - HR 

(2 Questions)

  • Q1. Why do you wanna join Uber?
  • Q2. Best Company Ever

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare SQL and Excel and Basic Python

Skills evaluated in this interview

Flipkart Interview FAQs

How many rounds are there in Flipkart Data Engineer 2 interview?
Flipkart interview process usually has 2 rounds. The most common rounds in the Flipkart interview process are Technical.
What are the top questions asked in Flipkart Data Engineer 2 interview?

Some of the top questions asked at the Flipkart Data Engineer 2 interview -

  1. Design a datawarehouse for an e-commerce for buy and sell transacti...read more
  2. Provided a json file and needed to write code to ingest, transform and write da...read more
  3. 3 medium-level SQL proble...read more

Tell us how to improve this page.

Flipkart Data Engineer 2 Interview Process

based on 1 interview

Interview experience

4
  
Good
View more

Interview Questions from Similar Companies

Amazon Interview Questions
4.1
 • 5k Interviews
PolicyBazaar Interview Questions
3.6
 • 367 Interviews
BigBasket Interview Questions
3.9
 • 359 Interviews
JustDial Interview Questions
3.5
 • 330 Interviews
Info Edge Interview Questions
3.9
 • 318 Interviews
Zomato Interview Questions
3.8
 • 312 Interviews
Naukri Interview Questions
4.0
 • 185 Interviews
Uber Interview Questions
4.2
 • 150 Interviews
MakeMyTrip Interview Questions
3.7
 • 122 Interviews
View all
Flipkart Data Engineer 2 Salary
based on 6 salaries
₹15 L/yr - ₹50 L/yr
43% more than the average Data Engineer 2 Salary in India
View more details

Flipkart Data Engineer 2 Reviews and Ratings

based on 1 review

4.0/5

Rating in categories

2.0

Skill development

3.0

Work-life balance

4.0

Salary

4.0

Job security

4.0

Company culture

2.0

Promotions

4.0

Work satisfaction

Explore 1 Review and Rating
Senior Executive
2.7k salaries
unlock blur

₹2 L/yr - ₹9 L/yr

Team Lead
1.8k salaries
unlock blur

₹1.2 L/yr - ₹10 L/yr

Operations Executive
1.8k salaries
unlock blur

₹1.2 L/yr - ₹6.3 L/yr

Assistant Manager
1.6k salaries
unlock blur

₹6 L/yr - ₹22 L/yr

Data Entry Operator
1.5k salaries
unlock blur

₹0.4 L/yr - ₹4 L/yr

Explore more salaries
Compare Flipkart with

Amazon

4.1
Compare

Myntra

4.0
Compare

Snapdeal

3.8
Compare

Meesho

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