Upload Button Icon Add office photos

Filter interviews by

Sainsburys Data Engineer Interview Questions and Answers for Experienced

Updated 26 Feb 2024

Sainsburys Data Engineer Interview Experiences for Experienced

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 Tips & Stories
2w
toobluntforu
·
works at
Cvent
Can speak English, can’t deliver in interviews
I feel like I can't speak fluently during interviews. I do know english well and use it daily to communicate, but the moment I'm in an interview, I just get stuck. since it's not my first language, I struggle to express what I actually feel. I know the answer in my head, but I just can’t deliver it properly at that moment. Please guide me
Got a question about Sainsburys?
Ask anonymously on communities.

Interview questions from similar companies

Data Analyst Interview Questions & Answers

Amazon user image himanshu kohli

posted on 31 May 2021

I applied via Walk-in and was interviewed before May 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Introducing your self

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident

Data Engineer Interview Questions Asked at Other Companies for Experienced

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 Sigmoid
Q3. Problem: Search In Rotated Sorted Array Given a sorted array that ... 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. Zigzag Binary Tree Traversal Problem Statement Determine the zigz ... 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

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
  • Ans. 

    I am a passionate software engineer with experience in developing web applications and a strong background in computer science.

    • Experienced in developing web applications using technologies such as HTML, CSS, JavaScript, and React

    • Strong background in computer science with knowledge of data structures and algorithms

    • Proficient in programming languages such as Java, Python, and C++

    • Familiar with Agile development methodolog...

  • Answered by AI
  • Q2. Why Flipkart
  • Ans. 

    Flipkart is a leading e-commerce platform in India with a strong focus on technology and innovation.

    • Flipkart offers a challenging and dynamic work environment for software engineers.

    • The company has a strong reputation for investing in technology and innovation.

    • Flipkart has a large user base and offers opportunities to work on a variety of projects.

    • The company has a strong focus on customer satisfaction and user experie...

  • Answered by AI
  • 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
  • Ans. 

    I have a strong technical background, excellent problem-solving skills, and a proven track record of delivering high-quality software.

    • Extensive experience in software development, including proficiency in multiple programming languages such as Java, Python, and C++

    • Strong problem-solving skills demonstrated through successful completion of complex projects

    • Proven track record of delivering high-quality software on time a...

  • Answered by AI

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?
  • Ans. 

    Convert a Binary Search Tree to a Doubly Linked List.

    • Create a DLL node class with left, right, and data fields.

    • Traverse the BST in-order and add each node to the DLL.

    • Adjust the left and right pointers of each node to create the DLL.

    • Return the head of the DLL.

  • Answered by AI
  • 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...
  • Ans. 

    The task is to fill the 'next' field of each node in a binary tree to point to the next node at the same level.

    • Use a level order traversal to process the tree nodes.

    • Maintain a queue to store the nodes at each level.

    • For each node, set its 'next' field to the next node in the queue.

    • If a node is the last node at its level, set its 'next' field to NULL.

  • Answered by AI
  • 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 for experienced candidates?
Sainsburys interview process for experienced candidates usually has 1 rounds. The most common rounds in the Sainsburys interview process for experienced candidates are Technical.

Tell us how to improve this page.

Overall Interview Experience Rating

5/5

based on 1 interview experience

Merchandiser
12 salaries
unlock blur

₹8 L/yr - ₹14.3 L/yr

Trading Assistant
10 salaries
unlock blur

₹10 L/yr - ₹19 L/yr

Quality Technologist
5 salaries
unlock blur

₹6.1 L/yr - ₹14.3 L/yr

Senior Accountant
4 salaries
unlock blur

₹6.4 L/yr - ₹16.6 L/yr

Assistant Merchandiser
4 salaries
unlock blur

₹4.9 L/yr - ₹6.7 L/yr

Explore more salaries
Compare Sainsburys with

Amazon

4.0
Compare

Flipkart

3.9
Compare

Mahindra & Mahindra

4.1
Compare

Asian Paints

4.0
Compare
write
Share an Interview