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 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 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.
Round 1 - Technical 

(2 Questions)

  • Q1. Create the pivot table, sort the data in ascending order
  • Ans. 

    Create a pivot table and sort the data in ascending order.

    • To create a pivot table, select the data range and go to the 'Insert' tab in Excel.

    • Choose 'PivotTable' and select the location for the pivot table.

    • Drag the desired fields to the 'Rows' and 'Values' areas.

    • To sort the data in ascending order, click on the drop-down arrow next to the field name in the pivot table and select 'Sort A to Z'.

  • Answered by AI
  • Q2. Use lookup with the product based given data and find the needed data
  • Ans. 

    Using lookup with product-based data to find the needed data.

    • Use a lookup function like VLOOKUP or INDEX/MATCH to search for the needed data

    • Identify the key or unique identifier to match the data

    • Specify the range or table where the data is located

    • Retrieve the desired data based on the lookup value

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - please be ready with your resume, and work on each and every line.
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed before Nov 2023. There were 2 interview rounds.

Round 1 - HR 

(1 Question)

  • Q1. Tell me about yourself
Round 2 - One-on-one 

(1 Question)

  • Q1. Why do you think you are suitable for this job?
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Basic questions based on Sql

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well for SQL
Interview experience
1
Bad
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Company Website and was interviewed in Jun 2023. 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 

Myathari Manikyam I'm from Algole mandal Zaheerabad district Sangareddy

Round 3 - One-on-one 

(2 Questions)

  • Q1. Computer knowledge like Ms office and tally
  • Q2. What about your family and education
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Referral and was interviewed before Jul 2023. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. SQL basics on window function,.agg function and with data tables
  • Q2. Behavioural round

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

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
BigBasket Interview Questions
3.9
 • 359 Interviews
PolicyBazaar Interview Questions
3.6
 • 357 Interviews
JustDial Interview Questions
3.5
 • 329 Interviews
Info Edge Interview Questions
3.9
 • 317 Interviews
Zomato Interview Questions
3.8
 • 312 Interviews
Myntra Interview Questions
4.0
 • 215 Interviews
Naukri Interview Questions
4.0
 • 185 Interviews
Uber Interview Questions
4.2
 • 150 Interviews
View all
Flipkart Data Engineer 2 Salary
based on 7 salaries
₹15 L/yr - ₹50 L/yr
32% 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.9k salaries
unlock blur

₹1.8 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 - ₹21 L/yr

Executive
1.3k salaries
unlock blur

₹1.2 L/yr - ₹7 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