Upload Button Icon Add office photos

S&P Global

Compare button icon Compare button icon Compare
4.2

based on 2.4k Reviews

Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards

zig zag pattern zig zag pattern

Filter interviews by

S&P Global Interview Questions, Process, and Tips for Experienced

Updated 9 Jan 2025

Top S&P Global Interview Questions and Answers for Experienced

View all 57 questions

S&P Global Interview Experiences for Experienced

Popular Designations

98 interviews found

Interview experience
3
Average
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed before Mar 2023. There was 1 interview round.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Past projects of machine learning
  • Ans. 

    Developed a predictive model for customer churn using machine learning algorithms.

    • Used Python and scikit-learn library for data preprocessing and model building

    • Performed feature engineering to improve model performance

    • Evaluated model performance using metrics like accuracy, precision, and recall

  • Answered by AI
  • Q2. Distributed computing and spark questions

Skills evaluated in this interview

Data Scientist Interview Questions asked at other Companies

Q1. Special Sum of ArrayYou have been given an array/list ‘arr’ of length ‘N’, which contains single digit elements at every index. Your task is to return the sum of all elements of the array. But the final sum should also be a single digit. To... read more
View answer (2)
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 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

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

Q1. Difference between truncate and delete and when we prefer what operation?
View answer (2)

Software Development Engineer II Interview Questions asked at other Companies

Q1. Given 2 large numeric comma seperated strings. You need to calculate their sum along with maintaining the correct position of commas. Example Test Case - s1 - "123,456,788" s2 - "1" output - "123,456,789" constraints - since the strings can... read more
View answer (1)

Software Engineer Interview Questions & Answers

user image HITESH BANSAL

posted on 23 Jun 2022

I applied via Company Website and was interviewed in Dec 2021. There were 4 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - Coding Test 

Java Multiple choice questions and 2 coding questions

Round 3 - Technical 

(3 Questions)

  • Q1. Collection in java works
  • Ans. 

    Collection in Java is a framework that provides interfaces and classes to store and manipulate groups of objects.

    • Collections can be used to store objects of any type.

    • Some common collection types include ArrayList, LinkedList, HashSet, and TreeMap.

    • Collections can be sorted, searched, and filtered using various methods.

    • Iterators can be used to traverse through collections and perform operations on each element.

    • Collection...

  • Answered by AI
  • Q2. Multithreading environment
  • Q3. 2 coding questions and reduce its complexity
Round 4 - One-on-one 

(1 Question)

  • Q1. Spring and cloud platform difference
  • Ans. 

    Spring is a framework for building Java applications, while cloud platform provides infrastructure for deploying and scaling applications.

    • Spring provides a set of tools and frameworks for building Java applications, while cloud platform provides infrastructure for deploying and scaling those applications.

    • Spring can be used with any cloud platform, while cloud platform can support applications built with any framework.

    • S...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Geeks for geeks for coding and concepts of java 8 , concepts of multithreading and collection is minimum required

Skills evaluated in this interview

Software Engineer Interview Questions asked at other Companies

Q1. Bridge and torch problem : Four people come to a river in the night. There is a narrow bridge, but it can only hold two people at a time. They have one torch and, because it's night, the torch has to be used when crossing the bridge. Person... read more
View answer (169)

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 13 Jul 2024

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Company Website and was interviewed before Jul 2023. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. EPS and Diluted EPS

Top S&P Global Data Analyst Interview Questions and Answers

Q1. 1) What Is IPO 2) Sides Of Balance Sheet 3) What Is Depreciation 4) Financial Statements
View answer (2)

Data Analyst Interview Questions asked at other Companies

Q1. Suppose there is a room in the office and X people enter room throughout the day, Y people leave throughout the day [continuously people are entering the room, some are staying there, and rest are going out] .. so tell me the code to calcul... read more
View answer (11)

S&P Global interview questions for popular designations

 Data Analyst

 (38)

 Data Researcher

 (13)

 Research Analyst

 (7)

 Software Engineer

 (7)

 Software Developer

 (6)

 Analyst

 (5)

 Financial Analyst

 (5)

 Research Associate

 (5)

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Walk-in and was interviewed before Nov 2022. There were 4 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Properly align and format text in your resume. A recruiter will have to spend more time reading poorly aligned text, leading to high chances of rejection.
View all tips
Round 2 - Aptitude Test 

