Upload Button Icon Add office photos

Filter interviews by

Sainsburys Data Engineer Interview Questions and Answers

Updated 26 Feb 2024

Sainsburys Data Engineer Interview Experiences

1 interview found

Data Engineer Interview Questions & Answers

user image Anonymous

posted on 26 Feb 2024

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Pair programming for solve pyspark problem
  • Ans. 

    Pair programming in pyspark involves two programmers working together on the same code to solve problems efficiently.

    • Pair programming can help in brainstorming ideas and finding solutions faster.

    • It allows for immediate feedback and collaboration between team members.

    • One person can write the code while the other reviews and suggests improvements.

    • Pair programming can lead to better code quality and reduce errors.

    • Examples...

  • Answered by AI

Skills evaluated in this interview

Top trending discussions

View All
Interview Hub
1w (edited)
anshitanegi
·
ex -
Planet Spark
When HR’s Chinese English made me drop the interview!
So, I talked to the HR yesterday about the interview. I asked Please send me the location But their English… bro I was shocked! It was like talking to someone jisne english nahi kuch ar hi seekh liya ho, if the HR’s English is this I can only imagine the rest of the company I decided to drop the interview with this chinese english😶‍🌫️
FeedCard Image
Got a question about Sainsburys?
Ask anonymously on communities.

Interview questions from similar companies

I appeared for an interview in Nov 2020.

Interview Questionnaire 

1 Question

  • Q1. Design booking.com.
  • Ans. 

    Design a scalable and efficient platform for booking accommodations, flights, and experiences.

    • User Interface: Create a user-friendly interface for searching and booking accommodations.

    • Database Design: Use a relational database for storing user data, bookings, and property details.

    • Search Functionality: Implement a robust search algorithm to filter results based on user preferences.

    • Scalability: Use microservices architec...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - prepare SQL complex queries.

Data Engineer Interview Questions Asked at Other Companies

asked in Sigmoid
Q1. Next Greater Element Problem Statement You are given an array arr ... read more
asked in LTIMindtree
Q2. If you are given cards numbered 1-1000 and 4 boxes, where card 1 ... read more
asked in Cisco
Q3. Optimal Strategy for a Coin Game You are playing a coin game with ... read more
asked in Sigmoid
Q4. K-th Element of Two Sorted Arrays You are provided with two sorte ... read more
asked in Sigmoid
Q5. Problem: Search In Rotated Sorted Array Given a sorted array that ... read more

I applied via Campus Placement

Interview Preparation Tips

Round: Resume Shortlist
Experience: My resume had a couple of projects and a paper publication added to it, which was a part of my second year intern at TCS Innovation Labs.

Tips: I believe that the resume shortlist to appear for the test is just a formality and not a big deal to get through. Most of the students are allowed to appear for the test which is where, the main shortlisting occurs.
Although, the company does cut off people from certain departments. For example, none of the Agriculture and food engineering students were shortlisted for appearing for the test.
Also, from what I have heard, the company runs resumes through a program to take out the shortlist. Hence, certain key words such as "Scholar" or "Conference" may get you a good chance to get through the shortlisting.

Round: Test
Experience: The test is mainly quant based and how fast you can think and rationalize. They expect excellent speed; they ask you 20 questions to be answered in 30 minutes.
Tips: Normally, if a student is asked to appear for this right after his JEE examination, he would be able to get through it easily. But since our analytical thinking goes way down once we actually get in, it has to be worked upon again. I'd suggest you to solve all the quant questions of any CAT preparatory book for the American Express test. The test questions are quite similar to those that the CAT students prepare for.

Round: Technical Interview
Experience: In general, the American Express interviews are considered to be pretty peaceful compared to the interviews of other companies. I was just asked about my work at TCS Innovation Labs and the paper I would be publishing based on that work and the courses I have done in Data Analytics and what all do I know in it. They do not test the knowledge you say you possess.
Tips: While I was preparing for my interview, I was told to read about Amex and its products. Secondly, and most importantly, I was aksed to read a lot about credit card frauds and suggest ways of preventing that. Even during my time, a lot of people were asked about this and judged severely on that. This is a must must if you would be appearing for its interview.

