Flipkart Interview Questions, Process, and Tips

Q1. What is SCM, explain inventory planning.
Ans. 
SCM stands for Supply Chain Management. Inventory planning involves forecasting demand, determining optimal inventory levels, and managing stock levels.
• SCM involves the coordination of all activities involved in sourcing, procurement, production, and logistics.

• Inventory planning includes forecasting demand based on historical data, market trends, and customer preferences.

• Determining optimal inventory levels involves ba...read more
Answered by AI
Add your answer
Q2. What is use of SQL in data analytics.
Ans. 
SQL is used in data analytics to query, manipulate, and analyze data stored in databases.
• SQL is used to retrieve data from databases using queries.

• It can be used to filter, sort, and aggregate data for analysis.

• SQL can also be used to join multiple tables to combine data from different sources.

• Common SQL functions like SUM, AVG, COUNT, etc. are used in data analytics.

• Example: SELECT * FROM sales_data WHERE date BETWEEN
Answered by AI
Add your answer
Q3. SQL Joins, Functions, examples and questions on it.
Add your answer
Q4. Questions on Predictive Analytics.
Add your answer

Q1. What's the hurdles that you've faced, and how did you overcome that?
Add your answer
Q2. What was your role in the previous organisation?
Add your answer
Q3. How can you manage supply and demand and plan accordingly.
Ans. 
Managing supply and demand involves forecasting, monitoring inventory levels, adjusting production schedules, and collaborating with sales and marketing teams.
• Forecast demand based on historical data, market trends, and customer feedback.

• Monitor inventory levels to ensure sufficient stock to meet demand without excess inventory.

• Adjust production schedules based on demand forecasts and inventory levels.

• Collaborate with ...read more
Answered by AI
Add your answer

Q1. How well did you understand this role?
Add your answer
Q2. Why did you leave your core field and change into analytics?
Add your answer

Q1. Previous experiences
Add your answer
Q2. Best projects done
Ans. 
One of the best projects I have completed was implementing a new inventory management system that increased efficiency by 30%.
• Implemented new inventory management system

• Increased efficiency by 30%

• Streamlined processes and reduced errors

• Received positive feedback from team members and upper management
Answered by AI
Add your answer

Q1. Manpower caluculation
Add your answer

Q1. General discussion
Add your answer

Mathematics and general aptitude.

Q1. Can you provide an overview of the projects you have worked on?
Add your answer
Q2. Explain about projects?
Ans. 
Projects are specific tasks or initiatives undertaken to achieve a particular goal or objective.
• Projects have defined start and end dates.

• They require resources such as time, money, and manpower.

• Projects are usually unique and temporary in nature.

• They have specific deliverables or outcomes.

• Examples: launching a new product, implementing a new system, organizing an event.
Answered by AI
Add your answer
Q3. Normal HR and Situational based questions
Add your answer

Q1. What real-world problem-solving skills do you believe you may be lacking for this position?
Add your answer

Aptitude refers to a natural ability or talent for a specific skill or activity. It's often described as an innate capacity or potential to learn and perform certain tasks efficiently. Aptitude can be related to various areas like:
* Academic subjects: Math, science, language arts, etc.
* Physical abilities: Sports, dance, music, etc.
* Cognitive skills: Problem-solving, critical thinking, creativity, etc.
* Social skills: Communication, teamwork, leadership, etc.
Aptitude tests are often used to assess a person's potential in a particular field. These tests measure various cognitive abilities, such as verbal reasoning, numerical reasoning, and spatial reasoning.
It's important to note that while aptitude can be a strong predictor of success, it's not the sole determinant. Hard work, dedication, and continuous learning are also crucial factors for achieving one's goals.

A coding test assesses programming skills by solving problems.

Test was Moderate in difficulty

Q1. When you order something on Flipkart how do you think it moves and reaches you?
Ans. 
Products ordered on Flipkart are processed, packed, and shipped from warehouses to delivery hubs, then delivered to customers.
• Order is received and processed at Flipkart's warehouse

• Product is picked, packed, and labeled for shipping

• Shipment is sent to a delivery hub for sorting and distribution

• Delivery partner picks up the package and delivers it to the customer

• Customer receives the product and confirms delivery
Answered by AI
Add your answer
Q2. Why sometimes orders automatically gets cancelled on Flipkart?
Ans. 
Orders on Flipkart may get automatically cancelled due to various reasons such as payment failure, stock unavailability, or seller cancellation.
• Payment failure: If the payment for the order is not successful, the order may get cancelled.

• Stock unavailability: If the item ordered is out of stock, the order may get cancelled.

• Seller cancellation: Sometimes sellers may cancel orders due to various reasons.

• Technical issues: ...read more
Answered by AI
Add your answer
Q3. Rest based on resume
Add your answer

Q1. Tell me about your problem solving skills?
Ans. 
I have strong problem solving skills with a track record of successfully resolving complex issues.
• I approach problems analytically, breaking them down into smaller components to identify root causes.

• I am skilled at thinking creatively and outside the box to come up with innovative solutions.

• I have experience in implementing and evaluating solutions to ensure effectiveness.

• I am adept at collaborating with team members t...read more
Answered by AI
Add your answer
Q2. Why should we hire you?
Add your answer
Q3. Examples for analytical thinking?
Ans. 
Analytical thinking involves breaking down complex problems into smaller components and using logic to solve them.
• Identifying key issues or problems

• Gathering relevant data and information

• Analyzing data to draw conclusions

• Developing solutions based on findings

• Testing and refining solutions

• Thinking critically and objectively
Answered by AI
Add your answer

Q1. Question on Marginal costing
Add your answer
Q2. Question of Standard costing
Add your answer

Q1. What work do you do
Add your answer
Q2. What is your day to day working looks like
Add your answer