S&P Global Lead Software Engineer Interview Questions and Answers for Experienced

First round was online coding round, second was coding in interview infornt of panel, third was DSA+basic Database questions

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

Basic ds algo round with questions asked around arrays strings

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

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

It was good. contains lot of theoretical questions.

1 hr. asked basic concepts.

Q1. Minimum in Rotated Sorted array
Ans. 
Find the minimum element in a rotated sorted array.
• Perform binary search to find the pivot point where the array is rotated.

• Compare the element at pivot point to the first element to determine which half to search for the minimum.

• Continue binary search in the appropriate half to find the minimum element.
Answered by AI
Add your answer
Q2. API and DB Schema for Instagram based application.
Ans. 
API for Instagram application to interact with user data and DB schema to store user information and posts.
• API endpoints for user authentication, posting photos, liking photos, following users, etc.

• DB schema with tables for users, posts, comments, likes, followers, etc.

• Example API endpoint: /users/{userId}/posts to retrieve all posts by a specific user.

• Example DB schema: Users table with columns for username, email, pr
Answered by AI
Add your answer

Q1. Resume introspection, AWS, K8s
Add your answer