Filter interviews by
I applied via Naukri.com and was interviewed in Jul 2022. There were 3 interview rounds.
Vlookup limitations include limited search range, case sensitivity, and inability to handle multiple matches.
Vlookup only searches for values in the leftmost column of the table array
It is case sensitive and cannot handle spelling errors
It only returns the first match and cannot handle multiple matches
It cannot search for values to the left of the lookup column
It can be slow and inefficient for large datasets
Vlookup and Index-Match are both Excel functions used for lookup and retrieval of data.
Vlookup is simpler and faster but has limitations in terms of flexibility and handling of large datasets.
Index-Match is more versatile and can handle complex data structures but is slower and requires more effort to set up.
Vlookup is best suited for simple lookups with small datasets while Index-Match is better for more complex looku...
Excel functions are pre-built formulas that perform calculations or manipulate data in a spreadsheet.
Sum: adds up a range of numbers
Sum if: adds up a range of numbers based on a specified condition
Count: counts the number of cells in a range that contain numbers
CountA: counts the number of cells in a range that are not empty
Count Blanks: counts the number of empty cells in a range
SQL limitations include lack of scalability, security vulnerabilities, and difficulty in handling unstructured data.
SQL is not suitable for handling unstructured data like images, videos, and audio files.
It can be difficult to scale SQL databases to handle large amounts of data.
SQL databases can be vulnerable to security threats like SQL injection attacks.
SQL is not always the best choice for real-time data processing ...
Code to find duplicate records
Identify the key columns to check for duplicates
Use GROUP BY and HAVING clauses to filter out duplicates
Consider using window functions like ROW_NUMBER() to identify and remove duplicates
Use programming languages like SQL, Python, or R to write the code
Code to describe database and columns from a table
Use SQL SELECT statement to retrieve column names and data types
Use DESC command to get table structure
Use INFORMATION_SCHEMA.COLUMNS to get detailed information about columns
Use SHOW CREATE TABLE to get table creation statement
A trigger in SQL is a set of instructions that automatically executes in response to a specific event or action.
Triggers can be used to enforce business rules, audit changes, or replicate data.
They can be defined to execute before or after an INSERT, UPDATE, or DELETE statement.
Triggers can also be nested, meaning one trigger can execute another trigger.
Examples of triggers include sending an email notification when a ...
Stored procedures are precompiled SQL statements that can be reused and executed multiple times.
Stored procedures improve performance by reducing network traffic and improving security.
They can be used to encapsulate business logic and provide a consistent interface to the database.
Stored procedures can also be used to simplify complex queries and transactions.
Examples include procedures for inserting, updating, and de...
Data is collected from various sources including databases, APIs, and user input.
We have access to multiple databases where we can extract relevant data
We use APIs to gather data from external sources such as social media platforms
Users can input data through forms or surveys
We also collect data through web scraping techniques
As a data analyst, I face challenges such as data quality issues, incomplete or inconsistent data, and time constraints.
Data quality issues: Dealing with missing or inaccurate data that can affect the analysis.
Incomplete or inconsistent data: Working with datasets that are not complete or have inconsistencies, requiring data cleaning and manipulation.
Time constraints: Balancing multiple projects and deadlines, often ne...
The sequence of execution of SQL codes is Select-From-Where-Group By-Having-Order By.
Select: choose the columns to display
From: specify the table(s) to retrieve data from
Where: filter the data based on conditions
Group By: group the data based on a column
Having: filter the grouped data based on conditions
Order By: sort the data based on a column
HAVING is used with GROUP BY to filter the results after grouping. WHERE is used to filter the results before grouping.
HAVING is used with GROUP BY clause while WHERE is used with SELECT clause.
HAVING is used to filter the results of aggregate functions while WHERE is used to filter individual rows.
HAVING is used to filter the results after grouping while WHERE is used to filter the results before grouping.
HAVING can o...
CSV files are plain text files that store tabular data, while Excel files are binary files that can contain multiple sheets and complex formatting.
CSV files are simpler and more lightweight compared to Excel files.
CSV files can be easily opened and edited using a text editor, while Excel files require specific software like Microsoft Excel.
CSV files do not support formulas, macros, or formatting options like colors and...
I have handled large amounts of data in my previous roles.
I have experience handling terabytes of data in my previous role as a data analyst at XYZ company.
I have worked with data from various sources such as databases, spreadsheets, and APIs.
I have also used tools like SQL, Python, and Excel to manipulate and analyze data.
I am comfortable working with both structured and unstructured data.
I have experience cleaning an...
Different approaches for data cleaning include removing duplicates, handling missing values, correcting inconsistent data, and standardizing formats.
Remove duplicates
Handle missing values
Correct inconsistent data
Standardize formats
Use statistical methods to identify outliers
Check for data accuracy and completeness
Normalize data
Transform data types
Apply data validation rules
I was interviewed in Feb 2025.
Managed a sourcing project for office supplies from vendor selection to contract negotiation
Identified key requirements for office supplies based on department needs
Researched and evaluated potential vendors based on quality, price, and delivery terms
Negotiated contracts with selected vendor to ensure favorable terms for the company
Managed the implementation of the new vendor relationship and monitored performance
I was interviewed in Dec 2024.
Encouraging a high-performing team member to engage more with their team despite discomfort.
Acknowledge and validate their concerns about noise and bright lights
Offer solutions such as noise-canceling headphones or adjusting the lighting in their area
Highlight the benefits of collaborating and sharing ideas with the team
Encourage team bonding activities outside of work to build relationships
Provide flexibility in seati
CRM is a strategy for managing interactions with customers to improve relationships and drive sales.
CRM involves collecting and analyzing customer data to better understand their needs and preferences
It focuses on building and maintaining strong relationships with customers through personalized communication
CRM systems help businesses track customer interactions, manage leads, and streamline sales processes
Examples of ...
What people are saying about Walmart
I was interviewed in Dec 2024.
Walmart interview questions for popular designations
I was interviewed in Aug 2024.
Explanation of useState, useEffect, useMemo, and useCallback hooks in React functional components.
useState is used to manage state in functional components
useEffect is used for handling side effects like data fetching, subscriptions, etc.
useMemo is used for performance optimization by memoizing expensive calculations
useCallback is used for memoizing functions to prevent unnecessary re-renders
These hooks enhance functio...
Setting up Redux store, connecting components, managing actions and reducers, and using middleware like Redux Thunk or Redux Saga for handling asynchronous actions.
Setting up a Redux store involves creating a store with createStore() function from Redux, combining reducers with combineReducers(), and applying middleware like Redux Thunk or Redux Saga.
Connecting components to the Redux store can be done using the connec...
To add and manipulate elements in arrays using JavaScript, you can use array methods like splice() and slice().
Use the splice() method to insert elements into an array at a specific index. For example, arr.splice(index, 0, 'watermelon') will insert 'watermelon' at the specified index without removing any elements.
To manipulate elements in an array, you can use methods like splice() to remove elements or slice() to extr...
Math.floor() is a method in JavaScript that rounds a number down to the nearest integer.
Math.floor() returns the largest integer less than or equal to a given number.
It is commonly used to convert a floating-point number to an integer.
Example: Math.floor(3.9) returns 3.
Mocking components in Jest for testing with props and named exports
Use jest.mock() to mock components and their exports
For handling props, use jest.fn() to create mock functions and pass them as props to the component being tested
For named exports, use jest.mock() with a second argument to specify the module's exports
Get interview-ready with Top Walmart Interview Questions
I applied via Indeed and was interviewed in Oct 2024. There were 2 interview rounds.
A test that rated your ability to work retail and handel customers.
I have a flexible availability and can adjust my schedule as needed.
I am available to work weekdays, weekends, and evenings.
I can easily switch shifts with advance notice.
I am open to working overtime if required.
I am willing to accommodate any scheduling needs of the company.
I have 5 years of experience in marketing and sales roles at a tech company.
Worked on developing marketing strategies to increase brand awareness
Managed social media accounts and created engaging content
Collaborated with sales team to generate leads and close deals
I have experience in de-escalating situations with unhappy customers by actively listening, empathizing, and finding solutions.
Active listening to understand the customer's concerns
Empathizing with the customer's emotions
Finding solutions to address the customer's issues
Remaining calm and professional throughout the interaction
Offering alternatives or compensation when appropriate
I applied via Recruitment Consulltant and was interviewed in Nov 2024. There was 1 interview round.
Catalog Analyst role involves managing product data, ensuring accuracy and consistency in catalogs.
Responsible for creating, updating, and maintaining product catalogs
Ensuring accuracy and consistency of product data
Analyzing catalog performance and making recommendations for improvements
Collaborating with cross-functional teams such as marketing, sales, and product development
Knowledge of data management systems and t
Five useful Excel shortcuts for efficient data analysis.
Ctrl + C: Copy selected cells
Ctrl + V: Paste copied cells
Ctrl + Z: Undo previous action
Ctrl + Shift + Arrow Key: Select entire data range in a direction
Ctrl + Home: Move to cell A1
Pivot table for summarizing data, vlookup for finding values in a table, hlookup for horizontal lookup, xlookup for advanced lookup.
Pivot table is used to summarize and analyze large datasets.
VLOOKUP is used to find a value in a table by row.
HLOOKUP is used to find a value in a table by column.
XLOOKUP is a more advanced version of VLOOKUP and HLOOKUP, allowing for more flexibility in searching for data.
Example: Use piv...
I was interviewed in Jan 2025.
Conduct a voice test focusing on spontaneous communication within the software, ensuring it is time-oriented.
I applied via Recruitment Consulltant and was interviewed in Oct 2024. There were 3 interview rounds.
Use two threads to print even and odd numbers in sequence
Create two threads, one for printing even numbers and one for printing odd numbers
Use synchronization mechanisms like mutex or semaphore to ensure numbers are printed in sequence
Start both threads simultaneously and let them print numbers alternately
Detecting cycle in a linked list and discussing behavioral aspects
Explain how to use Floyd's Tortoise and Hare algorithm to detect a cycle in a linked list
Discuss the importance of understanding memory management in linked lists to prevent cycles
Explain the impact of cycles in linked lists on time complexity and space complexity of algorithms
I applied via LinkedIn and was interviewed in Dec 2024. There were 3 interview rounds.
1.Sum numbers in linked list
2. Maximum sum subarray
Implement a hashmap data structure in code.
Use an array to store key-value pairs
Implement a hash function to map keys to indices in the array
Handle collisions using techniques like chaining or open addressing
Design a platform similar to LinkedIn for professional networking.
Create user profiles with work experience, education, skills, and endorsements.
Allow users to connect with others, join groups, and follow companies.
Include features like job postings, messaging, news feed, and recommendations.
Implement algorithms for personalized content and job suggestions.
Ensure data privacy and security measures are in place.
I applied via Walk-in and was interviewed in Sep 2024. There were 3 interview rounds.
SQL, python, PySpark basic to mid level questions.
Some of the top questions asked at the Walmart interview -
The duration of Walmart interview process can vary, but typically it takes about less than 2 weeks to complete.
based on 339 interviews
Interview experience
based on 2.4k reviews
Rating in categories
Software Engineer III
1.8k
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Software Engineer
1.3k
salaries
| ₹0 L/yr - ₹0 L/yr |
Software Engineer
801
salaries
| ₹0 L/yr - ₹0 L/yr |
Software Development Engineer 3
260
salaries
| ₹0 L/yr - ₹0 L/yr |
Business Development Associate
243
salaries
| ₹0 L/yr - ₹0 L/yr |
Amazon
Flipkart
Microsoft Corporation