Sainsburys Data Engineer Interview Questions and Answers for Experienced

Q1. Python question to solve
Add your answer
Q2. Pyspark and Sql question to solve
Add your answer

Q1. Explain projects, python string pattern code, sql query
Ans. 
The question asks the candidate to explain projects, python string pattern code, and SQL query.
• Discuss the projects you have worked on as a data engineer, highlighting your role and the technologies used.

• Explain how you have used Python string pattern code to manipulate and analyze data.

• Provide an example of a SQL query you have written to extract and analyze data from a database.

• Emphasize the impact and results of you...read more
Answered by AI
Add your answer

Majorly the interviews revolve around the following skills :
1. Advanced SQL
2. PYTHON (DSA)

Majorly the interviews revolve around the following skills :
1. Advanced SQL
2. python (DSA)

Q1. Which techniques you would have used on a system you have worked in the past to be able to optimise it further. (Deep knowledge of the databases is required)
Ans. 
I would have used indexing, query optimization, and data partitioning to optimize the system.
• Implement indexing on frequently queried columns to improve search performance.

• Optimize queries by using proper joins, filters, and aggregations.

• Partition large tables to distribute data across multiple storage devices for faster access.

• Use materialized views to precompute and store aggregated data for quicker retrieval.
Answered by AI
Add your answer
Q2. Situational questions on the ETL tools used and advantages and disadvantages of both
Add your answer

Q1. Describe a complex situation you were in at workplace and how did you handle it?
Ans. 
Handled a complex data migration project by breaking it down into smaller tasks and collaborating with team members.
• Identified key stakeholders and their requirements

• Developed a detailed project plan with timelines and milestones

• Assigned specific tasks to team members based on their strengths and expertise

• Regularly communicated progress updates and addressed any issues promptly
Answered by AI
Add your answer

Duration - 3 hours, DSA

They didn't score properly on the assessments for theoretical answers. Types of Data Modeling is a basic question with just 3 types but they marked the answer as wrong. I did not argue with the interviewer but yes, didn't feel comfortable after the process.

Basic with python SQL and data models

Q1. Real life example
Ans. 
Developing a data pipeline to analyze customer behavior for an e-commerce company
• Collecting and storing customer data from website interactions

• Cleaning and transforming data to identify patterns and trends

• Building machine learning models to predict customer behavior

• Visualizing insights for stakeholders to make data-driven decisions
Answered by AI
Add your answer
Q2. Scenario based questions
Add your answer

Python SQL coding question and basic SQL understanding

Q1. White board Rround
Add your answer