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

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
Add your answer
Q2. Distributed computing and spark questions
Add your answer

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
Add your answer
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
Add your answer
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
Add your answer
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
Add your answer
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...read more
Answered by AI
View 1 more answer
Q6. Question related to unpivot operation, department wise salary and duplicates ?
Add your answer

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
Add your answer
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
Add your answer
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...read more
Answered by AI
Add your answer
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
Add your answer
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
Add your answer
Q6. Questions related to performance improvements and will give scenrios for identify the better performance queries?
Add your answer

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.
Add your answer

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.
Add your answer

Java Multiple choice questions and 2 coding 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...read more
Answered by AI
Add your answer
Q2. Multithreading environment
Add your answer
Q3. 2 coding questions and reduce its complexity
Add your answer

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...read more
Answered by AI
Add your answer

Q1. EPS and Diluted EPS
Add your answer

Written test of 50 marks

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
Add your answer
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, ...read more
Answered by AI
Add your answer
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
Add your answer

Q1. General details of education and my background.
Add your answer

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

Q1. It was more about project management and the challenges faced.
Add your answer