S&P Global Senior Software Engineer and Lead Interview Questions and Answers

Quant verbal LRDI ,normal question

Dsa array and 2D array

Q1. About project and resume
Add your answer

Q1. Behavioural question
Add your answer

Q1. All questions based on your resume and recent project you have done including OOPS concept, MVC , Design patterns, SOLID principles
Add your answer

Q1. Here test the communications, problem solving skills, Decision making skill, Situation handle, conflict management
Add your answer

Array,binary search, Aptitude

Q1. Coding Questions, java, Web development
Add your answer

Q1. Just normal Questions
Add your answer

It have some aptitude question and 2 coding question

Q1. Basic hr question asked like salary and all
Add your answer

It is pretty good only.

Q1. Asked about all the basics question,alogirthm,programs
Add your answer
Q2. Basic Coding questions like prime number
Add your answer
Q3. Acid Properties
Ans. 
ACID properties are a set of properties that guarantee database transactions are processed reliably.
• Atomicity: Transactions are either fully completed or fully aborted.

• Consistency: Database remains in a consistent state before and after the transaction.

• Isolation: Transactions are isolated from each other until they are completed.

• Durability: Once a transaction is committed, changes are permanent.

• Example: Transfer of fun...read more
Answered by AI
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...read more
Answered by AI
Add your answer

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...read more
Answered by AI
Add your answer

Q1. Resume introspection, AWS, K8s
Add your answer