Written test of 50 marks

Round 3 - Technical 

(3 Questions)

  • Q1. What is operating expenses
  • Ans. 

    Operating expenses are the costs associated with running a business on a day-to-day basis.

    • Operating expenses include rent, utilities, salaries, and supplies.

    • These expenses are necessary for the ongoing operation of the business.

    • They are distinct from capital expenses, which are investments in assets like equipment or property.

    • Operating expenses are listed on a company's income statement and are subtracted from revenue

  • Answered by AI
  • Q2. What is ratio analysis
  • Ans. 

    Ratio analysis is a financial tool used to evaluate a company's performance by analyzing relationships between financial variables.

    • Ratio analysis involves comparing different financial ratios to assess a company's financial health and performance.

    • It helps in identifying trends, strengths, weaknesses, and potential areas of improvement.

    • Common ratios used in ratio analysis include liquidity ratios, profitability ratios, ...

  • Answered by AI
  • Q3. What is networth
  • Ans. 

    Net worth is the total assets minus total liabilities of an individual or company.

    • Net worth is a measure of wealth and financial health.

    • It is calculated by subtracting total liabilities from total assets.

    • For example, if someone has assets worth $500,000 and liabilities of $200,000, their net worth would be $300,000.

  • Answered by AI
Round 4 - One-on-one 

(1 Question)

  • Q1. General details of education and my background.

Interview Preparation Tips

Interview preparation tips for other job seekers - For bcom graduates and MBA Finance freshers

Research Associate Interview Questions asked at other Companies

Q1. Tell any name reactions to form new c-c bond without metal catalyst?
View answer (14)

Get interview-ready with Top S&P Global Interview Questions

I applied via Naukri.com and was interviewed in Jul 2022. There were 2 interview rounds.

Round 1 - Coding Test 

Write a code to achieve some logic using the selenium framework.

Round 2 - Technical 

(1 Question)

  • Q1. It was more about project management and the challenges faced.

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well about Selenium, Java, Java collections, Maven, TestNG, Cucumber and project management and estimation.
All the best.

Senior Quality Engineer Interview Questions asked at other Companies

Q1. what is least count of vernier caliper ,micrometer, height gauge?
View answer (13)

Jobs at S&P Global

View all

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 25 Apr 2024

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

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

Round 1 - Aptitude Test 

Maths, analytical , English

Round 2 - Group Discussion 

One topic is given . Give brief and logical answer

Round 3 - One-on-one 

(1 Question)

  • Q1. Lots of finance questions Stocks Mutual funds Cost accounting

Top S&P Global Data Analyst Interview Questions and Answers

Q1. 1) What Is IPO 2) Sides Of Balance Sheet 3) What Is Depreciation 4) Financial Statements
View answer (2)

Data Analyst Interview Questions asked at other Companies

Q1. Suppose there is a room in the office and X people enter room throughout the day, Y people leave throughout the day [continuously people are entering the room, some are staying there, and rest are going out] .. so tell me the code to calcul... read more
View answer (11)
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed before Oct 2022. There were 4 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Double-check your resume for any spelling mistakes. The recruiter may consider spelling mistakes as careless behavior or poor communication skills.
View all tips
Round 2 - Assignment 

Read a case and answer questions based on that

Round 3 - One-on-one 

(3 Questions)

  • Q1. Basic Finance questions
  • Q2. P&L Statement from basic finance
  • Q3. Balance Sheet from basic finance
Round 4 - HR 

(1 Question)

  • Q1. Formal HR questions

Interview Preparation Tips

Topics to prepare for S&P Global Research Associate interview:
  • Preparing Financial Statements
  • Financial Ratio
  • Current Events from Finance
  • Current event from Business

Research Associate Interview Questions asked at other Companies

Q1. Tell any name reactions to form new c-c bond without metal catalyst?
View answer (14)
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
Selected Selected

I applied via Referral and was interviewed before Jul 2023. There was 1 interview round.

Round 1 - Coding Test 

Medium level leet code test

Senior Software Engineer 2 Interview Questions asked at other Companies

