S&P Global
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
Clear (1)
I was interviewed before Feb 2024.
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...
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.
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.
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
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.
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.
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
posted on 14 Jun 2024
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
I applied via LinkedIn and was interviewed in Apr 2021. There were 3 interview rounds.
I applied via Naukri.com and was interviewed before Jul 2020. There were 4 interview rounds.
I applied via Approached by Company and was interviewed in Aug 2021. There was 1 interview round.
I applied via Recruitment Consulltant and was interviewed in Jan 2022. There were 3 interview rounds.
posted on 8 Apr 2022
I applied via Naukri.com and was interviewed before Apr 2021. There were 3 interview rounds.
Aptitude test will a hackerrank test where it might have technical MCQ and/or coding test.
Some of the top questions asked at the S&P Global Software Development Engineer II interview -
based on 2 interviews
Interview experience
based on 5 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
676
salaries
| ₹0 L/yr - ₹0 L/yr |
Software Engineer
614
salaries
| ₹0 L/yr - ₹0 L/yr |
Lead Data Analyst
313
salaries
| ₹0 L/yr - ₹0 L/yr |
Moody's
Thomson Reuters
Bloomberg
Dun & Bradstreet