Also, you would do well if you are able to connect with the interviewer. For instance, if both of you have been a part of the same inter IIT or have the same tastes, etc.

Also, the interviews are that peaceful that you are able to direct the interview in your favour. There are certain parts of your CV that you can easily talk about and certain parts that you would want to avoid. If you are able to think on your feet, it is easy to re direct the interview in your favour and the things that you would like to talk about; in my case, it was my work at TCS.

Round: Puzzle Interview
Experience: The main decision whether you have to be taken in or not is decided in your first round of interview after which, the puzzle interview is just a formality and to find out whether you are able to think on your feet or not. Not a big deal, pretty easy.
Tips: Nothing to be worried about, the puzzles asked are pretty easy and most probably, you would have already heard them if you have a nag of solving puzzles.

General Tips: Do not worry or stress yourself much. The interview is pretty easy if you have an edge in the skills that the company wants. I had started studying Data Analytics in my second year summer vacations, just 1 hour a day for hardly about a month. Which gave me enough of an edge. The main hurdle lies in getting through the test round where about 300 people are simply cut off.
Skill Tips: You should be able to code efficiently. Knowledge in Python and SQL is a big plus.
Also, I had done a course on Coursera called "Machine Learning" of Stanford University. Today, the company does not expect a lot of knowledge in Data Analytics from students which is why this course gave me the edge I needed to get through the interview. It's a pretty easy course and not very demanding. I would recommend this if you want to find out even whether you'd be interested in Data Analytics or not.
I was asked about the things I know and whether I have ever implemented them.
Skills: Analytics And Coding
Duration: 2
College Name: IIT Kharagpur
Motivation: American Express is known to have a good working culture and is currently the third best company to work for in India. The internship stipend is largest compared to any other company in India along with accommodation and travel. The company has a well structured internship program and also has good challenging work to offer.
Funny Moments: After the test, I was not shortlisted for the interview round.. Which broke my heart.
Just after the presentation, I walked up to the person presenting and handed him a hard copy of my resume asking him to at least give me a shot at the interview if they think my profile is good enough.
I believe that this was a turning point of this entire experience. I believe, at that moment itself, I gained their favour to take me in. Which is probably why my interview was peaceful, which is probably why I could get through even though my interview was the last among a bunch of 25 students..

Software Engineer Interview Questions & Answers

Amazon user image Rajesh Paramanandam

posted on 24 Feb 2017

I appeared for an interview in Oct 2016.

Interview Preparation Tips

Round: Test
Experience: Aptitude was quite easy they just asked us basic questions from Math,logical reasoning and english
Tips: Just think well before u do..
Duration: 1 hour 30 minutes
Total Questions: 40

Round: Behavioural Interview
Experience: It was face to face .. the interviewee asked questions from our resume... Since I m from computer science background they asked some technical questions..

Tips: Beware filling ur resume.. they will ask every stuff that you have in resume

Round: Technical Interview
Experience: Discussion about my project that i vr done in my final year.they asked me what was my role in my project

College Name: Sri ganesh college of engineering and technology

Interview Preparation Tips

Round: Test
Experience: The first test
contained 25 objective questions encompassing the basics of Computer Science ranging from
data structures, networks and operating systems to theory of computation
Duration: 45 minutes
Total Questions: 25

Round: Test
Experience: The second test contained 3 coding questions.
Duration: 45 minutes
Total Questions: 3

Round: HR Interview
Experience: After the written test, next day I appeared for 3 interviews.
They were checking if you can write code and also if you are aware of the practical issues faced while coding. In the final round they were testing if you could abstract out a real world
problem into code.
Tips: Overall I can say that you must hope for the best and prepare for the
worst. So make sure that you are prepared on all counts. You never know what might go wrong.

Interview Questionnaire 

2 Questions

  • Q1. Data struct,algo,
  • Q2. High level data structs and algos

Interview Preparation Tips

Round: Problem Statement
Experience: coding and submission before face to face interview shortlisting
Tips: practice coding ,coding is key to success for SE

Round: Resume Shortlist
Experience: based on marks ,I was called for F2F
Tips: the ppt was to be submitted explaining the approach