Q1. What microservices patterns are you aware ? let's assume that there is a microservice based architecture and service A is calling service B which in turn service C. If service b fails, how will you manage transaction and logging ?
View answer (1)

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 26 Jan 2024

Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Walk-in and was interviewed before Jan 2023. There were 3 interview rounds.

Round 1 - HR 

(1 Question)

  • Q1. Previous Jobs and Salary discussion
Round 2 - Aptitude Test 

English Language, Excel and word shortcuts,

Round 3 - Behavioral 

(2 Questions)

  • Q1. Disscussion about previous job and present.
  • Q2. Previous job roles

Top S&P Global Data Analyst Interview Questions and Answers

Q1. 1) What Is IPO 2) Sides Of Balance Sheet 3) What Is Depreciation 4) Financial Statements
View answer (2)

Data Analyst Interview Questions asked at other Companies

Q1. Suppose there is a room in the office and X people enter room throughout the day, Y people leave throughout the day [continuously people are entering the room, some are staying there, and rest are going out] .. so tell me the code to calcul... read more
View answer (11)

S&P Global Interview FAQs

How many rounds are there in S&P Global interview for experienced candidates?
S&P Global interview process for experienced candidates usually has 2-3 rounds. The most common rounds in the S&P Global interview process for experienced candidates are Technical, One-on-one Round and Resume Shortlist.
How to prepare for S&P Global interview for experienced candidates?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at S&P Global. The most common topics and skills that interviewers at S&P Global expect are HTTP, SQL, PDF, Python and Agile.
What are the top questions asked in S&P Global interview for experienced candidates?

Some of the top questions asked at the S&P Global interview for experienced candidates -

  1. Difference between truncate and delete and when we prefer what operati...read more
  2. What according to you is financial Mark...read more
  3. What is primary market and secondary mar...read more
How long is the S&P Global interview process?

The duration of S&P Global interview process can vary, but typically it takes about less than 2 weeks to complete.

Tell us how to improve this page.

S&P Global Interview Process for Experienced

based on 36 interviews in last 1 year

Interview experience

4.1
  
Good
View more

People are getting interviews through

based on 67 S&P Global interviews
Job Portal
Referral
Company Website
WalkIn
Recruitment Consultant
Campus Placement
34%
15%
15%
9%
9%
6%
12% candidates got the interview through other sources.
High Confidence
?
High Confidence means the data is based on a large number of responses received from the candidates.

Interview Questions from Similar Companies

EXL Service Interview Questions
3.7
 • 717 Interviews
Morningstar Interview Questions
4.0
 • 240 Interviews
Mu Sigma Interview Questions
2.7
 • 222 Interviews
FactSet Interview Questions
3.9
 • 205 Interviews
Access Healthcare Interview Questions
3.9
 • 197 Interviews
Straive Interview Questions
3.4
 • 165 Interviews
Thomson Reuters Interview Questions
4.1
 • 109 Interviews
Bloomberg Interview Questions
3.4
 • 25 Interviews
Moody's Interview Questions
4.1
 • 22 Interviews
View all

S&P Global Reviews and Ratings

based on 2.4k reviews

4.2/5

Rating in categories

3.7

Skill development

4.2

Work-Life balance

3.9

Salary & Benefits

4.0

Job Security

4.2

Company culture

3.4

Promotions/Appraisal

3.8

Work Satisfaction

Explore 2.4k Reviews and Ratings
Senior / Software Engineer

Delhi/Ncr

5-10 Yrs

₹ 25-35 LPA

Director Data Engineering

Hyderabad / Secunderabad

14-20 Yrs

Not Disclosed

Explore more jobs
Data Analyst
1.4k salaries
unlock blur

₹2 L/yr - ₹10.1 L/yr

Data Researcher
932 salaries
unlock blur

₹2 L/yr - ₹9 L/yr

Senior Software Engineer
662 salaries
unlock blur

₹11 L/yr - ₹40 L/yr

Software Engineer
628 salaries
unlock blur

₹9.7 L/yr - ₹36.5 L/yr

Research Analyst
311 salaries
unlock blur

₹3 L/yr - ₹13 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

Calculate your in-hand salary

Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and get your in-hand salary
Did you find this page helpful?
Yes No
write
Share an Interview