Zepto
100+ Etisalat Interview Questions and Answers
Q1. Given 2 large numeric comma seperated strings. You need to calculate their sum along with maintaining the correct position of commas. Example Test Case - s1 - "123,456,788" s2 - "1" output - "123,456,789" const...
read moreCalculate sum of large numeric comma separated strings without converting to integers.
Split the strings by comma to get individual numbers
Iterate from right to left and add digits, carrying over if necessary
Maintain correct position of commas in the output string
Q2. How many microservices do I own & at what scale they handle the traffic?
I own 5 microservices that handle traffic at a scale of 10,000 requests per minute.
I own 5 microservices
They handle traffic at a scale of 10,000 requests per minute
Q3. LLD Round:- Design classes for bidding system when new bid notifications shown to all users who already bided for it.
Design classes for a bidding system with new bid notifications for users who have already bid.
Create a Bid class with attributes like bidder, amount, timestamp, etc.
Create a Notification class with attributes like message, recipient, timestamp, etc.
Create a BiddingSystem class to manage bids and notifications.
Implement a method in BiddingSystem to notify users who have already bid when a new bid is placed.
Consider using Observer design pattern to notify users efficiently.
Q4. How to manage you rider issue
To manage rider issues, establish clear communication channels, provide training and support, address concerns promptly, and maintain a positive work environment.
Establish clear communication channels with riders to address any issues or concerns.
Provide comprehensive training to riders to ensure they understand their responsibilities and expectations.
Offer ongoing support and guidance to riders, addressing any challenges they may face.
Promptly address and resolve any concern...read more
Q5. As a data analyst can you do data entry work also?
Yes, I can do data entry work as a data analyst.
Data entry work is a part of data analysis process.
I have experience in data entry work and can perform it efficiently.
Data entry work includes entering data into spreadsheets, databases, or other software.
I understand the importance of accurate data entry for effective analysis.
Q6. how can you check backward compatibility in API (if BE changes are deployed on PROD)
To check backward compatibility in API after BE changes are deployed on PROD, perform regression testing on existing functionalities.
Perform regression testing on existing API functionalities to ensure they still work as expected after BE changes
Check if any existing API endpoints have been deprecated or modified due to BE changes
Verify if any new API endpoints have been added and test their functionality
Ensure that the API responses are consistent with the previous versions
T...read more
Q7. How we control the dump ,damage,and FNV quality issues ?
We implement strict quality control measures to prevent dump, damage, and FNV issues.
Regular inspections and audits of inventory
Proper storage and handling procedures
Training and educating employees on quality control
Establishing relationships with reliable suppliers
Implementing a system for tracking and reporting issues
Collaborating with other departments to address and resolve issues
Continuous improvement through data analysis and feedback
Examples: conducting daily inspecti...read more
Q8. What is denbouncer and throttle
Debouncer and throttle are techniques used to limit the frequency of function calls.
Debouncing delays the execution of a function until a certain amount of time has passed without the function being called again.
Throttling limits the frequency of function calls to a certain rate, executing the function at fixed intervals.
Debouncing is useful for events that may be triggered multiple times in quick succession, such as resizing a window.
Throttling is useful for events that need...read more
Q9. Major difference between class based components and class based components
There is no difference between class based components and class based components.
There seems to be a typo in the question.
Assuming the question is about functional components vs class components, the major difference is that class components use a class to define the component while functional components are defined as functions.
Class components have access to lifecycle methods while functional components do not.
Functional components are simpler and easier to read and write.
E...read more
Q10. How much manpower is required to complete 2,000 orders in 20 hours if one employee has a productivity rate of 210 orders per hour?
To complete 2,000 orders in 20 hours with a productivity rate of 210 orders per hour, you would need 10 employees.
One employee can complete 210 orders per hour
To complete 2,000 orders in 20 hours, you would need 10 employees (2,000 orders / 20 hours = 100 orders per hour; 100 orders per hour / 210 orders per hour per employee = 10 employees)
Q11. how fast can you prepare a bar chart with product operations data
I can prepare a bar chart with product operations data within a few minutes.
I have experience using data visualization tools like Tableau, Power BI, or Excel to quickly create bar charts.
I am proficient in organizing and cleaning data to ensure accurate representation in the chart.
I can customize the chart with relevant labels, colors, and titles to make it visually appealing and easy to understand.
Q12. Do u know computer operation with Ms Excel
Yes, I am proficient in computer operations with MS Excel.
I am skilled in creating and formatting spreadsheets
I can use formulas and functions to perform calculations
I am experienced in data analysis and visualization using charts and graphs
I can also use Excel for project management and tracking tasks
For example, I have used Excel to create a budget spreadsheet for my previous company and track expenses and revenue.
Q13. how to test netowork latency while testing mobile apps
Use network monitoring tools and simulate different network conditions to test network latency in mobile apps.
Use network monitoring tools like Wireshark or Charles Proxy to analyze network traffic and identify latency issues.
Simulate different network conditions (3G, 4G, WiFi, etc.) using tools like Network Link Conditioner on iOS or Android Emulator on Android.
Measure latency by sending requests to a server and calculating the time taken for the response to be received.
Test...read more
Q14. How do you write SQL query to get customers and which categories they did not purchase? How would you find potential new customers in those categories?
To get customers and categories they did not purchase, use SQL query with LEFT JOIN and WHERE NOT EXISTS. To find potential new customers, analyze categories with low sales.
Use LEFT JOIN to combine customers and categories tables
Use WHERE NOT EXISTS to filter out categories that customers did not purchase
To find potential new customers, analyze categories with low sales and target marketing efforts towards them
Q15. what parameter you will consider to select the location of mother hub?
Factors such as proximity to suppliers, transportation infrastructure, labor availability, and market demand are key parameters for selecting the location of a mother hub.
Proximity to suppliers to reduce transportation costs and lead times
Availability of transportation infrastructure for efficient distribution
Access to a skilled labor force for operations at the hub
Consideration of market demand and customer locations for strategic positioning
Cost of land and facilities in th...read more
Q16. How can you optimise the operations between dark stores and mother hubs?
Optimise operations by streamlining communication, inventory management, and logistics between dark stores and mother hubs.
Implement a robust inventory management system to track stock levels at both dark stores and mother hubs.
Utilize technology such as RFID tags or barcode scanners to improve accuracy and efficiency in inventory tracking.
Establish clear communication channels between dark stores and mother hubs to ensure timely updates on stock levels and delivery schedules...read more
Q17. What is you special ability to handle the store?
My ability to handle the store lies in my excellent organizational skills, attention to detail, and ability to motivate and lead a team.
I have experience in managing inventory and ensuring that stock levels are always optimal.
I am skilled in creating schedules and delegating tasks to ensure that all areas of the store are covered.
I have a talent for identifying areas of improvement and implementing changes to increase efficiency and profitability.
I am able to communicate effe...read more
Q18. In which method data is more secure GET or POST?
POST method is more secure than GET method for transmitting sensitive data.
POST method sends data in the request body, making it more secure as the data is not visible in the URL.
GET method sends data in the URL, which can be visible in browser history, server logs, and can be easily intercepted.
POST method is recommended for transmitting sensitive information like passwords, credit card details, etc.
GET method is commonly used for retrieving data from the server without send...read more
Q19. Tell me about a e-commerce app where you shop oftenly?
I shop often on Amazon app.
Amazon has a wide range of products available.
The app is user-friendly and easy to navigate.
The delivery is fast and reliable.
The app offers various payment options.
The app also has a feature of tracking the delivery status.
Amazon also offers great deals and discounts on products.
Q20. How would you predict users who are going to churn
By analyzing user behavior patterns, engagement levels, and feedback, we can predict users who are likely to churn.
Analyze user behavior patterns such as frequency of logins, time spent on platform, and interactions with features
Monitor engagement levels and identify any decrease in activity or usage
Collect feedback from users through surveys or customer support interactions to understand their satisfaction levels
Utilize machine learning algorithms to identify patterns and pr...read more
Q21. Replace all zeros to 1 which are surrounded by 1's
Replace zeros surrounded by ones with ones in an array of strings
Iterate through each string in the array
Check for zeros surrounded by ones and replace them with ones
Return the modified array of strings
Q22. How to escalate order pendency & live monitoring
To escalate order pendency & live monitoring, utilize automated alerts, real-time tracking systems, and regular communication with team members.
Implement automated alerts for order pendency thresholds to notify team members when action is needed
Utilize real-time tracking systems to monitor order progress and identify bottlenecks
Establish regular communication channels with team members to provide updates on order status and address any issues promptly
Q23. What is difference between E-commerce and Q-commerce ?
Q24. write negative testcases for cart value not greater equal to 1000
Negative testcases for cart value less than 1000
Add a product with a price less than 1000 to the cart
Remove all products from the cart and check if the total value is less than 1000
Add multiple products to the cart but ensure the total value is less than 1000
Q25. You know about SAP , Inbound & Outbound , RSTO & RTO
SAP is an enterprise resource planning software, Inbound & Outbound refer to logistics processes, RSTO is a transaction code for stock transfer orders, and RTO is return to origin.
SAP is a software used for managing business operations and customer relations.
Inbound refers to receiving goods or materials into a warehouse or facility.
Outbound refers to shipping goods or materials out of a warehouse or facility.
RSTO is a transaction code in SAP used for stock transfer orders be...read more
Q26. What is the main purpose of the work?
The main purpose of the work is to ensure efficient and effective use of information technology to support business operations.
To manage and maintain the organization's information systems
To analyze and interpret data to provide insights for decision-making
To identify and implement new technologies to improve business processes
To ensure data security and privacy
To provide technical support to end-users
To collaborate with other departments to align IT strategies with business ...read more
Q27. How would you take care of expanding catalogue for Zepto Search
To expand the catalogue for Zepto Search, I would conduct market research, analyze user feedback, collaborate with stakeholders, and prioritize new features.
Conduct market research to identify trends and gaps in the market
Analyze user feedback to understand what features users are looking for
Collaborate with stakeholders such as developers, designers, and sales teams to gather input and align on priorities
Prioritize new features based on market research, user feedback, and st...read more
Q28. What is the problem with colosures
Closures can cause memory leaks if not handled properly.
Closures can hold references to variables outside of their scope, preventing them from being garbage collected.
If closures are used excessively or not released properly, they can cause memory leaks.
To avoid memory leaks, make sure to release closures when they are no longer needed.
Q29. What is the cost breakdown for producing a paper bag?
The cost breakdown for producing a paper bag includes raw materials, labor, machinery, overhead costs, and packaging design.
Raw materials such as paper and ink are a significant cost factor.
Labor costs include wages for workers involved in the production process.
Machinery costs cover the expenses for equipment used in manufacturing.
Overhead costs include utilities, rent, and other indirect expenses.
Packaging design costs may vary depending on the complexity and customization ...read more
Q30. How to do deep copy ?
Deep copy creates a new object with the same values as the original object.
Use Object.assign() method to create a deep copy of an object.
For nested objects, use recursion to copy all levels.
For arrays, use slice() method to create a new array with the same values.
Avoid using spread operator for deep copy as it only creates a shallow copy.
Q31. How we control the inventory hygiene?
We maintain inventory hygiene through regular checks and proper storage.
Regularly check inventory for expired or damaged products
Ensure proper storage conditions such as temperature and humidity control
Implement a first-in, first-out (FIFO) system to prevent expired products from being sold
Train employees on proper handling and storage procedures
Maintain a clean and organized storage area
Q32. how can I do merge multiple excel files together
You can merge multiple Excel files together using the 'Consolidate' feature in Excel.
Open Excel and go to the 'Data' tab
Click on 'Consolidate' in the 'Data Tools' group
Select the files you want to merge and choose the desired options
Click 'OK' to merge the files together
Q33. Open an app, where do you find errors in the app to make it design better
Errors in the app can be found by conducting user testing, analyzing user feedback, monitoring app performance, and reviewing analytics.
Conduct user testing to observe how users interact with the app and identify any usability issues.
Analyze user feedback from app reviews, customer support inquiries, and surveys to pinpoint common complaints or suggestions for improvement.
Monitor app performance metrics such as crash reports, loading times, and error logs to identify technica...read more
Q34. SQL: UPDATE the name of EMPLOYEE having 3rd high salary
Update the name of employee with 3rd highest salary in SQL
Use a subquery to find the 3rd highest salary
Join the subquery with the EMPLOYEE table on salary to get the employee name
Use the UPDATE statement to update the name of the employee
Q35. cumulative sum for given table
To calculate cumulative sum for a given table
Sort the table in ascending order based on the column you want to calculate the cumulative sum for
Add a new column to the table to store the cumulative sum
Iterate through each row of the table and calculate the cumulative sum by adding the current row's value to the previous row's cumulative sum
Store the cumulative sum in the new column for each row
Q36. How to decrease the manpower attrition?
To decrease manpower attrition, focus on employee engagement, career growth opportunities, and fair compensation.
Conduct regular employee engagement surveys to identify areas of improvement
Provide opportunities for career growth and development
Offer fair compensation and benefits packages
Create a positive work culture and environment
Recognize and reward employees for their hard work and achievements
Q37. Low level Design for an online e-commerce website
Low level design for an online e-commerce website involves designing the architecture and components of the website.
Identify the main components such as user interface, database, payment gateway, product catalog, etc.
Design the database schema to store user information, product details, orders, etc.
Implement user authentication and authorization mechanisms for secure access.
Integrate payment gateway for processing transactions securely.
Optimize website performance by caching ...read more
Q38. Case Study: Provide sales strategy for Zepto to expand in Bangalore
Develop a sales strategy for Zepto to expand in Bangalore
Conduct market research to identify target customer segments in Bangalore
Establish partnerships with local businesses to increase brand visibility
Utilize digital marketing strategies to reach a wider audience in Bangalore
Offer promotions or discounts to attract new customers in the Bangalore market
Q39. How would you solve ranking problem at Zepto?
Implement a machine learning algorithm to optimize ranking based on user behavior and preferences.
Collect and analyze user data to understand preferences and behavior
Implement a machine learning algorithm to predict user preferences and optimize ranking
Regularly update the algorithm based on new data and feedback from users
Q40. How to manage inventory and People management and store KPIs
Q41. Describe about Inbound, Inventory and Outbound process ?
Q42. How do you perform regression testing in complex feature
Regression testing in complex features involves identifying critical test cases, automating tests, and executing them regularly.
Identify critical test cases that cover the main functionalities of the complex feature
Automate these test cases to ensure efficient and consistent testing
Execute regression tests regularly to catch any potential issues or regressions
Use tools like Selenium, JUnit, or TestNG for automation and reporting
Collaborate with developers to understand change...read more
Q43. What is promise.all()
promise.all() is a method that takes an array of promises and returns a new promise that resolves when all promises in the array have resolved.
It is used to handle multiple asynchronous operations simultaneously.
If any of the promises in the array rejects, the returned promise will be rejected with the reason of the first rejected promise.
The resolved values of the promises are returned as an array in the same order as the input promises.
Q44. What is closure in javascript
Closure is a function that has access to its parent scope even after the parent function has returned.
Closure allows for private variables and functions in JavaScript.
It is created when a function returns another function.
The inner function has access to the outer function's variables and parameters.
Example: function outer() { let x = 10; return function inner() { console.log(x); } }
The inner function can access and modify the value of x even after outer() has returned.
Q45. How to improve D.S(dark store)Metric?
To improve D.S Metric in a dark store, focus on optimizing inventory management, streamlining order fulfillment processes, and enhancing customer experience.
Optimize inventory management by implementing real-time inventory tracking systems
Streamline order fulfillment processes by reducing picking and packing times
Enhance customer experience by offering faster delivery options and improving product quality
Q46. Design a book reader service such as kindle
Design a book reader service similar to Kindle
Implement a user-friendly interface for browsing and purchasing books
Include features like bookmarking, highlighting, and note-taking
Support various file formats such as PDF, EPUB, and MOBI
Provide options for customization like font size, background color, and reading progress tracking
Q47. What is curry function
Currying is a technique of transforming a function that takes multiple arguments into a sequence of functions that each take a single argument.
Currying allows partial application of a function
It helps in creating reusable functions
Curried functions are easier to compose and chain
Example: const add = (a) => (b) => a + b; add(2)(3) returns 5
Q48. How we control the Expiry ?
We control expiry by implementing a first-in, first-out (FIFO) system and regularly checking expiration dates.
We use a FIFO system to ensure that older products are sold first
We regularly check expiration dates and remove expired products from the inventory
We train employees to identify and handle expired products properly
We work closely with suppliers to ensure that they provide products with sufficient shelf life
We use software systems to track expiration dates and alert us...read more
Q49. How do you build vendor/ brand relation
Building vendor/brand relations requires effective communication, trust, and mutual benefits.
Regular communication to understand their needs and expectations
Being transparent and honest in all dealings
Offering incentives and benefits to encourage loyalty
Collaborating on marketing and promotional activities
Providing feedback and suggestions for improvement
Resolving any issues or conflicts promptly and professionally
Q50. e commerce trying to expand in india, should they enter?
Yes, with a strategic approach and understanding of the market dynamics.
India has a growing e-commerce market with a large population and increasing internet penetration.
Competitive landscape should be analyzed to identify opportunities and challenges.
Localizing the platform and understanding cultural nuances is crucial for success.
Partnerships with local businesses and logistics providers can help in navigating the market.
Investing in marketing and customer acquisition strat...read more
Q51. E-commerce app's average ticking count has moved from 5th to 6th product.
Q52. Minimum jumps to reach end of an array
The minimum number of jumps needed to reach the end of an array.
Use dynamic programming to keep track of the minimum jumps needed at each index.
At each index, calculate the maximum reachable index and update the minimum jumps accordingly.
Example: For array [2, 3, 1, 1, 2, 4, 2, 0, 1, 1], the minimum jumps needed is 4.
Q53. What is memoization?
Memoization is a technique of caching the results of a function to improve performance.
Memoization is used to avoid redundant calculations by storing the results of a function and returning the cached result when the same inputs occur again.
It is commonly used in recursive functions and functions with expensive computations.
Memoization can be implemented manually or by using libraries like Lodash or Memoizee.
Example: Memoizing a Fibonacci function can significantly improve it...read more
Q54. What you know about Online business
Online business refers to conducting commercial transactions over the internet.
Online business allows companies to reach a global audience
E-commerce platforms like Amazon and eBay are examples of online businesses
Digital marketing plays a crucial role in promoting online businesses
Online businesses often use analytics to track customer behavior and improve sales
Online payment gateways like PayPal and Stripe facilitate transactions in online businesses
Q55. Project to reduce inventory losses
Implementing a project to reduce inventory losses by analyzing root causes and implementing preventive measures.
Conduct a thorough analysis of current inventory management processes to identify areas of improvement
Implement inventory tracking systems to monitor stock levels and identify discrepancies
Train staff on proper inventory management techniques to reduce human errors
Implement security measures such as surveillance cameras or access controls to prevent theft
Regularly r...read more
Q56. How we decrease the costing?
Decrease costing by optimizing inventory, reducing waste, negotiating with suppliers, and improving efficiency.
Optimize inventory to reduce excess stock and minimize storage costs
Reduce waste by implementing better inventory management and tracking systems
Negotiate with suppliers for better pricing and discounts
Improve efficiency by streamlining processes and reducing labor costs
Consider outsourcing certain tasks to reduce overhead costs
Q57. Design HLD for rider management system
Design HLD for rider management system
Use microservices architecture for scalability and flexibility
Implement user authentication and authorization for security
Include features like ride tracking, payment processing, and feedback system
Utilize databases for storing rider information and ride history
Q58. Binary search for closest element
Binary search to find the closest element in a sorted array
Implement binary search to find the target element in the array
Keep track of the closest element found so far while searching
Update the closest element if a closer one is found during the search
Q59. What is 7 QC tool example?
Q60. What is RACE condition
A RACE condition is a situation in which the outcome of a program depends on the order of execution of its components.
Occurs in concurrent programming when multiple threads access shared data and the outcome depends on the order of execution
Can lead to unpredictable behavior and bugs in the program
Example: Two threads trying to increment the same variable simultaneously can result in incorrect values due to race condition
Q61. What is Inventory process
Inventory process involves managing and tracking goods or materials within a business.
Inventory process includes receiving, storing, and distributing goods.
It involves keeping track of stock levels and reordering when necessary.
Regular audits and reconciliations are done to ensure accuracy.
Utilizing inventory management software can streamline the process.
Examples: barcode scanning, FIFO/LIFO methods, cycle counting.
Q62. How to find short inventory.
Analyze sales data, check for discrepancies, conduct physical inventory counts.
Review sales reports for discrepancies
Conduct physical inventory counts
Check for any missing or misplaced items
Utilize inventory management software to track inventory levels
Q63. How to handle 100 manpower
Handling 100 manpower requires effective communication, delegation, and organization.
Establish clear goals and expectations for the team
Delegate tasks based on individual strengths and skills
Provide regular feedback and support to team members
Implement efficient communication channels to ensure smooth workflow
Utilize project management tools to track progress and deadlines
Q64. Implement curry function
Curry function is a higher-order function that allows partial application of arguments.
Currying transforms a function that takes multiple arguments into a series of functions that take one argument each.
It returns a new function until all the arguments are received and then executes the original function.
Example: const add = (a, b) => a + b; const curriedAdd = curry(add); curriedAdd(2)(3) returns 5.
Q65. How can we improve fill rates
Improving fill rates can be achieved through better forecasting, optimizing inventory levels, and improving supplier relationships.
Implement a demand forecasting system to accurately predict customer demand
Optimize inventory levels to ensure adequate stock without excess inventory
Improve supplier relationships to ensure timely delivery and reduce lead times
Implement a safety stock policy to mitigate unexpected demand spikes
Utilize technology such as RFID and barcoding to impr...read more
Q66. Design chess platform to perform turnament
Design a chess platform for tournaments
Implement user registration and login functionality
Allow users to create or join tournaments
Include features for pairing players, tracking scores, and generating leaderboards
Provide options for different tournament formats such as round-robin or knockout
Include a feature for spectators to watch ongoing games
Implement a time control system for games
Allow for customization of tournament settings such as time limits and piece sets
Q67. What is in inventory?
Inventory refers to the list of goods and materials held available in stock by a business.
Inventory includes raw materials, work-in-progress, and finished goods.
It helps in meeting customer demand, avoiding stockouts, and optimizing costs.
Examples of inventory items are electronics, clothing, food products, and office supplies.
Q68. How to control wasteage Inventory
Controlling wasteage in inventory involves implementing proper inventory management techniques and monitoring processes.
Implement a first in, first out (FIFO) system to ensure older inventory is used first
Regularly conduct inventory audits to identify and address any discrepancies
Train staff on proper handling and storage of inventory to prevent damage or spoilage
Utilize inventory tracking software to monitor stock levels and identify areas of waste
Establish clear policies an...read more
Q69. GET, POST, PUT, PATCH difference
GET retrieves data, POST submits data, PUT updates data, PATCH partially updates data
GET is used to retrieve data from a server
POST is used to submit data to a server
PUT is used to update existing data on a server
PATCH is used to partially update existing data on a server
Q70. How do i can handle B2C.
Q71. Typical LLD with API and DB schema
LLD stands for Low Level Design, which includes designing API and database schema for a software system.
LLD involves detailed design of individual components/modules of a software system.
API design includes defining endpoints, request/response formats, authentication mechanisms, etc.
DB schema design involves defining tables, relationships, indexes, constraints, etc.
LLD ensures that the system is scalable, maintainable, and efficient.
Example: For an e-commerce platform, LLD wo...read more
Q72. Design an online grocery store basically zepto.
Design an online grocery store similar to zepto.
Implement user-friendly interface for easy navigation
Include search functionality for quick product discovery
Offer secure payment options for customer convenience
Provide delivery options with tracking feature
Include customer reviews and ratings for products
Implement inventory management system for real-time updates
Q73. Shallow copy vs deep copy
Shallow copy only copies the reference to an object while deep copy creates a new object with a new memory address.
Shallow copy is faster and uses less memory than deep copy.
In shallow copy, changes made to the original object will reflect in the copied object as well.
Deep copy creates a completely new object with its own memory space.
In JavaScript, arrays and objects are assigned by reference, so a shallow copy will only copy the reference to the original object.
In Python, y...read more
Q74. How E-commerce work ?
Q75. Deep drive of six sigma concept
Q76. How to handle. Attrition
Attrition can be handled by identifying root causes, improving employee engagement, offering career development opportunities, and conducting exit interviews.
Identify root causes of attrition through data analysis and employee feedback.
Improve employee engagement through regular communication, recognition, and feedback.
Offer career development opportunities to retain top talent.
Conduct exit interviews to gather insights and improve retention strategies.
Q77. What is Fifo and 6s
Fifo stands for First In, First Out and is a method used for inventory management. 6S is a workplace organization method focused on creating a clean and efficient work environment.
Fifo is a method where the first items added to inventory are the first ones to be used or sold.
6S focuses on Sort, Set in order, Shine, Standardize, Sustain, and Safety to create an organized and efficient workplace.
Example of Fifo: In a grocery store, older products are placed in front to ensure t...read more
Q78. What is your CTC
My current CTC is $80,000 per year.
My current CTC is $80,000 per year
I am open to discussing salary expectations during the interview process
I have experience negotiating salary packages in previous roles
Q79. What is expection
Expectation is a belief about what will happen in the future or what should happen in a particular situation.
Expectation is a mental state anticipating a certain outcome.
It can be based on past experiences, assumptions, or hopes.
Expectations can influence behavior and emotions.
Unmet expectations can lead to disappointment or frustration.
Example: Expecting a promotion after working hard for a year.
Q80. Design Splitwise Application (LLD)
Design a Splitwise application for managing shared expenses among friends.
Implement user authentication and authorization for secure access.
Create a user-friendly interface for adding expenses and splitting them among friends.
Develop algorithms for calculating balances and settling debts between users.
Include features for adding comments, attaching receipts, and generating reports.
Consider scalability and performance optimizations for handling large user bases and transaction...read more
Q81. What is Vlookup?
Vlookup is a function in Excel used to search for a value in a table and return a corresponding value from another column.
Vlookup stands for 'Vertical Lookup'.
It is commonly used in Excel to search for a value in the leftmost column of a table and return a value in the same row from a specified column.
The syntax for Vlookup is =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]).
Example: =VLOOKUP(A2, B2:D10, 3, FALSE) will search for the value in cell A2 in the ...read more
Q82. Audit planning to find missing sku
Audit planning involves systematic review of inventory records, physical counts, and reconciliation to identify missing SKUs.
Review inventory records to identify discrepancies
Conduct physical counts of inventory to compare with records
Reconcile physical counts with inventory records to pinpoint missing SKUs
Investigate potential reasons for missing SKUs such as theft, misplacement, or recording errors
Q83. Design Booking Management System
Design a Booking Management System for handling reservations and scheduling.
Create a user-friendly interface for customers to make bookings
Implement a database to store booking information
Include features for managing availability, cancellations, and payments
Q84. minimum cost to connect the ropes
The minimum cost to connect the ropes is calculated by repeatedly connecting the two smallest ropes until all ropes are connected.
Sort the ropes in ascending order.
Repeatedly connect the two smallest ropes.
Add the cost of connecting the two ropes to the total cost.
Continue this process until all ropes are connected.
Q85. Do you know about food safety
Yes, I am knowledgeable about food safety practices and regulations.
I am familiar with proper food handling techniques to prevent contamination
I understand the importance of maintaining proper food storage temperatures
I am aware of cross-contamination risks and how to prevent them
I know the importance of regular handwashing and cleanliness in food preparation areas
Q86. What is inventory
Inventory refers to the goods and materials a business holds for the purpose of resale or use in production.
Inventory includes raw materials, work-in-progress, and finished goods.
It is an important asset on a company's balance sheet.
Inventory management involves tracking, ordering, and storing inventory efficiently.
Examples of inventory include merchandise in a retail store, components in a manufacturing plant, and supplies in a hospital.
Q87. How would you drive growth?
I would drive growth by implementing targeted marketing strategies, expanding product offerings, and optimizing pricing strategies.
Implement targeted marketing strategies to reach new customers and increase brand awareness
Expand product offerings to cater to a wider range of customer needs and preferences
Optimize pricing strategies to maximize profitability and competitiveness in the market
Q88. Design Google Meet
Design a video conferencing platform similar to Google Meet.
Implement real-time video and audio streaming
Include features like screen sharing, chat, and participant management
Ensure scalability to support large number of users
Focus on security and privacy measures
Optimize for low latency and high quality video/audio
Q89. write HTTP status codes
HTTP status codes are standardized codes used to indicate the result of a HTTP request.
1. 2xx - Success: Request was successful (e.g. 200 OK)
2. 3xx - Redirection: Further action needs to be taken (e.g. 301 Moved Permanently)
3. 4xx - Client Error: Request cannot be fulfilled (e.g. 404 Not Found)
4. 5xx - Server Error: Server failed to fulfill a valid request (e.g. 500 Internal Server Error)
Q90. Design lld for Dream 11
Designing the low-level design for Dream 11 platform.
Use microservices architecture for scalability and flexibility.
Implement a robust database schema to handle large amounts of user data.
Utilize caching mechanisms to improve performance, especially during peak usage times.
Include authentication and authorization mechanisms to ensure data security.
Design APIs for seamless integration with third-party services.
Implement monitoring and logging for better troubleshooting and mai...read more
Q91. Design movie booking system
Design a movie booking system
Create a database to store movie details, showtimes, and seat availability
Develop a user interface for customers to browse movies, select showtimes, and book seats
Implement a payment gateway for secure transactions
Include features like seat selection, seat reservation timeout, and booking confirmation
Q92. What is state props drilling
State props drilling is the process of passing down props from a parent component to a deeply nested child component.
Involves passing props through multiple levels of components
Can lead to prop drilling if not managed properly
Can be avoided by using context or Redux for state management
Q93. Design Google calendar
Design a Google calendar
Allow users to create events and set reminders
Provide options for recurring events
Include sharing and collaboration features
Integrate with other Google services like Gmail and Maps
Q94. Design LLD of google calendar
Design LLD of google calendar
Use microservices architecture for scalability and maintainability
Implement features like event creation, editing, deletion, reminders, and sharing
Utilize databases for storing user data and events
Include user authentication and authorization for security
Integrate with external APIs for syncing with other calendars
Q95. Low Level Design for Chess
Low level design for a chess game including classes, functions, and data structures.
Create classes for pieces (e.g. Pawn, Rook, Bishop) with properties like position and color
Implement functions for moving pieces, checking valid moves, and capturing opponent pieces
Use data structures like 2D arrays to represent the chess board and track piece positions
Q96. Design LLD of Dream11
Design LLD of Dream11
Use microservices architecture for scalability and flexibility
Implement user authentication and authorization for secure access
Utilize caching mechanisms to improve performance
Design database schema for storing user data, teams, matches, and scores
Include features like creating teams, joining contests, and viewing live scores
Q97. design a recommendation system
Designing a recommendation system involves creating algorithms to suggest items to users based on their preferences and behavior.
Collect user data such as past purchases, ratings, and browsing history
Use collaborative filtering or content-based filtering techniques to make recommendations
Implement machine learning models like matrix factorization or neural networks for personalized recommendations
Evaluate the system's performance using metrics like precision, recall, and F1 s...read more
Q98. What is deep copy ?
Deep copy is a copy of an object that duplicates all of its attributes, including nested objects, rather than just copying references.
Deep copy creates a new object with its own unique memory space.
Changes made to the original object do not affect the deep copy.
Deep copy is often used when you need to modify an object without affecting the original.
Example: Using JSON.parse(JSON.stringify(object)) in JavaScript to create a deep copy.
Q99. Design lld for Zepto system
Design the low level design for Zepto system
Identify the components of the Zepto system such as user interface, database, backend services, etc.
Define the interactions between the components and how data flows through the system
Consider scalability, performance, and security aspects in the design
Use appropriate design patterns and technologies to implement the system
Include error handling and logging mechanisms in the design
Q100. What is you ctc
Top HR Questions asked in Etisalat
Interview Process at Etisalat
Top Interview Questions from Similar Companies
Reviews
Interviews
Salaries
Users/Month