AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
S&P Global Interview Questions, Process, and Tips
Top S&P Global Interview Questions and Answers
- Q1. 1) What Is IPO 2) Sides Of Balance Sheet 3) What Is Depreciation 4) Financial Statementsasked in Data Analyst interview
- Q2. Difference between truncate and delete and when we prefer what operation?asked in Software Development Engineer II interview
- Q3. What do u understand by derivativesasked in Data Researcher interview
S&P Global Interview Experiences
277 interviews found
Anonymous
Selected
I applied via Recruitment Consulltant and was interviewed before Sep 2022. There were 5 interview rounds.
(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).
- 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.
- 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.
- 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
- 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...
- Q6. Question related to unpivot operation, department wise salary and duplicates ?
(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
- 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
- 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...
- 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
- 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.
- Q6. Questions related to performance improvements and will give scenrios for identify the better performance queries?
(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.
(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
Skills evaluated in this interview
Top S&P Global Software Development Engineer II Interview Questions and Answers
Software Development Engineer II Interview Questions asked at other Companies
Selected
Bachelor of Commerce degree with a GPA of 6.79 and an accompanying resume.
(5 Questions)
- Q1. Location send Hyderabad komplly
- Q2. Hardwark honest project
- Q3. First introducedy
- Q4. Salarypackge and times
- Q5. Respect to office staff
Interview Preparation Tips
Mechanical Foreman Interview Questions asked at other Companies
I applied via Campus Placement and was interviewed in Oct 2024. There were 2 interview rounds.
Technology making ours less human ( 15 min) online
(5 Questions)
- Q1. Tell me about yourself
- Q2. Tell me about you inters hip
- Q3. Fixed assets with example
- Ans.
Fixed assets are long-term tangible assets that are used in the production of goods or services and are not intended for sale.
Fixed assets are physical assets such as buildings, machinery, equipment, vehicles, and land.
They are not intended for sale and are used for the production of goods or services over a long period of time.
Examples of fixed assets include manufacturing plants, office buildings, delivery trucks, an
- Q4. Capital assets with example
- Ans.
Capital assets are long-term assets that are used in the production of goods or services and are not easily converted into cash.
Capital assets are typically tangible assets such as buildings, machinery, equipment, and vehicles.
They are used by a company to generate revenue over an extended period of time.
Examples of capital assets include manufacturing plants, delivery trucks, office furniture, and computer systems.
- Q5. Why we use current ration
- Ans.
Current ratio is used to assess a company's ability to pay its short-term obligations with its short-term assets.
Current ratio is a liquidity ratio that measures a company's ability to cover its short-term liabilities with its short-term assets.
It is calculated by dividing current assets by current liabilities.
A current ratio of 1 or higher is generally considered healthy, as it indicates that a company has enough curr...
Interview Preparation Tips
All the rounds are online.
Top S&P Global Data Analyst Interview Questions and Answers
Data Analyst Interview Questions asked at other Companies
What people are saying about S&P Global
I was interviewed in Jan 2025.
(1 Question)
- Q1. One -on -Round and HR
(1 Question)
- Q1. Basic question regarding project
Interview Preparation Tips
Mechanical Engg. Design Interview Questions asked at other Companies
S&P Global interview questions for popular designations
(5 Questions)
- Q1. Reverse a string
- Ans.
Function to reverse a given string.
Create an empty string to store the reversed string.
Iterate through the original string in reverse order and append each character to the new string.
Return the reversed string.
Example: Input 'hello', Output 'olleh'
- Q2. OOPS Pillars and Inheritance code
- Q3. Project related questions
- Q4. Puzzles type questions
- Q5. Resume based questions
Software Development Engineer Intern Interview Questions asked at other Companies
Get interview-ready with Top S&P Global Interview Questions
I applied via Campus Placement
A topic was given on microsoft teams with bunch of other students
(3 Questions)
- Q1. Tell me about yourself?
- Ans.
I am a data analyst with a strong background in statistics and data visualization.
Experienced in analyzing large datasets to extract valuable insights
Proficient in using tools like Excel, SQL, and Python for data analysis
Skilled in creating visualizations and reports to communicate findings
Strong problem-solving and critical thinking skills
Excellent communication and presentation abilities
- Q2. Internship experience
- Ans.
I completed a data analysis internship at XYZ Company where I worked on various projects.
Utilized SQL to extract and analyze data from databases
Created visualizations using Tableau to present findings to stakeholders
Collaborated with team members to clean and prepare data for analysis
- Q3. Other cash flow statement and balance sheet related questions.
Top S&P Global Data Analyst Interview Questions and Answers
Data Analyst Interview Questions asked at other Companies
Jobs at S&P Global
I need to develop a case study on securities.
(2 Questions)
- Q1. Questions have been asked about my proposed design on securities
- Q2. Asked about Golden Ratio
Piyush Garg
I applied via Company Website and was interviewed in Jul 2024. There was 1 interview round.
(5 Questions)
- Q1. Authentication vs Authorization in API, error codes
- Ans.
Authentication verifies the identity of a user, while authorization determines what actions they are allowed to perform in an API.
Authentication ensures the user is who they claim to be, usually through credentials like username and password.
Authorization determines the level of access a user has once authenticated, such as read-only or read-write permissions.
Error codes in APIs are used to communicate issues with auth...
- Q2. API testing questions, HTTP methods
- Q3. Explain STLC, bug life cycle
- Ans.
STLC is Software Testing Life Cycle which includes various phases like requirement analysis, test planning, test design, test execution, and test closure. Bug life cycle is the process of a bug from identification to resolution.
STLC includes phases like requirement analysis, test planning, test design, test execution, and test closure
Bug life cycle involves stages like New, Assigned, Open, Fixed, Retest, Reopened, and ...
- Q4. Introduction, current role
- Q5. Automation testing questions
Interview Preparation Tips
- API Testing
- Automation Testing
Interviewer said they require someone from Automation background only but when I asked I had no experience in that and also my resume does not specify that thing, then why my profile was shortlisted and I was called for the interview, she had no answer for that. Interviewer didn't even looked at my resume before the interview, as it was shared with her from past 2 days. Terrible people working over there who consider them as kings/queens
Skills evaluated in this interview
SQA Engineer Interview Questions asked at other Companies
I applied via Company Website and was interviewed in Nov 2024. There was 1 interview round.
(2 Questions)
- Q1. Walk me through your daily task
- Q2. How will you manage multiple vendors
Interview Preparation Tips
Service Delivery Manager Interview Questions asked at other Companies
Quant ,Reading and logical reasoning test
(2 Questions)
- Q1. Basic Accounting Questions
- Q2. Cashflow Questions
Interview Preparation Tips
Data Researcher Interview Questions asked at other Companies
(2 Questions)
- Q1. Tell me aboout yourself
- Ans.
I am a detail-oriented professional with experience in derivatives operations and a strong understanding of financial markets.
Experience in processing and reconciling trades in derivatives markets
Proficient in using trading platforms and systems such as Bloomberg and Reuters
Strong analytical skills to identify and resolve discrepancies in trade confirmations
Knowledge of regulatory requirements and compliance in derivat
- Q2. Work experience related basic questions
(1 Question)
- Q1. What is difference between black scholes model and Binomial model ? difference in assumptions also
- Ans.
Black Scholes model is continuous, assumes constant volatility, and does not account for early exercise. Binomial model is discrete, allows for changing volatility, and can handle early exercise.
Black Scholes model is based on continuous time, while Binomial model is based on discrete time steps.
Black Scholes model assumes constant volatility, while Binomial model allows for changing volatility over time.
Black Scholes ...
S&P Global Interview FAQs
Some of the top questions asked at the S&P Global interview -
The duration of S&P Global interview process can vary, but typically it takes about less than 2 weeks to complete.
Recently Viewed
INTERVIEWS
Thrillophilia
No Interviews
INTERVIEWS
GeeksForGeeks
No Interviews
INTERVIEWS
Antino
No Interviews
INTERVIEWS
S&P Global
No Interviews
INTERVIEWS
Nyei Design Services
No Interviews
INTERVIEWS
Emsyne Muthoot Systems Technologies
No Interviews
REVIEWS
S&P Global
No Reviews
INTERVIEWS
TCS iON
No Interviews
REVIEWS
Antino
No Reviews
Tell us how to improve this page.
S&P Global Interviews By Designations
- S&P Global Data Analyst Interview Questions
- S&P Global Data Researcher Interview Questions
- S&P Global Research Analyst Interview Questions
- S&P Global Software Engineer Interview Questions
- S&P Global Research Associate Interview Questions
- S&P Global Software Developer Interview Questions
- S&P Global Financial Analyst Interview Questions
- S&P Global Analyst Interview Questions
- Show more
Interview Questions for Popular Designations
S&P Global Interview Process
based on 236 interviews
Interview experience
Interview Questions from Similar Companies
Fast track your campus placements
S&P Global Reviews and Ratings
based on 2.5k reviews
Rating in categories
|
Data Analyst
1.4k
salaries
|  ₹0 L/yr - ₹0 L/yr |
|
Data Researcher
844
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Senior Software Engineer
681
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Software Engineer
615
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Lead Data Analyst
315
salaries
| ₹0 L/yr - ₹0 L/yr |
Moody's
Thomson Reuters
Bloomberg
Dun & Bradstreet
- Home >
- Interviews >
- S&P Global Interview Questions
