Flipkart Data Analyst INTERVIEW Questions

Established in 2007, Flipkart, an e-commerce company, initiated its sales journey by offering online books. Over the years, it has expanded its product range to encompass over 100 million items across 120+ categories. With a user base exceeding 120,000 registered users, Flipkart achieved a significant milestone in 2016 by becoming the first Indian app to surpass 50 million downloads.

Skills Required for Data Analyst Role

Technical Skills:

• Proficiency in Python, R, or any programming language with a strong foundation in Data Structures and Algorithms.
• Acquired analytical skills and a willingness to learn Data Analytics.
• Familiarity with the Software Development Life Cycle (SDLC) and a solid understanding of Structures and Database Management Systems (DBMS).
• Expertise in working with Excel, including proficiency in Macros.
• In-depth knowledge of Power Bi and QlikView.
• Familiarity with Data Warehousing & Mining.
• Hands-on experience with Microsoft Word and Microsoft PowerPoint.
• Expertise in data modeling using Entity Relationship (ER).

Behavioral Skills:

• A collaborative team player.
• Strong communication skills with fluency in written and verbal English.
• Logical thinking ability.
• Capable of handling multiple tasks simultaneously.
• Strong verbal and presentation skills.

Interview Process

Interviews at Flipkart may differ based on the role and team; however, Data Analyst interviews generally follow a standardized process covering specific question topics.

1. Aptitude Test Round – Basic logical and quantitative aptitude test
2. Technical Round – Questions will be asked from SQL, Python, Excel questions, power BI, also few will be asked related to regression, hypothesis.
3. Technical Round – DI, Probability, Statistics, Time & Work
4. Case Study Round – Case study based on your experience.
5. Hiring Manager Round – Personal & Cultural Fit

Questions Asked

• Aptitude Test Round Questions-

1. The length of a rectangle is increased by 25% and its breadth is decreased by 20%. What is the effect on its area?
2. Three men start together to travel the same way around a circular track of 11 kilometres in circumference. Their speeds are 4, 5 and 8 kilometres per hour respectively. When will they meet at a starting point?
3. An order was placed for the supply of a carpet whose breadth was 6 m and length was 1.44 times the breadth. What be the cost of a carpet whose length and breadth are 40% more and 25% more respectively than the first carpet. Given that the ratio of carpet is Rs. 45 per sq m?

• Technical Round Questions-

1. A can do a work in 15 days and B in 20 days. If they work on it together for 4 days, then the fraction of the work that is left is?
2. Data Interpretation – A bar graph was given and we were asked to solve some question by looking into bar graph
3. What is the ratio of the total sales of branch B2 for both years to the total sales of branch B4 for both years?
4. Total sales of branch B6 for both the years is what percent of the total sales of branches B3 for both the years?
5. Project – Brief discussion about the project with some basic question related to project.
6. What is Excel Array Formula?
7. The different classes of relations created by the technique for preventing modification anomalies are called?
8. When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a?
9. 2 ways to extract unique values in excel
10. How to concatenate two string.
11. How joins the two tables.
12. what are the types of SQL command.
13. What is pivot table in SQL.
14. what is variable in python
15. Difference between list and tuple.

• Hiring Manager Round Questions-

1. Can you describe a time when you needed to balance multiple projects?
2. what are your salary expectations?
3. What are your projects related to job role you have applied?
4. Why do you want to join Flipkart?

The Data Monk services

We are well known for our interview books and have 70+ e-book across Amazon and The Data Monk e-shop page . Following are best-seller combo packs and services that we are providing as of now

1. YouTube channel covering all the interview-related important topics in SQL, Python, MS Excel, Machine Learning Algorithm, Statistics, and Direct Interview Questions
   Link – The Data Monk Youtube Channel
   
2. Website – ~2000 completed solved Interview questions in SQL, Python, ML, and Case Study
   Link – The Data Monk website
   
3. E-book shop – We have 70+ e-books available on our website and 3 bundles covering 2000+ solved interview questions. Do check it out
   Link – The Data E-shop Page
4. Instagram Page – It covers only Most asked Questions and concepts (100+ posts). We have 100+ most asked interview topics explained in simple terms
   Link – The Data Monk Instagram page
5. Mock Interviews/Career Guidance/Mentorship/Resume Making
   Book a slot on Top Mate

The Data Monk e-books

We know that each domain requires a different type of preparation, so we have divided our books in the same way:

1. 2200 Interview Questions to become Full Stack Analytics Professional – 2200 Most Asked Interview Questions
2.Data Scientist and Machine Learning Engineer -> 23 e-books covering all the ML Algorithms Interview Questions
3. 30 Days Analytics Course – Most Asked Interview Questions from 30 crucial topics

You can check out all the other e-books on our e-shop page – Do not miss it

For any information related to courses or e-books, please send an email to nitinkamal132@gmail.com