AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Walmart Data Engineer Interview Questions and Answers
Walmart Data Engineer Interview Experiences
8 interviews found
Anonymous
Selected
I applied via LinkedIn and was interviewed in Sep 2024. There were 2 interview rounds.
(2 Questions)
- Q1. Data Structures
- Q2. Algorithms concepts
(2 Questions)
- Q1. Data Engineering Concepts
- Q2. Spark and pyspark
Ankita Gulati
Based on python and sql
(2 Questions)
- Q1. Related to spark
- Q2. Dimensional Modelling
I applied via Approached by Company and was interviewed in Jun 2024. There was 1 interview round.
(1 Question)
- Q1. Static allocation in spark. 10TB of file needs to be processed in spark, what configuration (executors and cores) would you choose and why?
- Ans.
For processing 10TB of file in Spark, consider allocating multiple executors with sufficient cores to maximize parallel processing.
Allocate multiple executors to handle the large file size efficiently
Determine the optimal number of cores per executor based on the available resources and workload
Consider the memory requirements for each executor to avoid out-of-memory errors
Adjust the configuration based on the specific
Skills evaluated in this interview
What people are saying about Walmart
(2 Questions)
- Q1. Spark architecture
- Q2. Sql code medium level
Walmart interview questions for designations
I applied via Approached by Company and was interviewed in Jun 2022. There were 2 interview rounds.
(2 Questions)
- Q1. Round 1 was with manager, he asked questions about current project and some questions based on spark.
- Q2. Lazy Evaluation, configuration for running a spark jobs
(2 Questions)
- Q1. This is where the nightmare started, 1 scenario based coding questions and 3 sql questions were asked. The questions were of hacker rank level, its not that I couldn't solve those but for a guy who have wo...
- Q2. 1. Design and code a scheduler for allocating meeting rooms for the given input of room counts and timestamps: Input : No of rooms : 2 Time and dutation: 12pm 30 min Output: yes. Everytime th...
- Ans.
Design and code a scheduler for allocating meeting rooms based on input of room counts and timestamps.
Create a table with columns for room number, start time, and end time
Use SQL queries to check for available slots and allocate rooms
Consider edge cases such as overlapping meetings and room availability
Use a loop to continuously check for available slots and allocate rooms
Implement error handling for invalid input
Interview Preparation Tips
Selected
I applied via Approached by Company and was interviewed before Jan 2022. There were 4 interview rounds.
(2 Questions)
- Q1. Mostly SQL advanced questions
- Q2. Few Programming questions on Python
(1 Question)
- Q1. SQL, Python and Azure Questions
(1 Question)
- Q1. Compensation and benefits
Interview Preparation Tips
Data Engineer Jobs at Walmart
Selected
I applied via Recruitment Consulltant and was interviewed before Feb 2023. There was 1 interview round.
SQL, Spark, Hive, Python
Interview Preparation Tips
Interview Questionnaire
2 Questions
- Q1. Enhance your theoritical knowledge.
- Q2. Coding skills using collections
- Ans.
Collections are essential for efficient data manipulation in Python. A strong grasp of collections is crucial for a data engineer.
Familiarity with lists, tuples, sets, and dictionaries
Understanding of when to use each collection type
Ability to manipulate and iterate through collections
Knowledge of built-in collection methods and functions
Experience with third-party collection libraries like NumPy and Pandas
Skills evaluated in this interview
Interview questions from similar companies
I was interviewed before Jun 2021.
(2 Questions)
Round duration - 180 minutes
Round difficulty - Easy
It was an mcq + coding round. There were aptitude and ouput based question in mcq. And coding questions were easy
- Q1.
Find the Duplicate Number Problem Statement
Given an integer array 'ARR' of size 'N' containing numbers from 0 to (N - 2). Each number appears at least once, and there is one number that appears twice. Yo...
- Ans.
Find the duplicate number in an array of integers from 0 to (N-2).
Iterate through the array and keep track of the frequency of each number using a hashmap.
Return the number with a frequency greater than 1 as the duplicate number.
Time complexity can be optimized to O(N) using Floyd's Tortoise and Hare algorithm.
- Q2.
Reverse String Operations Problem Statement
You are provided with a string
Sand an array of integersAof sizeM. Your task is to performMoperations on the string as specified by the indices in arrayA... - Ans.
Given a string and an array of indices, reverse substrings based on the indices to obtain the final string.
Iterate through the array of indices and reverse the substrings accordingly
Ensure the range specified by each index is non-empty
Return the final string after all operations are completed
Round duration - 60 Minutes
Round difficulty - Easy
It was technical + hr round. there were 2 people as interviewer. They stated from intro and asked some basic puzzles and hr questions. After that they asked about my projects, technologies and some ds algo and dbms questions.
Interview Preparation Tips
Tip 1 : Practice aptitude
Tip 2 : Focus on practicing coding
Tip 3 : Learn from mistakes
Tip 1 : Mention some projects that you have done
Tip 2 : Try to have skills that are required for the role
Skills evaluated in this interview
Interview Questionnaire
6 Questions
- Q1. What is fan trap? How to solve it? Give one example.
- Ans.
Fan trap is a situation in which a query involving multiple tables results in a Cartesian product.
Fan trap occurs when a table is connected to multiple tables in a one-to-many relationship.
It can be solved by creating a bridge table or by using aggregate functions.
For example, if a customer table is connected to an orders table and a products table, a fan trap can occur when trying to retrieve information about custome...
- Q2. Two tables are joined. But joined type are not mentioned, then how much records will retrieve using select statement.
- Q3. How to use dynamic break in report?
- Ans.
Dynamic break in report allows for automatic page breaks based on data.
Define a break field in the report design
Set the break field to trigger a page break when its value changes
Use dynamic break to automatically adjust page breaks based on data
Example: A report on sales by region can use dynamic break to create a new page for each region
- Q4. Use of foreach function in report.
- Ans.
Foreach function is used to iterate through an array of strings in a report.
Foreach function is used to loop through each element in an array of strings.
It can be used to display each element in a report.
Example: foreach(string item in stringArray){ Console.WriteLine(item); }
- Q5. What is Aggregate awareness? When we use it? Syntax of it.
- Ans.
Aggregate awareness is a feature in Business Objects that allows reports to be optimized for performance by using aggregate tables.
Aggregate awareness is used when creating reports in Business Objects
It allows the report to use aggregate tables instead of detailed tables for improved performance
Syntax: AGGR_AWARE(
, , )
Example: AGGR_AWARE(Product, Sum(Sales), Sales_Fact_Table)
Answered by AIAdd your answer- Q6. @prompt function syntax and it's use.
- Ans.
The @prompt function syntax is used to display a prompt message to the user and receive input.
The syntax is @prompt('message', 'default value')
The message is the prompt message to be displayed to the user
The default value is optional and will be displayed in the input field
The function returns the value entered by the user
Answered by AIAdd your answer Walmart Interview FAQsHow many rounds are there in Walmart Data Engineer interview?Walmart interview process usually has 1-2 rounds. The most common rounds in the Walmart interview process are Technical, One-on-one Round and Coding Test.How to prepare for Walmart Data Engineer interview?Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Walmart. The most common topics and skills that interviewers at Walmart expect are SQL, Python, Monitoring, Computer science and Business Intelligence.What are the top questions asked in Walmart Data Engineer interview?Tell us how to improve this page.
Walmart Interviews By Designations
- Walmart Senior Software Engineer Interview Questions
- Walmart Software Engineer III Interview Questions
- Walmart Software Engineer Interview Questions
- Walmart Software Developer Interview Questions
- Walmart Data Scientist Interview Questions
- Walmart Data Engineer Interview Questions
- Walmart Associate Interview Questions
- Walmart Analyst Interview Questions
- Show more
Interview Questions for Popular Designations
- Senior Data Engineer Interview Questions
- Big Data Engineer Interview Questions
- Software Engineer Interview Questions
- Senior Software Engineer Interview Questions
- Database Admin Interview Questions
- Data Analyst Interview Questions
- System Engineer Interview Questions
- Associate Software Engineer Interview Questions
- Show more
Walmart Data Engineer Interview Process
based on 6 interviews
2 Interview rounds
- Technical Round - 1
- Technical Round - 2
View more
View allData Engineer Interview Questions from Similar Companies
View allFast track your campus placements
124% more than the average Data Engineer Salary in IndiaView more detailsWalmart Data Engineer Reviews and Ratings
based on 23 reviews
Rating in categories
Explore 23 Reviews and Ratings
Explore more jobs
Explore more salariesSoftware 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
Compare Walmart with
Amazon
CompareFlipkart
CompareMicrosoft Corporation
CompareGoogle
ComparePopular CalculatorsDid you find this page helpful?Yes No- Home >
- Interviews >
- Walmart Interview Questions >
- Walmart Data Engineer Interview Questions
Share an Interview
