Upload Button Icon Add office photos

S&P Global

Compare button icon Compare button icon Compare

Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards

zig zag pattern zig zag pattern

Filter interviews by

Clear (1)

S&P Global Software Development Engineer II Interview Questions, Process, and Tips

Updated 27 Feb 2025

Top S&P Global Software Development Engineer II Interview Questions and Answers

  • Q1. Difference between truncate and delete and when we prefer what operation?
  • Q2. How to build a responsive Web UI page when we have to load large size images from the database like social networking site.
  • Q3. Why we use views, can we create indexes on that?
View all 11 questions

S&P Global Software Development Engineer II Interview Experiences

2 interviews found

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I was interviewed before Feb 2024.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Covered most of the OOPS and data structure related questions. Also covered Design Patterns
  • Q2. How to build a responsive Web UI page when we have to load large size images from the database like social networking site.
  • Ans. 

    To build a responsive Web UI page with large images, use lazy loading, image optimization, and responsive design techniques.

    • Implement lazy loading to only load images when they are in the viewport.

    • Optimize images for web by compressing them and using modern image formats like WebP.

    • Use responsive design techniques like CSS media queries to adjust image sizes based on screen resolution.

    • Consider implementing a content del...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepared with all the basics and cover all technologies mentioned in the resume aligned with the project experience.
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Recruitment Consulltant and was interviewed before Sep 2022. There were 5 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all Resume tips
Round 2 - Technical 

