Optum Global Solutions Interview Questions, Process, and Tips

Q1. Import vs direct query
Ans. 
Import vs direct query
• Importing data involves transferring data from a source to a destination, while direct query involves querying data directly from the source.

• Importing data can be useful for offline analysis or data transformation, while direct query is more suitable for real-time analysis.

• Importing data may require additional storage space, while direct query does not necessarily require storage.

• Importing data ca...read more
Answered by AI
Add your answer
Q2. Power bi vs tableau
Ans. 
Power BI and Tableau are both powerful data visualization tools, but they have some key differences.
• Power BI is more user-friendly and integrates well with Microsoft products.

• Tableau is known for its advanced analytics capabilities and flexibility in data visualization.

• Power BI is often preferred by organizations already using Microsoft products, while Tableau is popular among data analysts and data scientists.

• Tableau ...read more
Answered by AI
Add your answer

Q1. Salary expectation
Add your answer
Q2. Notice period negotiation
Add your answer

Q1. How are partitions assigned in Kafka?
Ans. 
Partitions in Kafka are assigned based on the number of partitions specified when creating a topic.
• Partitions are assigned to brokers in a round-robin fashion.

• The number of partitions should be a multiple of the number of brokers to ensure even distribution.

• Reassignment of partitions can be done manually using the Kafka Reassign Partitions tool.
Answered by AI
Add your answer
Q2. Have you ever use terraform?
Ans. 
Yes, I have experience using Terraform for infrastructure as code.
• I have used Terraform to provision and manage infrastructure resources in a declarative manner.

• I have written Terraform configuration files to define the desired state of infrastructure components.

• I have used Terraform to automate the deployment of cloud resources such as virtual machines, storage, and networking.

• I have experience with Terraform modules ...read more
Answered by AI
Add your answer

Introduction about product and background discussion

Objective type question

Q1. Self introduction
Add your answer
Q2. Tell something about u
Ans. Name, completion of gradution, strength, weakness, hobbies
Answered Anonymously
Add your answer
Q3. What do u know about optum
Add your answer
Q4. Explain in brief about optum
Add your answer

Aptitude test is done without any problem

Q1. Ask questions related to human body systems
Add your answer
Q2. How many system in human body
View 1 more answer
Q3. Explain any one system in detail
Add your answer
Q4. Disease related to system
Add your answer

It was the first round of interview and it was conducted for a group of 15 people

They provided test sheets to fill it had verbal logical and arithmetic questions