Round: Technical Interview
Experience: a lot of brain storming
Tips: understands the nitty gritty of the structs and algos

Round: Technical Interview
Experience: exact code was to be written instead of pseudo code
Tips: get hold of DS,Algos

Sainsburys HR Interview Questions

5 questions and answers

Q. How would you manage a team?
Q. How would you deal with difficult customers or colleagues?
Q. Why would you like to work for Sainsbury’s?

Data Engineer Interview Questions & Answers

Amazon user image Rohit Kulkarni

posted on 21 Sep 2015

Interview Preparation Tips

Round: Resume Shortlist
Experience: Relevant experience matters, a lot!

Round: HR Interview
Experience: Nothing specific. Just resume based.

Round: Technical Interview
Experience: 7 rounds. Across SQL, Python, Shell Script (bash), platform architectures and Amazon web services (AWS).
Tips: Prepare well - SQL and data architectures for various use cases.

Round: Behavioural Interview
Experience: On Amazons leadersh

Are these interview questions helpful?

I applied via Campus Placement

Interview Questionnaire 

4 Questions

  • Q1. Boundary traversal of a tree
  • Ans. 

    Boundary traversal of a tree is the process of visiting the nodes on the boundary of a tree in a specific order.

    • The boundary traversal can be done in three steps: left boundary, leaf nodes, and right boundary.

    • For the left boundary, start from the root and traverse down the left side of the tree until reaching a leaf node.

    • For the leaf nodes, perform an inorder traversal to visit all the leaf nodes of the tree.

    • For the ri...

  • Answered by AI
  • Q2. Find the nearest greater value of a given value in a BST
  • Ans. 

    Find the nearest greater value of a given value in a Binary Search Tree (BST).

    • Start from the root node and compare the given value with the current node's value.

    • If the given value is less than the current node's value, move to the left subtree.

    • If the given value is greater than the current node's value, move to the right subtree.

    • Keep track of the closest greater value encountered while traversing the tree.

    • Return the cl...

  • Answered by AI
  • Q3. There is an infinite stair case and there are n rounds. in i'th round we can jump i steps at one or discard them. it is given that k'th step is broken , find the max height we can reach with out stepping o...
  • Ans. 

    Given an infinite staircase with a broken kth step, find the maximum height we can reach in n rounds of jumping i steps.

    • We can start by jumping the maximum number of steps in each round until we reach the broken step.

    • After reaching the broken step, we can discard the i steps that would land us on the broken step and jump the remaining steps.

    • We can continue this pattern until we reach the maximum height we can reach wit...

  • Answered by AI
  • Q4. Height h was given and form a binary tree of height h and start combining bottom nodes to form a cone like structure
  • Ans. 

    Construct a binary tree of height h and merge bottom nodes to create a cone-like structure.

    • A binary tree of height h has 2^h - 1 nodes.

    • Start combining leaf nodes from the bottom level upwards.

    • Each combination can be visualized as merging two nodes into one.

    • For example, if h=3, the tree has 7 nodes, and you combine nodes at levels 2 and 1.

    • The final structure resembles a cone as nodes are merged.

  • Answered by AI

Interview Preparation Tips

Round: Test
Experience: there were 20 MCQ which were on ds , networks and basic coding followed by 2 coding questions.
1) print all the distinct substrings of a given string in lexicographical order
2) find the max i-j value in the given array of 0's and 1's such that there are equal number of zeros and ones, where i is the starting index and j is the ending index of the array.
Tips: make sure that you pass atleast half the test cases for both the question.
Duration: 90 minutes
Total Questions: 22

Round: Technical Interview
Experience: 1) i printed left view then leaves and right view using three level order traversals . he asked me to use one traversal only, then i told him the approach and wrote the working code.
2) told him the approach and coded it.
Tips: look at corner cases properly. the interviewers were friendly, so i felt relaxed.

Round: Technical Interview
Experience: 1) i told him a recursive O(2^n) solution, optimised it to O(n^2). he told me to optimise further. Then i finally came up with O(n) solution after 5 min and he was satisfied . i coded it. he was satisfied finally :D .
2) came up with the approach immediately and coded it. he was satisfied.
Tips: he was very particular about corner cases and he checked the code througly tested it on some cases to ensure it was working.

