S&P Global
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
I applied via Approached by Company and was interviewed before Mar 2023. There was 1 interview round.
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
I applied via Recruitment Consulltant and was interviewed before Sep 2022. There were 5 interview rounds.
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).
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.
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.
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
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...
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
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
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...
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
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.
I applied via Company Website and was interviewed in Dec 2021. There were 4 interview rounds.
Java Multiple choice questions and 2 coding questions
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...
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...
What people are saying about S&P Global
I applied via Company Website and was interviewed before Jul 2023. There was 1 interview round.
S&P Global interview questions for popular designations
I applied via Walk-in and was interviewed before Nov 2022. There were 4 interview rounds.
Written test of 50 marks
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
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, ...
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.
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.
Write a code to achieve some logic using the selenium framework.
I applied via Naukri.com and was interviewed before Apr 2023. There were 3 interview rounds.
Maths, analytical , English
One topic is given . Give brief and logical answer
I applied via Campus Placement and was interviewed before Oct 2022. There were 4 interview rounds.
Read a case and answer questions based on that
I applied via Referral and was interviewed before Jul 2023. There was 1 interview round.
Medium level leet code test
I applied via Walk-in and was interviewed before Jan 2023. There were 3 interview rounds.
English Language, Excel and word shortcuts,
Interview experience
based on 2.4k reviews
Rating in categories
Gurgaon / Gurugram
10-20 Yrs
Not Disclosed
Data Analyst
1.4k
salaries
| ₹2 L/yr - ₹10.1 L/yr |
Data Researcher
932
salaries
| ₹2 L/yr - ₹9 L/yr |
Senior Software Engineer
662
salaries
| ₹11 L/yr - ₹40 L/yr |
Software Engineer
628
salaries
| ₹9.7 L/yr - ₹36.5 L/yr |
Research Analyst
311
salaries
| ₹3 L/yr - ₹13 L/yr |
Moody's
Thomson Reuters
Bloomberg
Dun & Bradstreet