TP Southern Odisha Distribution Lead Engineer Interview Questions and Answers

Q1. Briefly explain about end to end process of operations in Flipkart warehouse from inbound from FC to outbound at sorting centre
Ans. 
The end-to-end process of operations in Flipkart warehouse involves receiving products from fulfillment centers, storing them, and preparing them for shipment to sorting centers.
• Receiving products from fulfillment centers

• Sorting and storing products in the warehouse

• Picking and packing products for outbound shipment to sorting centers

• Loading products onto trucks for transportation to sorting centers
Answered by AI
Add your answer
Q2. Explain about inventory management, reverse logistics
Ans. 
Inventory management involves overseeing the flow of goods from manufacturers to warehouses to retailers, while reverse logistics deals with the return of goods from customers back to the manufacturer or retailer.
• Inventory management focuses on optimizing the flow of goods to ensure efficient supply chain operations.

• It involves forecasting demand, ordering and replenishing stock, and monitoring inventory levels.

• Reverse...read more
Answered by AI
Add your answer

Q1. About operations processing knowledge
Add your answer
Q2. Salary discussion, joining date, company overview
Add your answer

Sql query error validation and analytics querying for test case

Q1. Ab testing experiment based aptitude
Add your answer
Q2. Sql query to find longest streak of orders by customer
Ans. 
Use SQL query to find longest streak of orders by customer
• Use window functions like ROW_NUMBER() to assign a sequential number to each order for each customer

• Partition the data by customer and order the rows by order date

• Calculate the difference between the sequential numbers to identify streaks of consecutive orders

• Select the maximum streak length for each customer
Answered by AI
Add your answer

Q1. Basic People management questions
Add your answer

Q1. Behaviour question
Add your answer

Q1. When you have pressure to your senior then how you can handle situation?
Ans. First I will saying sorry sir, then after I will asking about work problem very politely then after I will observe self all situations, in between I have any plan then I will discussed to senior. How we can resolve that work pressure.
Answered by Prashant Sharma
Add your answer
Q2. If there is an emergency problem at your home and you are being called by the company after a few days of the emergency problem , before you go to your home and after the call. What are your responsibiliti...read more
Ans. First of all I will hand over the work and responsibility to my colleague and I will saying if you have any problems then you can call me anytime . After gone home I will have active my cellphone anytime and giving respond the company call. If any emergency in company then for reaching in the company I will doing early resolve my home situations.
Answered by Prashant Sharma
Add your answer

Basic coding like oops design patterns

Q1. Salary expectations
Add your answer
Q2. Notice period previously company marking
Add your answer