S&P Global Senior Devops Engineer Interview Questions and Answers

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

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

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

Simple basic matha

Q1. What are your salary expectations?
Ans. 
I am open to discussing salary based on the responsibilities and expectations of the role.
• Focus on the value you can bring to the company rather than a specific number

• Research the average salary range for similar positions in the industry and location

• Consider your experience, skills, and qualifications when determining your salary expectations

• Be prepared to negotiate and discuss other benefits besides salary
Answered by AI
Add your answer
Q2. Share details of your previous job.
Ans. 
I worked as a Sales Associate at XYZ Company.
• Responsible for assisting customers in finding and purchasing products.

• Managed inventory and restocked shelves to ensure product availability.

• Provided excellent customer service and resolved any issues or complaints.

• Achieved sales targets by upselling and cross-selling products.

• Collaborated with team members to create attractive product displays.

• Utilized POS system to proces...read more
Answered by AI
Add your answer
Q3. Why should we hire you?
Ans. 
I have the necessary skills, experience, and passion to excel in this role.
• I have a strong educational background and relevant work experience.

• I am a quick learner and have a proven track record of adapting to new environments.

• I am highly motivated and dedicated to delivering high-quality work.

• I possess excellent communication and teamwork skills.

• I am passionate about the industry and committed to continuous learning a
Answered by AI
Add your answer
Q4. Where do you see yourself in 5 years?
Ans. 
In 5 years, I see myself as a Senior Associate, leading a team and contributing to the growth and success of the company.
• Advancing to a Senior Associate role

• Leading a team and mentoring junior associates

• Contributing to the growth and success of the company

• Continuing to develop my skills and knowledge in the field
Answered by AI
Add your answer
Q5. What are your strengths and weaknesses?
Ans. 
My strengths include strong communication skills, attention to detail, and ability to work well in a team. My weaknesses include being overly critical of my own work and sometimes struggling with time management.
• Strength: Strong communication skills

• Strength: Attention to detail

• Strength: Ability to work well in a team

• Weakness: Being overly critical of my own work

• Weakness: Struggling with time management
Answered by AI
Add your answer
Q6. Tell me about yourself.
Ans. 
I am a highly motivated and experienced professional with a strong background in the field.
• I have a Bachelor's degree in Business Administration.

• I have worked as an Associate at XYZ Company for the past 3 years.

• I am skilled in data analysis and problem-solving.

• I have successfully managed multiple projects and achieved significant results.

• I am a team player and have excellent communication skills.
Answered by AI
Add your answer

Q1. Financial statements analysis, valuation principles and ratios
Add your answer

Q1. Ratios, Economy and capital markets
Add your answer