Dunnhumby Senior Software Engineer Interview Questions and Answers

Q1. Third party took the interview. Basics of programming and database were asked.
Add your answer

Q1. Asked to build a small game. LLD round.
Add your answer

Q1. What is a dirty read in a database?
Ans. 
A dirty read occurs when a transaction reads data that has been modified but not yet committed by another transaction.
• Dirty reads can lead to inconsistencies, as the data may change before the first transaction is committed.

• For example, if Transaction A updates a record but hasn't committed yet, and Transaction B reads that record, Transaction B sees uncommitted data.

• If Transaction A rolls back, Transaction B will have...read more
Answered by AI
Add your answer
Q2. What are design patterns?
Ans. 
Design patterns are reusable solutions to common software design problems, promoting best practices and improving code maintainability.
• Creational patterns (e.g., Singleton, Factory Method) manage object creation.

• Structural patterns (e.g., Adapter, Composite) deal with object composition.

• Behavioral patterns (e.g., Observer, Strategy) focus on communication between objects.

• Design patterns help in code reusability and sca
Answered by AI
Add your answer

Q1. Questions were mainly based on work experience and resume
Add your answer
Q2. AWS Question regarding S3, saprk memory
Add your answer

Q1. Explain your previous projects
Add your answer
Q2. Scenario based question
Add your answer

Q1. Write progrem to check balenced brackets in a given string
Ans. 
Program to check balanced brackets in a given string
• Use a stack to keep track of opening brackets

• Iterate through the string and push opening brackets onto the stack

• When a closing bracket is encountered, pop from the stack and check if it matches the corresponding opening bracket

• If stack is empty at the end and all brackets are matched, the string is balanced
Answered by AI
Add your answer

Q1. Moderate questions
Add your answer
Q2. Asynchronous coding, async, mvc, sql, missing number program
Add your answer

Q1. Sql query on joins Given two tables and create output result . It was self join
Add your answer
Q2. Oops polymorphism questions Microservices Design pattern Factory pattern
Add your answer

3 simple coding questions

Q1. Merge sort with list
Ans. 
Merge sort is a divide and conquer algorithm that recursively divides the input array into smaller subarrays, sorts them, and then merges them back together.
• Divide the input list into two halves

• Recursively apply merge sort to each half

• Merge the sorted halves back together
Answered by AI
Add your answer
Q2. Similar to coin exchange DP
Add your answer
Q3. SQL query medium level
Add your answer