(6 Questions)

  • Q1. Difference between clustered, unclustered, and unique index?
  • Ans. 

    Clustered index physically reorders the data in the table, unclustered index does not, unique index enforces uniqueness of values.

    • Clustered index physically reorders the data in the table based on the index key. Only one clustered index per table.

    • Unclustered index does not reorder the data in the table. Can have multiple unclustered indexes per table.

    • Unique index enforces uniqueness of values in the indexed column(s).

  • Answered by AI
  • Q2. What is CDC in sql service?
  • Ans. 

    CDC stands for Change Data Capture in SQL Server.

    • CDC is a feature in SQL Server that captures changes made to data in a table.

    • It allows you to track insert, update, and delete operations on the table.

    • CDC uses a separate table to store the changes made to the tracked table.

    • It is useful for auditing, data replication, and data warehousing purposes.

  • Answered by AI
  • Q3. Why we use views, can we create indexes on that?
  • Ans. 

    Views are virtual tables that simplify complex queries. Indexes can be created on views to improve performance.

    • Views are virtual tables created by querying one or more tables.

    • They simplify complex queries by storing the query logic in the view.

    • Indexes can be created on views to improve query performance.

    • Indexes on views can speed up data retrieval by allowing the database to quickly locate the relevant data.

  • Answered by AI
  • Q4. Difference between temp table, global table and variable table?
  • Ans. 

    Temp table is local to a session, global table is accessible across sessions, variable table is a table variable declared in a function or stored procedure.

    • Temp table is created and dropped automatically when the session ends.

    • Global table is created using a double hash (##) prefix and is accessible across sessions.

    • Variable table is a table variable declared in a function or stored procedure and is only accessible withi

  • Answered by AI
  • Q5. Difference between truncate and delete and when we prefer what operation?
  • Ans. 

    Truncate removes all rows from a table, while delete removes specific rows. Truncate is faster but cannot be rolled back.

    • Truncate is a DDL operation while delete is a DML operation

    • Truncate resets the identity seed of the table, delete does not

    • Truncate is faster as it does not log individual row deletions, delete logs each row deletion

    • Truncate cannot be used on tables referenced by a foreign key constraint, delete can b...

  • Answered by AI
  • Q6. Question related to unpivot operation, department wise salary and duplicates ?
Round 3 - Technical 

(6 Questions)

  • Q1. Merge operation in sql?
  • Ans. 

    Merge operation in SQL is used to combine two sets of data into a single result set.

    • Merge operation is used to insert, update, or delete data in a target table based on the results of a join with a source table.

    • It is commonly used for data synchronization between two tables.

    • Syntax: MERGE INTO target_table USING source_table ON condition WHEN MATCHED THEN UPDATE SET column1 = value1 WHEN NOT MATCHED THEN INSERT (column1

  • Answered by AI
  • Q2. Error Handling way in sql ?
  • Ans. 

    Error handling in SQL involves using try-catch blocks, raising custom errors, and using error functions.

    • Use TRY-CATCH blocks to handle errors gracefully

    • Raise custom errors using RAISEERROR function

    • Use error functions like ERROR_MESSAGE(), ERROR_NUMBER(), ERROR_SEVERITY(), ERROR_STATE(), and ERROR_LINE() to retrieve error information

  • Answered by AI
  • Q3. How to plan ETL for various data sources?
  • Ans. 

    Plan ETL for various data sources by identifying sources, defining data extraction methods, transforming data, and loading into target systems.

    • Identify all data sources and understand their structure and format

    • Define data extraction methods based on the source systems (e.g. APIs, databases, files)

    • Transform data as needed to match the target system's schema and requirements

    • Consider data quality issues and implement data...

  • Answered by AI
  • Q4. What is Bulk insert?
  • Ans. 

    Bulk insert is a process of inserting a large amount of data into a database at once.

    • Efficient way to insert large volumes of data into a database

    • Reduces overhead by minimizing the number of transactions

    • Often used for data migration or loading data from external sources

  • Answered by AI
  • Q5. What is synonyms?
  • Ans. 

    Synonyms are words that have similar meanings.

    • Synonyms are words that can be used interchangeably in a sentence.

    • They help in avoiding repetition and adding variety to the language.

    • Examples include: big and large, happy and joyful, fast and quick.

  • Answered by AI
  • Q6. Questions related to performance improvements and will give scenrios for identify the better performance queries?
Round 4 - One-on-one 

(1 Question)

  • Q1. Will ask about projects and some aptitude type question based on 8 same size ball to identify which have less weight and some glass water scenario questions.
Round 5 - HR 

(1 Question)

  • Q1. Will Negotiate Salary and she will be rude so you will decrease your ask....dont hesitate and ask for good amount that you deserve.

Interview Preparation Tips

Interview preparation tips for other job seekers - Make sure your are ready for the interview and interviewer will be humble and help you understand the questions.

Skills evaluated in this interview

Software Development Engineer II Interview Questions Asked at Other Companies

asked in Zepto
Q1. Given 2 large numeric comma seperated strings. You need to calcul ... read more
asked in Zepto
Q2. How many microservices do I own & at what scale they handle t ... read more
asked in Porter
Q3. 1. Given an array find a subset that sums to a given sum K 2. Giv ... read more
Q4. design a LLD of portfolio management system where you can add any ... read more
asked in S&P Global
Q5. Difference between truncate and delete and when we prefer what op ... read more

Interview questions from similar companies

Interview Preparation Tips

Round: Technical Interview
Tips: * Easy technical questions
* Hiring procedure is more of technical assessment + personality assessment

Skills:
College Name: IIT Madras

Interview Questionnaire 

8 Questions

  • Q1. Find a number which occurs odd number of times and all number occurs even number of times
  • Ans. 

    Find an odd occurring number among even occurring numbers.

    • Use XOR operation to cancel out even occurring numbers and get the odd occurring number.

    • Iterate through the array and XOR each element with the result variable.

    • The final result will be the odd occurring number.

  • Answered by AI
  • Q2. Some discussion about my minor project
  • Q3. Spiral order of binary tree and mattrix, print it
  • Ans. 

    Print the spiral order of a binary tree and matrix.

    • For binary tree, use level order traversal and alternate direction for each level.

    • For matrix, use four pointers to traverse in spiral order.

    • Example for binary tree: 1 -> 2 -> 3 -> 4 -> 5 -> 6 -> 7 -> 8 -> 9

    • Example for matrix: 1 2 3 4 -> 8 7 6 5 -> 9 10 11 12 -> 16 15 14 13

  • Answered by AI
  • Q4. Some question about os,dbms
  • Q5. Find pair which have a given sum in a given array
  • Ans. 

    Finding pairs in an array with a given sum.

    • Iterate through the array and for each element, check if the difference between the given sum and the element exists in the array.

    • Use a hash table to store the elements of the array and their indices for faster lookup.

    • If there are multiple pairs with the same sum, return any one of them.

    • If no pair is found, return null or an empty array.

  • Answered by AI
  • Q6. Find total number of k element which have a given avg in a given array in minimum time complexity
  • Ans. 

    Find total number of k element with given avg in an array in minimum time complexity.

    • Use sliding window technique to traverse the array in O(n) time complexity.

    • Maintain a sum variable to keep track of the sum of elements in the window.

    • If the sum of elements in the window is equal to k times the given avg, increment the count.

    • Move the window by subtracting the first element and adding the next element in the array.

  • Answered by AI
  • Q7. Print all elements which in not boundary element in a given binary tree
  • Ans. 

    Printing non-boundary elements of a binary tree

    • Traverse the tree in any order (preorder, inorder, postorder)

    • Check if the current node is not a boundary node (not the first or last node in its level)

    • If it is not a boundary node, print its value

    • Recursively traverse its left and right subtrees

  • Answered by AI
  • Q8. Then some question about process synchronisation,error vs exception,and then 2-3 hr question

Interview Preparation Tips

Round: Test
Experience: practice codes on paper
Tips:

Round: Technical Interview
Experience: very good
Tips: please try to explain each and every question in detail

Round: Technical Interview
Experience: my hr round is not taken by them,and some of face 3rd round ,which is HR
Tips: please prepare all types of problem from geeksforgeeks

Skill Tips: please try to understand every problem from geeksforgeeks
Skills: ds
College Name: NIT Bhopal
Motivation: best work culture,and a lots of learning opportunity in this company,and in every 6 month there is a appraisal

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Explain how you read messages from google cloud pusub
  • Ans. 

    Reading messages from Google Cloud Pub/Sub involves creating a subscription and pulling messages from the subscription.

    • Create a subscription to a Google Cloud Pub/Sub topic

    • Use the subscription to pull messages from the topic

    • Process the messages received from the subscription

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well about your past project design. you will get questioned about your choices in it

Skills evaluated in this interview

I applied via LinkedIn and was interviewed in Apr 2021. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. All were technical. Just keep practicing data structures and Algorithms and have good knowledge of the language you're good at.

Interview Preparation Tips

Interview preparation tips for other job seekers - Hey Folks
Just never get discouraged by your failures. Keep working hard and be consistent in your efforts. You will surely achieve what you deserve.

I applied via Naukri.com and was interviewed before Jul 2020. There were 4 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. Questions on java8
  • Q2. Questions on multithreading
  • Q3. Questions on exception handling

Interview Preparation Tips

Interview preparation tips for other job seekers - First round was a coding round where interviewer asked questions randomly and were asked to optimise our code. Next round was a technical round where everyone needs to be thorough with their technical skills

I applied via Approached by Company and was interviewed in Aug 2021. There was 1 interview round.

Round 1 - Technical 

(3 Questions)

  • Q1. Basic oops concepts of java
  • Q2. Exception handling,thread
  • Q3. Basic Junit test cases knowledge

Interview Preparation Tips

Interview preparation tips for other job seekers - Have basic knowledge of all the above

I applied via Recruitment Consulltant and was interviewed in Jan 2022. There were 3 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. Basics of Java and spring
Round 2 - Technical 

(1 Question)

  • Q1. About our project have to explain everything
Round 3 - HR 

(3 Questions)

  • Q1. What are your salary expectations?
  • Q2. Share details of your previous job.
  • Q3. Tell me about yourself.

Interview Preparation Tips

Interview preparation tips for other job seekers - It's a good company and my interview process held very smooth

I applied via Naukri.com and was interviewed before Apr 2021. There were 3 interview rounds.

Round 1 - Aptitude Test 

Aptitude test will a hackerrank test where it might have technical MCQ and/or coding test.

Round 2 - Technical 

(1 Question)

  • Q1. Interviewer will test your logic building capability with puzzel/coding and technical questions and experience discussion.
Round 3 - One-on-one 

(1 Question)

  • Q1. Its a normal discussion with HR about CTC and all.

Interview Preparation Tips

Interview preparation tips for other job seekers - In TR interviewer are really good. They will help you and give hints. They mostly check if you have problem solving approch.
Contribute & help others!
anonymous
You can choose to be anonymous

S&P Global Interview FAQs

How many rounds are there in S&P Global Software Development Engineer II interview?
S&P Global interview process usually has 3 rounds. The most common rounds in the S&P Global interview process are Technical, One-on-one Round and Resume Shortlist.
What are the top questions asked in S&P Global Software Development Engineer II interview?

Some of the top questions asked at the S&P Global Software Development Engineer II interview -

  1. Difference between truncate and delete and when we prefer what operati...read more
  2. How to build a responsive Web UI page when we have to load large size images fr...read more
  3. Why we use views, can we create indexes on th...read more

Recently Viewed

PHOTOS

InsuranceDekho

3 office photos

LIST OF COMPANIES

Credit Bajaar

Overview

INTERVIEWS

Headout

No Interviews

INTERVIEWS

Quorum Software

No Interviews

INTERVIEWS

Elektrobit India

No Interviews

INTERVIEWS

S&P Global

30 top interview questions

INTERVIEWS

Elektrobit India

No Interviews

INTERVIEWS

GeeksForGeeks

No Interviews

INTERVIEWS

GeeksForGeeks

No Interviews

INTERVIEWS

Antino

No Interviews

Tell us how to improve this page.

S&P Global Software Development Engineer II Interview Process

based on 2 interviews

Interview experience

4
  
Good
View more

Interview Questions from Similar Companies

EXL Service Interview Questions
3.7
 • 736 Interviews
Morningstar Interview Questions
3.9
 • 241 Interviews
Mu Sigma Interview Questions
2.6
 • 229 Interviews
Access Healthcare Interview Questions
3.9
 • 207 Interviews
FactSet Interview Questions
3.9
 • 204 Interviews
Straive Interview Questions
3.4
 • 174 Interviews
AGS Health Interview Questions
4.0
 • 158 Interviews
CorroHealth Interview Questions
3.3
 • 145 Interviews
Nielsen Interview Questions
3.7
 • 117 Interviews
View all
S&P Global Software Development Engineer II Salary
based on 46 salaries
₹8.5 L/yr - ₹30 L/yr
22% less than the average Software Development Engineer II Salary in India
View more details

S&P Global Software Development Engineer II Reviews and Ratings

based on 5 reviews

4.5/5

Rating in categories

4.3

Skill development

4.8

Work-life balance

4.3

Salary

4.5

Job security

5.0

Company culture

3.5

Promotions

4.5

Work satisfaction

Explore 5 Reviews and Ratings
Data Analyst
1.4k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Data Researcher
844 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Software Engineer
676 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Engineer
614 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Lead Data Analyst
313 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare S&P Global with

Moody's

4.1
Compare

Thomson Reuters

4.1
Compare

Bloomberg

3.4
Compare

Dun & Bradstreet

3.3
Compare
Did you find this page helpful?
Yes No
write
Share an Interview