General Tips: be cool. interviewers were friendly. tell them what you are thinking and be clear with the question before answering to avoid wasteage of time.
Skill Tips: solve problems from codechef, spoj and codeforces. solve interview questions from geeksforgeeks and careercup.
Skills: the way you think, coding skills and knowledge on data structures.
Duration: 3
College Name: IIT Roorkee
Motivation: some good seniors got intern, so i was inspired.
Funny Moments: on the interview day a person came into the conference room to call me for interview, i didnt thought he was interviewer. he was very simple, but intelligent and at last i felt like asking him to ask me one more coding question as it was fun solving questions infront of him, but i didnt do that as i was frightened if i would not be able to answer it would be a negative remark :P .

Skills evaluated in this interview

I appeared for an interview before May 2016.

Interview Questionnaire 

4 Questions

  • Q1. Tell us about yourself
  • Q2. Why Flipkart
  • Q3. Are you comfortable to reallocate
  • Ans. 

    Yes, I am comfortable with reallocating as needed.

    • I am flexible and adaptable to changing circumstances.

    • I have experience working in dynamic environments where priorities can shift.

    • I am willing to take on new challenges and responsibilities as required.

  • Answered by AI
  • Q4. Why should we hire you

Interview Preparation Tips

Round: Test
Experience: 2 problem statements to be coded using any language
Tips: Focussed on string manipulations and enormous data size handling
Duration: 1 hour 30 minutes
Total Questions: 2

Skills: C/C++
College Name: Guru Premsukh Memorial College of Engineering

Interview Questionnaire 

