Airtel X- Labs 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. Round 1 was a telephonic interview where they asked about my background, skills, and motivations for applying.
Add your answer
Q2. Why did you apply for this field
Add your answer

Q1. What is your experience with leading a team in the work process?
Add your answer
Q2. Very well and excellent
Add your answer

Q1. Interview take by department head
Add your answer

Q1. Inventory control
Add your answer

Q1. Tell me about your current role and responsibilities
Ans. 
I am currently working as a Senior Software Engineer, leading a team of developers in designing and implementing software solutions.
• Leading a team of developers in designing and implementing software solutions

• Collaborating with stakeholders to gather requirements and define project scope

• Mentoring junior team members and providing technical guidance

• Conducting code reviews and ensuring code quality and best practices are
Answered by AI
Add your answer