Flipkart
500+ SpadeWorx Software Services Interview Questions and Answers
Q101. Given an array of integers, find Pythagorean triplets. i.e. find a,b and c which satisfies a^2 + b^2 = c^2. Integers could be positive or negative
Find Pythagorean triplets in an array of integers.
Loop through the array and pick two numbers at a time.
Calculate the sum of squares of the two numbers.
Check if the sum is a perfect square.
If yes, then it is a Pythagorean triplet.
Repeat until all possible combinations are checked.
Q102. How many man power does it take to unload 32ft veh.
It depends on the weight of the vehicle and the items being unloaded.
The weight of the vehicle and the items being unloaded will determine the number of manpower needed.
If the items are heavy, it may require more manpower.
If the items are fragile, it may require more manpower to ensure safe unloading.
The type of equipment available for unloading may also affect the number of manpower needed.
It is important to assess the situation and determine the appropriate number of manpow...read more
Q103. What is data entry What is excel
Data entry is the process of entering data into a computer system or database. Excel is a spreadsheet software used for data analysis and management.
Data entry involves inputting information into a computer system or database
Excel is a spreadsheet software used for organizing, analyzing, and manipulating data
Excel can perform calculations, create charts and graphs, and automate tasks
Examples of data entry tasks include entering customer information, inventory data, or financi...read more
Q104. What you know about FTL, PTL movements?
FTL and PTL movements refer to Full Truckload and Partial Truckload movements in logistics.
FTL stands for Full Truckload, which refers to the transportation of goods that fill an entire truck.
PTL stands for Partial Truckload, which refers to the transportation of goods that do not require a full truck but still occupy a significant portion of it.
FTL movements are typically used when the shipper has enough goods to fill an entire truck, ensuring faster transit times and reduce...read more
Q105. Given a BST, find the node which contains the value which is equal to or greater than the input value?
Find node in BST with value equal to or greater than input value.
Start at root node
If input value is less than current node value, move to left child
If input value is greater than or equal to current node value, move to right child
Repeat until node with desired value is found or null is reached
Q106. What is the Bias Variance trade-off and name some models with high bias and low variance?
Bias-Variance trade-off is the balance between overfitting and underfitting. High bias models are simple but inaccurate, low variance models are complex but overfit.
Bias-Variance trade-off is a fundamental concept in machine learning.
High bias models are simple and have low variance, but are inaccurate.
Low bias models are complex and have high variance, but can overfit the data.
Examples of high bias models are linear regression and decision trees with few nodes.
Examples of lo...read more
Q107. How to sell different categories in flipkart
To sell different categories in Flipkart, one needs to understand the target audience and their needs.
Identify the target audience for each category
Create targeted marketing campaigns for each category
Offer discounts and promotions to attract customers
Provide detailed product descriptions and reviews
Ensure timely delivery and excellent customer service
Examples: Tech-savvy customers may be interested in electronics, while fashion-conscious customers may be interested in clothi...read more
Q108. Implement a phone book. You can search either by name or phone number. You can search by prefix also. Write whole code with proper syntax
Implement a phone book with search by name or phone number and prefix.
Create an array of strings to store contacts
Implement a function to add contacts to the array
Implement a function to search by name or phone number
Implement a function to search by prefix
Use regular expressions to match prefixes
Q109. What if any products services or features are we missing ?
We are missing a mobile app for easy access on the go.
Mobile app for convenient access
Enhanced user experience with push notifications
Ability to chat on the move
Seamless integration with mobile devices
Offline access to previous chats
Q110. How many prepare the parcel for dispatch in one hrs from one person
The number of parcels prepared for dispatch in one hour by one person.
The number of parcels prepared depends on various factors such as size, complexity, and experience of the person.
On average, a skilled person can prepare around 20-30 parcels per hour.
However, this number can vary significantly based on the specific circumstances.
Factors like the availability of tools, packaging materials, and the efficiency of the process also impact the productivity.
It is important to con...read more
Zombie process is a terminated process that has completed execution but still has an entry in the process table. Orphan process is a process whose parent process has terminated.
Zombie process is created when a child process completes execution but its parent process has not yet read its exit status.
Zombie processes consume system resources and should be cleaned up by the parent process using wait() system call.
Orphan process is a process whose parent process has terminated be...read more
Q112. WAP to find a continuous subset whose sum is divisible by 7. We are given a array of number (-ve and +ve). calculate the complexity of your algorithm?
WAP to find a continuous subset divisible by 7 from an array of numbers. Calculate algorithm complexity.
Iterate through the array and calculate the prefix sum modulo 7 at each index.
Store the prefix sum modulo 7 in a hash table with the index as the value.
If a prefix sum modulo 7 is already in the hash table, the subarray between the two indices has a sum divisible by 7.
Time complexity is O(n) and space complexity is O(n).
Q113. Given a BST, how would you return the kth smallest element. Cover all the corner cases with time complexity logn?
Returning kth smallest element in a BST with time complexity logn.
Perform in-order traversal and keep track of count until kth element is reached
If kth element is found, return it
If kth element is not found, continue traversal
If traversal is complete and kth element is not found, return null
Time complexity is logn as we only traverse the height of the tree
Q114. Explain how you see E-commerce in India in next few years? What do you think are the problems?
E-commerce in India is expected to grow rapidly in the next few years, but there are challenges to overcome.
E-commerce market in India is expected to reach $200 billion by 2026.
Increased internet penetration and smartphone usage are driving growth.
Logistics and infrastructure challenges remain a major obstacle.
Competition from established players like Amazon and Flipkart is intense.
Regulatory issues such as data privacy and taxation need to be addressed.
Consumer trust and sec...read more
Q115. Which is the fastet method to sort an almost sorted array: quick sort,bubble sort,merge sort,shell sort
The fastest method to sort an almost sorted array is shell sort.
Shell sort has a time complexity of O(n log n) which is faster than bubble sort and insertion sort.
Quick sort and merge sort have a time complexity of O(n log n) but they are not optimized for almost sorted arrays.
Shell sort works by comparing elements that are far apart first and then gradually reducing the gap between them.
Example: If the array is [1, 3, 2, 4, 5] and it is almost sorted, shell sort will first c...read more
Q116. How will I predict the weekly demand of air conditioners at SKU level for every Pin code of the country.
To predict weekly demand of air conditioners at SKU level for every Pin code of the country, we can use historical sales data, weather forecasts, and demographic information.
Analyze historical sales data to identify trends and patterns
Consider weather forecasts to anticipate demand during hot weather
Use demographic information to understand consumer behavior in different regions
Utilize machine learning algorithms to improve accuracy of predictions
Regularly update and adjust p...read more
Q117. How you will make addition in MS excel sheet
To add in MS Excel sheet, select the cell where you want to add, type the equal sign, then type the formula or value to be added.
Select the cell where you want to add the value
Type the equal sign (=) to start the formula
Type the formula or value to be added
Press enter to complete the addition
Example: =5+3 will add 5 and 3 to give a result of 8
Q118. Given a list of stars and their distances from the earth.Find an efficient solution to find the k closest stars to earth?
Efficient solution to find k closest stars to earth from a list of stars and their distances.
Use a priority queue to store the distances of stars from earth.
Iterate through the list of stars and add their distances to the priority queue.
Pop k elements from the priority queue to get the k closest stars to earth.
Q119. What do kno about the BPO
BPO stands for Business Process Outsourcing. It involves contracting a third-party service provider to handle specific business processes.
BPO services can include customer service, technical support, data entry, and accounting.
Companies outsource to BPOs to save costs and improve efficiency.
BPOs are often located in countries with lower labor costs, such as India and the Philippines.
BPOs can operate onshore, nearshore, or offshore depending on the location of the client and t...read more
Q120. If Flipkart wants to enter into selling Jewelry what should it do?
Flipkart should conduct market research, partner with trusted jewelry brands, ensure quality control, and provide a seamless online shopping experience.
Conduct market research to understand the demand for jewelry online
Partner with trusted jewelry brands to offer a wide range of products
Ensure quality control by verifying the authenticity and purity of the jewelry
Provide a seamless online shopping experience with detailed product descriptions, high-quality images, and secure ...read more
Q121. What will you do when the vehicle has been break down in other city?
Q122. How do you find if a string is a palindrome or not?
To check if a string is a palindrome, compare the first and last characters, then move towards the center.
Remove all non-alphanumeric characters and convert to lowercase
Use two pointers, one starting from the beginning and the other from the end
Compare the characters at both pointers, move towards the center until they meet
If all characters match, the string is a palindrome
Q123. 1. Write a function which takes a callback function as argument and executed the callback function after 20 seconds. The callback function shouldn't get changed by calling the function within 20 seconds
Create a function that executes a callback function after 20 seconds without changing it within that time frame.
Create a function that takes a callback function as an argument
Use setTimeout to delay the execution of the callback function by 20 seconds
Ensure that the callback function remains unchanged during the 20-second delay
Q124. Given a 2-dimensional array of integers, find the value 1 in the array, and set all those rows, and columns to 1, which contains one of the values as 1
Given a 2D array of integers, set rows and columns to 1 if they contain 1.
Iterate through the array to find the index of 1
Use two arrays to keep track of rows and columns with 1
Iterate through the rows and columns arrays to set values to 1
Q125. Given s string, Find max size of a sub-string, in which no duplicate chars present?
Find max size of a sub-string with no duplicate characters in a given string.
Use a sliding window approach with two pointers.
Maintain a hash set to keep track of unique characters.
Update the maximum length of the substring as you iterate through the string.
Q126. what is an interpreter? An interpreter is a computer program that directly executes machine code instructions and runs java programme.
An interpreter is a computer program that directly executes source code instructions.
Interpreters translate and execute code line by line, rather than compiling the entire program first.
They are commonly used in scripting languages like Python and JavaScript.
Interpreters are generally slower than compilers, but offer more flexibility and ease of use.
Examples of popular interpreters include the Python interpreter and the Node.js JavaScript interpreter.
Q127. Implement LRU cache. Write a code for this. LRU cache supports 3 operations, put(key, value) get(key) remove(key)
Implement LRU cache with put, get, and remove operations.
LRU stands for Least Recently Used.
The cache should have a maximum capacity.
When the cache is full, the least recently used item should be removed.
When an item is accessed, it should be moved to the front of the cache.
Use a doubly linked list and a hash map to implement the cache efficiently.
Q128. The products that the customer ordered did not happen, but the second product got delivered, what would you do?
I would apologize to the customer and offer to rectify the situation by either refunding or delivering the first product.
Apologize to the customer for the inconvenience caused
Offer to rectify the situation by either refunding or delivering the first product
Ensure that the customer is satisfied with the resolution
Take steps to prevent similar issues from happening in the future
Q129. When going for delivery, how should the customer deliver the delivery product?
The customer should provide clear delivery instructions and ensure someone is available to receive the product.
Customers should provide accurate delivery address and contact information.
They should also specify any specific delivery instructions, such as leaving the package at a specific location.
Customers should ensure someone is available to receive the product to avoid missed deliveries.
If the customer is not available, they should provide an alternative delivery location ...read more
Q130. what is Encapsulation ? it is a mechanism of combining the data and code in to a single unit.
Encapsulation is combining data and code into a single unit.
Encapsulation is a fundamental concept in object-oriented programming.
It helps to hide the implementation details of an object from the outside world.
It provides data security by preventing unauthorized access to the data.
It allows for better maintainability and flexibility of code.
For example, a class in Java encapsulates data and methods that operate on that data.
Q131. What is route planning or optimization?
Route planning or optimization is the process of finding the most efficient route for a given set of destinations.
It involves analyzing various factors such as distance, traffic, and time constraints.
The goal is to minimize travel time, distance, and cost while maximizing efficiency.
Examples include optimizing delivery routes for a logistics company or planning a road trip with multiple stops.
Route planning software and algorithms are commonly used to automate the process and...read more
Q132. Given an array find any three numbers which sum to zero. Give the best algorithm?
Algorithm to find any three numbers in an array that sum to zero.
Sort the array in ascending order.
Loop through the array and fix the first number.
Use two pointers to find the other two numbers that sum to the negative of the fixed number.
If found, return the three numbers.
If not found, move to the next number and repeat the process.
Time complexity: O(n^2)
Q133. 20%of 50%of x=147 what is the value of x?
Solving for x in an equation involving percentages
Convert 50% to decimal form (0.5)
Multiply 0.5 by x to get 0.5x
Multiply 0.2 by 0.5x to get 0.1x
Set 0.1x equal to 147 and solve for x
Q134. HOW CLOSELY HAVE YOU WORKED WITH SUPPLY CHAIN OPERATIONS AND WHAT EXACTLY WOULD YOU DO TO REDUCE PICKING TIME IN THE WAREHOUSE?
I have closely worked with supply chain operations and would implement process improvements to reduce picking time in the warehouse.
I have collaborated with supply chain teams to optimize inventory management and streamline processes.
Implemented barcode scanning technology to improve accuracy and efficiency in picking orders.
Analyzed data to identify bottlenecks in the picking process and implemented solutions such as rearranging warehouse layout or adjusting picking routes.
T...read more
Q135. What is the short cut key copy?
The shortcut key for copy is Ctrl+C.
The shortcut key for copy is commonly used in various applications.
In Windows, the shortcut key for copy is Ctrl+C.
In Mac, the shortcut key for copy is Command+C.
Q136. If the vehicle sta is 6:00 AM it has been fixed from the management as per the KM, but driver can change the time that's why the driver can manage actual arrival timings.
Q137. I want to sell TV sets in my market. How do I go about it?
To sell TV sets in the market, research the target audience, identify competitors, set competitive prices, and create effective marketing strategies.
Conduct market research to identify the target audience and their preferences
Identify competitors and their pricing strategies
Set competitive prices for the TV sets
Create effective marketing strategies such as advertising, promotions, and social media campaigns
Establish partnerships with local electronics stores to increase visib...read more
Q138. Design a warehouse storage space for a category of products.
Designing a warehouse storage space for a category of products.
Identify the category of products and their storage requirements
Determine the size and layout of the warehouse
Choose appropriate storage systems such as pallet racking, shelving, or mezzanine floors
Consider factors such as accessibility, safety, and efficiency
Implement a system for inventory management and tracking
Design a cab booking system for efficient and convenient service.
Implement a user-friendly mobile app and website for booking cabs.
Include features like real-time tracking, fare estimation, and driver ratings.
Integrate payment options for seamless transactions.
Develop a robust backend system to manage bookings, drivers, and customer support.
Utilize algorithms for efficient route planning and matching drivers with passengers.
Q140. What is a hash table? Explain how they work (hash function and buckets)?
A hash table is a data structure that stores key-value pairs and uses a hash function to map keys to buckets.
Hash function takes a key and returns an index to a bucket
Collisions occur when multiple keys map to the same bucket
Collision resolution techniques include chaining and open addressing
Example: Dictionary in Python uses hash tables to store key-value pairs
Q141. If a person is working 129 jobs/ hr. To complete 9000 jobs. How many people are required to cover it.
Q142. Describe your SIP in detail with the calculations involved.
SIP is a systematic investment plan that allows investors to invest a fixed amount at regular intervals.
SIP involves investing a fixed amount at regular intervals, usually monthly
The investment is made in a mutual fund or other investment vehicle
The amount invested is determined by the investor's financial goals and risk tolerance
Calculations involve determining the expected return on investment and the time horizon for the investment
SIP can help investors achieve their finan...read more
Thrashing in operating systems occurs when the system is spending more time swapping data between memory and disk than actually executing tasks.
Occurs when the system is constantly swapping data between memory and disk
Causes a significant decrease in performance as the system is unable to effectively execute tasks
Usually happens when the system is overloaded with too many processes or lacks sufficient memory
Can be mitigated by optimizing memory usage or reducing the number of...read more
Q144. What is time motion study, why it's necessary tool in big HUB.
Time motion study is a method of analyzing work processes to improve efficiency and productivity.
It involves breaking down tasks into smaller components and measuring the time taken for each component.
The data collected is used to identify areas for improvement and to develop more efficient work processes.
For example, in a big HUB, time motion study can be used to optimize the flow of goods and reduce the time taken for processing and handling.
It can also help to identify bot...read more
Q145. Tell us about your home state? How many types of ACs? How to start a manual DG set when power goes off? What is good neutral? How much voltage is needed to power up a 320KV DG set? What to do when PF goes down?
The home state is not specified. The types of ACs depend on the brand and model. To start a manual DG set, follow the instructions in the manual. Good neutral is a stable and balanced neutral wire. The voltage needed to power up a 320KV DG set depends on the specific model. When PF goes down, take measures to improve it.
Types of ACs depend on brand and model
Follow manual instructions to start a manual DG set
Good neutral is a stable and balanced neutral wire
Voltage needed to p...read more
Q146. Describe the architecture for a product that you’ve worked on? What type of replication were you using (MySQL DB)?
I worked on a product with a microservices architecture using MySQL DB for replication.
The product had a microservices architecture with each service having its own database.
We used MySQL DB for replication to ensure data consistency across all services.
We also implemented load balancing and caching to improve performance.
The architecture allowed for easy scaling and maintenance of the product.
Examples of services included user management, payment processing, and content deli...read more
Q147. Given two unsorted arrays A and B in which B can accommodate in AHow will you merge the two arrays.Time complexity and space complexity were also given importance
Merge two unsorted arrays A and B into A efficiently with optimal time and space complexity.
Sort both arrays individually
Merge the two sorted arrays using a two-pointer approach
Time complexity: O((n+m)log(n+m)), Space complexity: O(1)
Example: A = [3, 1, 4], B = [2, 5], After merging: A = [1, 2, 3, 4, 5]
Q148. Price & Cost Structure if Flipkart rents heavy home appliances instead of selling. Where can it save money?
Renting heavy home appliances instead of selling - cost-saving measures for Flipkart
Reduced inventory costs as fewer appliances need to be purchased and stored
Lower transportation costs as appliances can be rented out from local warehouses instead of being shipped from a central location
Less need for after-sales service and support as appliances are returned after use
Potential for higher profit margins as rental fees can be set higher than the cost of purchasing and selling t...read more
Q149. What is the complexity of retrieving min element from a max heap
Retrieving min element from a max heap has a time complexity of O(log n).
The min element is always the leftmost leaf node in the last level of the heap.
To retrieve it, swap it with the last element in the heap and remove it.
Then, bubble down the new root to maintain the max heap property.
Examples: retrieving the smallest number in a priority queue implemented as a max heap.
Examples: retrieving the smallest element in a max heap of integers.
Q150. How to handle a hirated customer on call??
Handle a hirated customer on call
Stay calm and patient
Listen actively to their concerns
Empathize with their situation
Apologize for any inconvenience caused
Offer a solution or escalate to a higher authority if necessary
Follow up with the customer to ensure their issue is resolved
Q151. How do you find if given two linked lists intersect or not
To find if two linked lists intersect, traverse both lists and compare their tail nodes.
Traverse both linked lists and find their lengths
If the lengths are different, move the longer list's head pointer to the difference in length
Now traverse both lists and compare their nodes until a common node is found
If no common node is found, the lists do not intersect
Q152. How many months France will take to grow
It is not possible to determine the exact time it will take for France to grow.
Economic growth is influenced by various factors such as government policies, global economic conditions, and domestic market trends.
France's growth rate can vary from year to year depending on these factors.
Economists and analysts make predictions about future growth, but they are not always accurate.
It is important to consider both short-term and long-term trends when assessing a country's growth...read more
Q153. Implement next_permutation function (similar to what is in algorithm.h)
next_permutation function generates the next greater lexicographic permutation of a sequence
The function modifies the sequence to its next permutation if possible
If the sequence is already the largest permutation, it rearranges it to the smallest permutation
The function returns true if a next permutation exists, else false
The sequence must be sorted in non-descending order before calling the function
Q154. Factors to take into consideration if you want to set up a grocery shop
Factors to consider when setting up a grocery shop
Location: Choose a convenient and accessible location with high foot traffic
Target market: Identify the demographics and preferences of the local community
Competition: Analyze existing grocery stores in the area and differentiate your offerings
Suppliers: Establish relationships with reliable and cost-effective suppliers
Inventory management: Develop a system to track and manage inventory efficiently
Pricing strategy: Determine c...read more
Q155. Design a movie-booking app for elder people (someone who is not very tech-savvy and just started using smartphones).
A movie-booking app designed for elder people who are not tech-savvy.
Simple and intuitive user interface with large fonts and buttons.
Option to book tickets over the phone with customer support.
Ability to filter movies by genre and language.
Option to save favorite theaters and movies for easy access.
Integration with Google Maps for easy navigation to theaters.
Option to receive reminders for upcoming movies and showtimes.
Clear instructions and tutorials for first-time users.
Op...read more
Q156. Given a number, compute the nearest palindrome number. This palindrome number should be greater than given number
Compute the nearest palindrome number greater than given number.
Convert the given number to string and reverse it.
Add the reversed string to the original number and check if it's a palindrome.
If not, repeat the process until a palindrome is found.
If the original number is already a palindrome, add 1 to it and repeat the process.
Q157. What is your level of knowledge regarding First Mile and Last Mile logistics?
I have a strong understanding of First Mile and Last Mile logistics.
First Mile logistics involves the movement of goods from the point of origin to the transportation hub.
Last Mile logistics focuses on the delivery of goods from the hub to the final destination.
Efficient First Mile and Last Mile logistics are crucial for ensuring timely and cost-effective delivery.
Examples of First Mile logistics include pickup from suppliers or manufacturers, while Last Mile logistics involv...read more
Q158. How would you handle unexpected surges in sales volume and manage the associated manpower?
I would implement a flexible staffing plan, cross-train employees, and utilize technology to streamline processes.
Implement a flexible staffing plan to quickly adjust to surges in sales volume.
Cross-train employees to ensure that all team members can handle increased workload.
Utilize technology such as automated systems or software to streamline processes and increase efficiency.
Regularly review sales data and trends to anticipate potential surges and proactively adjust manpo...read more
Q159. Standard unloading time of 32ft veh.
Standard unloading time of 32ft veh is approximately 2-3 hours.
Factors affecting unloading time include type of cargo, loading equipment, and number of personnel.
For example, unloading a 32ft vehicle carrying loose cargo with a forklift and two personnel may take 2 hours.
However, unloading a 32ft vehicle carrying palletized cargo with a manual pallet jack and one personnel may take 3 hours.
Q160. -Explain what is cross docking?
Cross docking is a logistics strategy where products are directly transferred from inbound to outbound transportation without being stored.
Cross docking eliminates the need for storage and reduces handling time.
It involves receiving products, sorting them, and immediately loading them onto outbound vehicles.
This strategy improves efficiency, reduces inventory costs, and speeds up order fulfillment.
Example: In a retail cross docking scenario, products from different suppliers ...read more
Q161. Check whether given Binary Tree is a Binary Search Tree. Discuss various approaches?
Check if a Binary Tree is a Binary Search Tree
Inorder traversal of BST should be in ascending order
Check if left child is less than parent and right child is greater than parent
Recursively check left and right subtrees
Use min and max values to check if nodes are within valid range
Q162. Write a code to check if a tree is BST or not
Code to check if a tree is BST or not
Check if left subtree is BST
Check if right subtree is BST
Check if max value in left subtree is less than root
Check if min value in right subtree is greater than root
Q163. Write code to find sum of two numbers stored as linked list.(LSB at last node) and head of each list is given
Code to find sum of two numbers stored as linked list.
Traverse both lists simultaneously and add corresponding nodes
Keep track of carry and add it to next sum
Create a new node for each sum and move to next node
Q164. Are you interested in field sales?
Yes, I am interested in field sales.
I enjoy meeting new people and building relationships
I am comfortable with traveling and working independently
I have experience in conducting product demos and closing deals
I am motivated by achieving sales targets and growing business
For example, in my previous role as a sales representative, I consistently exceeded my monthly sales targets by 20% through effective field sales strategies.
Q165. Program to find the angle between the hands of a clock. Input- the time. Expected output- Angle in degrees
Program to find the angle between the hands of a clock given the time.
Calculate the angle of the hour hand from 12 o'clock position
Calculate the angle of the minute hand from 12 o'clock position
Calculate the absolute difference between the two angles
If the difference is greater than 180 degrees, subtract it from 360 degrees
Return the absolute value of the difference as the angle between the hands
Q166. What parameters will you use to decide the priorities in a feature backlog.
Prioritization of feature backlog based on parameters
Customer needs and feedback
Business goals and objectives
Technical feasibility and complexity
Market trends and competition
Impact on user experience and revenue
Cost and resources required
Risk and compliance
Dependencies and timelines
Value and ROI
Urgency and criticality
Q167. WHAT TECHNIQUE WOULD YOU USE TO REDUCE THE SCM OPERATIONS IN A WAREHOUSE?
Implementing lean principles such as 5S, Kanban, and Just-in-Time inventory management can help reduce SCM operations in a warehouse.
Implement 5S methodology to organize the warehouse and reduce waste
Utilize Kanban system to optimize inventory levels and streamline processes
Adopt Just-in-Time inventory management to minimize excess inventory and improve efficiency
Q168. What is your biggest fear? Is it that your feature will not be prioritized?
My biggest fear is not meeting customer needs
I prioritize customer feedback and needs in my feature development
I conduct thorough research and analysis to ensure customer satisfaction
I regularly communicate with customers to gather feedback and make improvements
I am open to constructive criticism and willing to make changes to meet customer needs
Q169. What is AOP of warehouse and How it is calculated? What is 5,S, Kaizen and lean culture, departmental process, roster management.. Technical question
Q170. How many ways a 4*n wall be filled with 4*1 sheets so that the wall ends uniformly
Q171. What do you do if engineering lead refuses to build a particular feature?
Collaborate with engineering lead to understand their concerns and find a solution together.
Listen to the engineering lead's concerns and try to understand their perspective.
Discuss the importance of the feature and how it aligns with the product roadmap.
Explore alternative solutions or compromises that could address the engineering lead's concerns.
If necessary, escalate the issue to higher management for resolution.
Ultimately, prioritize the feature based on its impact on th...read more
Indexing in databases is a technique used to improve the speed of data retrieval by creating a data structure that allows for quick lookups.
Indexes are created on columns in a database table to speed up the retrieval of rows that match a certain condition.
Types of indexes include B-tree, hash, and bitmap indexes.
Indexes can improve the performance of SELECT queries but may slow down INSERT, UPDATE, and DELETE operations.
Examples of indexing include creating an index on a 'use...read more
Q173. What do you think about e commerce?
E-commerce is a game-changer in the retail industry, providing convenience and accessibility to customers worldwide.
E-commerce has revolutionized the way people shop, making it easier and more convenient for customers to purchase products from anywhere in the world.
It has also opened up new opportunities for businesses to reach a wider audience and increase their sales.
Examples of successful e-commerce companies include Amazon, Alibaba, and eBay.
However, e-commerce also poses...read more
Q174. What tool , topology, Schema, workflow are going to be use in URL shorten system. Why you chose specific tool, schema and workflow.
The URL shorten system will use a distributed system topology with a consistent hashing algorithm, a NoSQL database schema, and a workflow involving API requests and redirects.
Distributed system topology for scalability and fault tolerance
Consistent hashing algorithm for load balancing and efficient lookup
NoSQL database schema for flexibility and fast read/write operations
Workflow involving API requests for shortening URLs and redirects for accessing original URLs
FCFS stands for First-Come, First-Served. It is a scheduling algorithm used in operating systems.
FCFS is a non-preemptive scheduling algorithm where the process that arrives first is executed first.
It is a simple and easy-to-understand scheduling algorithm.
Example: If processes P1, P2, and P3 arrive in that order, they will be executed in the same order - P1, P2, P3.
FCFS can lead to the problem of 'convoy effect' where short processes are stuck behind long processes.
Q176. How would I work with big, unorganised data
To work with big, unorganised data, I would first assess the data and then use tools like Excel, Python, or SQL to clean and analyze it.
Assess the data to understand its structure and identify any patterns or anomalies
Use tools like Excel, Python, or SQL to clean and organize the data
Apply data analysis techniques to gain insights and draw conclusions
Consider using machine learning algorithms to automate the process
Document the process and findings for future reference
Q177. Guess the number of vehicles on the Chennai roads between 5 to 6
It is impossible to accurately guess the number of vehicles on Chennai roads between 5 to 6 without any data.
The number of vehicles on the road can vary depending on the day, time, and weather conditions.
Factors such as rush hour traffic, accidents, and road closures can also affect the number of vehicles on the road.
Without any data or context, it is impossible to make an accurate guess.
However, we can estimate based on previous data or conduct a survey to gather more inform...read more
Q178. Given a large list of numbers in a file and a very small amount of memory, sort the file
Sort a large file of numbers with limited memory
Use external sorting algorithms like merge sort or quick sort
Divide the file into smaller chunks that can fit into memory
Sort each chunk and merge them together using a priority queue
Consider using disk-based sorting techniques like replacement selection
Optimize I/O operations to minimize disk access
Q179. What will you tell the customer to take the products on the EMI option?
I would explain the benefits of EMI option and how it can make the purchase more affordable for the customer.
Explain the concept of EMI and how it works
Highlight the affordability factor of EMI option
Mention any special offers or discounts available on EMI purchases
Assure the customer of hassle-free EMI process
Provide information on the required documents and eligibility criteria for EMI option
Q180. Tell me how will an automobile company launch a car online?
An automobile company can launch a car online through various digital marketing strategies.
Create a dedicated landing page for the car launch
Use social media platforms to create buzz and promote the launch
Organize a virtual launch event and invite influencers and media personnel
Offer exclusive online booking and test drive options
Create engaging and informative video content showcasing the car's features and benefits
Q181. WHAT FACTORS YOU CONSIDER IN MARKING THE PRICE OF TELIVISION PRODUCT
Factors considered in pricing television products
Cost of production
Market demand
Competition
Brand value
Features and technology
Distribution and logistics
Profit margin
Target audience
Economic conditions
Q182. How will you minimise cost in a trip?
Minimise trip cost by planning ahead and being flexible.
Plan ahead and book flights and accommodations early to get better deals.
Consider using public transportation instead of taxis or rental cars.
Pack light to avoid baggage fees.
Be flexible with travel dates to take advantage of cheaper rates.
Look for free activities and attractions.
Consider staying in budget accommodations like hostels or Airbnb.
Bring your own snacks and drinks instead of buying them at tourist spots.
Avoid...read more
Q183. The customer has a problem related to Delveray, how will you solve it?
I will listen to the customer's problem, gather relevant information, and provide a solution that meets their needs.
Listen actively to the customer's problem
Ask relevant questions to gather more information
Provide a solution that meets the customer's needs
Follow up with the customer to ensure their satisfaction
Q184. What r the pros and cons of e commerce?
E-commerce has revolutionized the way we shop, but it also has its drawbacks.
Pros: convenience, wider selection, competitive pricing, accessibility
Cons: lack of personal touch, security concerns, potential for fraud, reliance on technology
Example: Amazon offers a vast selection of products at competitive prices, but customers may not receive the same level of personalized service as they would in a physical store.
Example: E-commerce sites are vulnerable to cyber attacks and d...read more
Q185. How to find the fault in an underground electrical cable which is buried ?
To find a fault in an underground electrical cable, various methods can be used such as cable tracing, insulation resistance testing, and thermal imaging.
Use cable tracing equipment to locate the path of the cable and identify any breaks or faults.
Perform insulation resistance testing to check for any leakage or faults in the cable insulation.
Utilize thermal imaging cameras to detect any abnormal heat patterns along the cable, indicating potential faults.
Consider using ground...read more
Q186. What is the budget breakup between Civil , & MEP in a typical infra project?
The budget breakup between Civil and MEP in a typical infra project varies depending on the project scope and requirements.
The budget allocation for Civil and MEP (Mechanical, Electrical, and Plumbing) works in an infrastructure project is typically determined based on the project's design and specifications.
In general, the Civil works budget includes costs for site preparation, earthworks, foundations, structural elements, roads, and landscaping.
The MEP works budget includes...read more
Q187. What security steps you will take when there is a dehiring in the facility?
We will take several security steps to ensure the safety of the facility after dehiring.
Immediately revoke access to all systems and facilities for the dehired employee.
Conduct a security audit to identify any potential vulnerabilities.
Change all passwords and access codes.
Notify security personnel and provide them with a description of the dehired employee.
Monitor access logs and security cameras for any suspicious activity.
Implement additional security measures if necessary...read more
Q188. Do you know what activities take place in Fulfillment Center?
Q189. How will you design a solution for Bangalore traffic?
Designing a solution for Bangalore traffic requires a multi-faceted approach.
Conduct a thorough analysis of traffic patterns and identify bottlenecks
Implement smart traffic management systems such as intelligent traffic signals and real-time traffic updates
Encourage the use of public transportation and carpooling through incentives and infrastructure improvements
Promote the use of bicycles and walking by creating dedicated lanes and pedestrian-friendly areas
Collaborate with c...read more
Q190. How will launch the Air conditioner category on Flipkart?
Launch Air conditioner category on Flipkart by creating a comprehensive marketing strategy.
Conduct market research to identify target audience and their preferences
Collaborate with top AC brands to offer a wide range of products
Create a user-friendly interface for easy navigation and purchase
Offer competitive pricing and discounts to attract customers
Launch a promotional campaign across various channels to create buzz
Provide excellent customer service to ensure customer satis...read more
Q191. How will you launch a grocery service for Flipkart?
To launch a grocery service for Flipkart, I would focus on building a strong supply chain, partnering with local grocery stores, and creating a user-friendly app.
Build a strong supply chain to ensure timely delivery of fresh groceries
Partner with local grocery stores to expand the product range and reach
Create a user-friendly app with features like easy navigation, personalized recommendations, and multiple payment options
Offer attractive discounts and deals to attract custom...read more
Q192. customer wants refund money what will you do
I would follow the company's refund policy and assist the customer in the process.
Ask the customer for the reason for the refund request
Check the company's refund policy to ensure eligibility
Assist the customer in filling out any necessary forms
Process the refund according to the company's policy
Apologize for any inconvenience caused
Q193. What is e commerce? Buying things over internet.
E-commerce refers to the buying and selling of goods and services over the internet.
E-commerce allows businesses and individuals to conduct online transactions.
It involves online shopping, electronic payments, and online auctions.
Examples include Amazon, eBay, and Alibaba.
E-commerce has revolutionized the retail industry and provided convenience to consumers.
It has also opened up global markets and increased competition.
Q194. Given an array a1, a2, a3 …. ,an, b1, b2, b3, ……bn. Rearrange this array to a1, b1, a2, b2, ….an,bn. This needs to be done inplace
Rearrange array elements in place alternating between two sets of elements
Create two pointers, one for elements from the first half of the array and one for elements from the second half
Swap elements at the pointers' positions and move the pointers accordingly until all elements are rearranged
Q195. Why do we keep a few brands separately after acquiring them?
Keeping acquired brands separate helps maintain their unique identity and customer loyalty.
Preserving the acquired brand's reputation and customer base
Avoiding confusion among customers
Leveraging the acquired brand's strengths and market position
Maintaining a diverse portfolio of brands
Examples: Nestle's acquisition of Starbucks' retail business, Unilever's acquisition of Dollar Shave Club
Q196. How will you deal with engineering team in a prioritization conflict?
I will collaborate with the engineering team to understand their concerns and work towards a mutually beneficial solution.
Listen to the engineering team's concerns and priorities
Explain the business goals and priorities
Work together to find a solution that meets both business and engineering needs
Consider the impact on customers and stakeholders
Communicate the decision and reasoning clearly to all parties involved
Q197. Why sometimes orders automatically gets cancelled on Flipkart?
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: Occasionally, technical glitches on the platform may lead ...read more
Q198. Describe the process for cropping an image in the program
To crop an image in Photoshop, select the Crop tool, define the desired area, and apply the crop.
Open the image in Photoshop
Select the Crop tool from the toolbar
Click and drag to define the desired cropping area
Adjust the crop by dragging the handles or entering specific dimensions
Press Enter or click the Commit button to apply the crop
Q199. The customer purchased the products, how will you solve the problems related to the product?
I would assess the problem and offer a solution based on the customer's needs and the company's policies.
Listen to the customer's concerns and gather information about the problem
Check the company's policies and procedures for handling product-related issues
Offer a solution that meets the customer's needs and is within the company's guidelines
Follow up with the customer to ensure their satisfaction with the resolution
Q200. Delivery boy how face to customers deliver time
Delivery boys should be professional and punctual when facing customers during delivery time.
Delivery boys should maintain a professional appearance and demeanor when interacting with customers.
They should be punctual and deliver the packages within the promised time frame.
Delivery boys should be polite, friendly, and helpful towards customers.
They should handle any customer queries or concerns efficiently and effectively.
Delivery boys should ensure the packages are delivered...read more
More about working at Flipkart
Top HR Questions asked in SpadeWorx Software Services
Interview Process at SpadeWorx Software Services
Top Interview Questions from Similar Companies
Reviews
Interviews
Salaries
Users/Month