13 Questions

  • Q1. Given a string of parenthesis, write a function if it is balanced
  • Ans. 

    Function to check if a string of parenthesis is balanced

    • Use a stack to keep track of opening parenthesis

    • If a closing parenthesis is encountered, pop from stack and check if it matches

    • If stack is empty and a closing parenthesis is encountered, return False

    • If all parenthesis are matched and stack is empty, return True

  • Answered by AI
  • Q2. Given two linked lists each of which represent a number, write a function that returns a linked list that represents the sum
  • Ans. 

    Implement a function to sum two linked lists representing numbers and return the result as a linked list.

    • Define a ListNode class to represent each node in the linked list.

    • Traverse both linked lists simultaneously, adding corresponding digits.

    • Handle carry-over when the sum of two digits exceeds 9.

    • Create a new linked list to store the result.

    • Example: For lists 2 -> 4 -> 3 and 5 -> 6 -> 4, the result is 7 ->...

  • Answered by AI
  • Q3. Find the number of occurrences of words in a paragraph
  • Ans. 

    Count the occurrences of words in a paragraph.

    • Split the paragraph into words using whitespace as a delimiter.

    • Create a dictionary to store the count of each word.

    • Iterate through the words and increment the count in the dictionary.

    • Return the dictionary with the word counts.

  • Answered by AI
  • Q4. Find common elements out of two sorted array?
  • Ans. 

    Find common elements out of two sorted array

    • Use two pointers to traverse both arrays simultaneously

    • Compare elements at each pointer and move the pointer of the smaller element

    • If elements are equal, add to common elements list and move both pointers

    • Stop when either pointer reaches end of array

  • Answered by AI
  • Q5. Convert BST to a Doubly linked list?
  • Q6. Given a binary tree in which the node structure has an additional field called “next” which of pointer to tree node type, fill up this field of each node to point to the next node at the same level (NULL i...
  • Q7. Given a parentheses string, determine if it is a valid / legitimate parentheses string. For strings consisting of single parentheses type and those consisting of multiple types
  • Ans. 

    Check if a string of parentheses is valid by ensuring every opening has a corresponding closing parenthesis.

    • Use a stack to track opening parentheses. Example: '(()' -> push '(', push '(', pop ')' -> stack: ['('].

    • For each closing parenthesis, check if there's a matching opening. Example: '()[]{}' -> valid, '([)]' -> invalid.

    • At the end, the stack should be empty for a valid string. Example: '((()))' -> val...

  • Answered by AI
  • Q8. You have a dictionary of words. Given a word, print all anagram are in dictionary . State the data structure to be used to solve this problem
  • Ans. 

    To find anagrams of a given word in a dictionary, use a hash table to store sorted versions of each word as keys and their corresponding original words as values.

    • Create a hash table to store the anagrams

    • Iterate through each word in the dictionary

    • Sort the characters of the word and use it as a key in the hash table

    • If the key already exists, add the word to the list of values for that key

    • Print the list of values for the ...

  • Answered by AI
  • Q9. You have given 10 files and you have given a string suggest data structure which ll facilitate efficient search of string in the file if string appears more than ones in that case u have to print line numb...
  • Ans. 

    Suggest a data structure for efficient search of a string in 10 files and print line number and file if string appears more than once.

    • Use a hash table to store the file name and line number of each occurrence of the string.

    • Iterate through each file and for each line, check if the string is present and update the hash table accordingly.

    • Print the hash table entries for the string.

  • Answered by AI
  • Q10. Write a program to print a tree in vertical order asked more than one approach to do this problem and modified problem many times
  • Q11. Discussion on my current work, difficulties and challenges faced at work, difficult people I have had to work with, instances when I went out of my way to propose creative solutions to existing problems a...
  • Q12. Why do you think amazon is the right place for you?
  • Ans. 

    Amazon is the right place for me because of its innovative culture, vast resources, and opportunities for growth.

    • Amazon's innovative culture aligns with my passion for pushing boundaries and finding creative solutions.

    • The company's vast resources provide the necessary tools and support to develop and deliver high-quality software.

    • Amazon offers numerous opportunities for growth and career advancement, allowing me to con...

  • Answered by AI
  • Q13. You have given an binary matrix which is sorted row wise and column wise write a program to search a row in the matrix having maximum number of zeroes
  • Ans. 

    Find the row with the maximum number of zeroes in a sorted binary matrix.

    • Iterate through each row of the matrix.

    • Count the number of zeroes in each row.

    • Keep track of the maximum count and the corresponding row index.

    • Return the row index with the maximum zeroes.

    • Example: For matrix [[0,0,1],[0,1,1],[1,1,1]], row 0 has 2 zeroes.

  • Answered by AI

Interview Preparation Tips

General Tips: My process started off at one their hiring drives. It was ahiring drivein world trade center in Bangalore. It was a tiresome process that comprised a written round followed by 4rounds of interview.
Skills: Algorithm, data structure
College Name: NA

Skills evaluated in this interview

Sainsburys Interview FAQs

How many rounds are there in Sainsburys Data Engineer interview?
Sainsburys interview process usually has 1 rounds. The most common rounds in the Sainsburys interview process are Technical.

Tell us how to improve this page.

Overall Interview Experience Rating

5/5

based on 1 interview experience

Interview Questions from Trending Companies on AmbitionBox

Synechron Interview Questions
3.5
 • 390 Interviews
Uber Interview Questions
4.2
 • 157 Interviews
BNP Paribas Interview Questions
3.8
 • 197 Interviews
Concentrix Corporation Interview Questions
3.7
 • 1.8k Interviews
Publicis Sapient Interview Questions
3.5
 • 656 Interviews
Cummins Interview Questions
4.3
 • 258 Interviews
IDFC FIRST Bank Interview Questions
3.9
 • 791 Interviews
Vishal Mega Mart Interview Questions
3.7
 • 180 Interviews
InterGlobe Aviation Interview Questions
3.5
 • 337 Interviews
View all
Merchandiser
12 salaries
unlock blur

₹9.6 L/yr - ₹14.3 L/yr

Trading Assistant
9 salaries
unlock blur

₹10.6 L/yr - ₹18.6 L/yr

Quality Technologist
5 salaries
unlock blur

₹9.4 L/yr - ₹14.3 L/yr

Senior Accountant
4 salaries
unlock blur

₹6.4 L/yr - ₹15.6 L/yr

Assistant Merchandiser
4 salaries
unlock blur

₹3.4 L/yr - ₹7 L/yr

Explore more salaries
write
Share an Interview