i
Optum Global Solutions
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
I was interviewed in Jun 2024.
To get the 3rd highest salary, you can use a SQL query with the 'LIMIT' and 'OFFSET' keywords.
Use a SQL query to select distinct salaries in descending order.
Use the 'LIMIT' keyword to limit the results to 3.
Use the 'OFFSET' keyword to skip the first 2 highest salaries.
Example: SELECT DISTINCT salary FROM employees ORDER BY salary DESC LIMIT 1 OFFSET 2;
The inner join of two tables with duplicate values results in a combined set of common values.
Inner join combines rows from both tables where the key columns match
In this case, the result would be [1,1,1,1,1,1] as all values are common in both tables
Developed a web application for tracking and managing project tasks
Used React.js for front-end development
Implemented RESTful APIs using Node.js and Express
Utilized MongoDB for database management
Incorporated authentication and authorization features for user security
SQL is a relational database management system, while NoSQL is a non-relational database management system.
SQL databases are table-based, NoSQL databases are document, key-value, graph, or wide-column stores
SQL databases use structured query language for defining and manipulating data, NoSQL databases use different query languages
SQL databases are vertically scalable, NoSQL databases are horizontally scalable
SQL databa...
NoSQL is better for handling unstructured data, providing scalability and flexibility.
NoSQL databases are better suited for handling unstructured data like social media posts, user-generated content, and IoT data.
NoSQL databases provide better scalability as they can easily distribute data across multiple servers, allowing for horizontal scaling.
NoSQL databases offer more flexibility in terms of data model, allowing fo...
Designed and implemented a real-time data pipeline for processing and analyzing user behavior data.
Used Apache Kafka for real-time data streaming
Utilized Apache Spark for data processing and analysis
Implemented data transformations and aggregations using Scala
Stored processed data in a data warehouse like Amazon Redshift
Built monitoring and alerting systems to ensure data pipeline reliability
I would address the conflict directly and professionally, seeking to understand the root cause and find a mutually beneficial solution.
Schedule a private meeting with the manager to discuss the conflict
Listen actively to the manager's perspective and express your own calmly
Seek to find common ground and propose potential solutions
If necessary, involve HR or a mediator to help resolve the conflict
I love to spend my free time hiking, reading, and trying out new recipes in the kitchen.
Hiking in the mountains or local trails
Reading fiction and non-fiction books
Experimenting with new recipes and cooking techniques
I applied via Naukri.com and was interviewed in Sep 2024. There was 1 interview round.
Optum Global Solutions interview questions for designations
I applied via Referral and was interviewed before Oct 2023. There was 1 interview round.
SQL, ADF questions were asked, previous work exp
I applied via Referral and was interviewed before May 2023. There were 2 interview rounds.
Basic coding questions related to programming
I applied via Recruitment Consulltant and was interviewed before Oct 2022. There were 4 interview rounds.
I applied via Naukri.com and was interviewed before Oct 2021. There were 2 interview rounds.
I applied via Job Fair and was interviewed before Oct 2022. There were 4 interview rounds.
I applied via Naukri.com and was interviewed in Jul 2022. There was 1 interview round.
Indexes are used to improve database performance. Clustered indexes determine the physical order of data, while non-clustered indexes do not.
Indexes are used to speed up data retrieval operations in a database.
Clustered indexes determine the physical order of data in a table, while non-clustered indexes do not.
A table can have only one clustered index, but multiple non-clustered indexes.
Clustered indexes are generally ...
Query to delete duplicate rows from a table
Use GROUP BY clause to group the rows by their unique values
Use HAVING clause to filter out the groups with count greater than 1
Use DELETE statement to delete the duplicate rows
Singleton pattern restricts the instantiation of a class to a single instance and provides a global point of access to it.
Create a private constructor to restrict instantiation of the class
Create a private static instance of the class
Create a public static method to access the instance
Ensure thread safety if necessary
Examples: Database connection, Logger, Configuration settings
Handle exceptions in stored procedures by using TRY-CATCH blocks.
Use TRY-CATCH blocks to catch and handle exceptions
Log the error message and severity level
Rollback the transaction if necessary
Rethrow the error if it cannot be handled
Use RAISERROR to raise custom error messages
SOLID principles are a set of five design principles that help in creating maintainable and scalable software.
S - Single Responsibility Principle: A class should have only one reason to change.
O - Open-Closed Principle: Software entities should be open for extension but closed for modification.
L - Liskov Substitution Principle: Subtypes should be substitutable for their base types.
I - Interface Segregation Principle: C...
throw is used to throw an exception while throw exception is used to throw a specific exception.
throw is used to throw any type of exception while throw exception is used to throw a specific type of exception.
throw exception is followed by the type of exception that needs to be thrown.
throw can be used to throw any object while throw exception can only be used to throw an exception object.
Example: throw new Exception("
Interview experience
based on 72 reviews
Rating in categories
Claims Associate
1k
salaries
| ₹1.7 L/yr - ₹5 L/yr |
Senior Software Engineer
622
salaries
| ₹9 L/yr - ₹30 L/yr |
Software Engineer
440
salaries
| ₹5.1 L/yr - ₹20.1 L/yr |
Senior Claims Associate
369
salaries
| ₹2.3 L/yr - ₹5.5 L/yr |
Senior Associate
147
salaries
| ₹2.5 L/yr - ₹5.5 L/yr |
Cognizant
Accenture
IBM
TCS