Optum Global Solutions Interview Questions, Process, and Tips

It had mcq and 1 hard coding question

Q1. They asked me about backtracking and dp series problem and also to solve the given question
Add your answer
Q2. Java and in depth about different pillars of java
Add your answer

Q1. Can you tell me about yourself?
Add your answer
Q2. What are your strengths and weaknesses?
Ans. 
Strengths include problem-solving skills and adaptability. Weaknesses include perfectionism and time management.
• Strengths: problem-solving skills, adaptability

• Weaknesses: perfectionism, time management

• Example: I excel at quickly identifying and resolving complex technical issues, but I sometimes struggle with prioritizing tasks effectively.
Answered by AI
Add your answer

Q1. What are the types of relationships in Database Management Systems (DBMS)?
Ans. 
Types of relationships in DBMS include one-to-one, one-to-many, and many-to-many relationships.
• One-to-one relationship: Each record in one table is related to only one record in another table.

• One-to-many relationship: Each record in one table can be related to multiple records in another table.

• Many-to-many relationship: Multiple records in one table can be related to multiple records in another table.

• Examples: One-to-o...read more
Answered by AI
Add your answer
Q2. What is the concept of a pointer in programming?
Ans. 
A pointer in programming is a variable that stores the memory address of another variable.
• Pointers allow for direct manipulation of memory locations

• They are commonly used in languages like C and C++

• Example: int *ptr; ptr = # // ptr now points to the memory address of num
Answered by AI
Add your answer

Q1. About your self
Add your answer
Q2. What you learned in recently
Add your answer

Typing test should have 30 with 90% accuracy

Q1. Whats your strength and weakness and lots of basic things
Add your answer
Q2. Why you want join this company
Add your answer

Q1. Explain about yourself.
Ans. 
I am a Senior Data Engineer with 5+ years of experience in designing and implementing data pipelines for large-scale projects.
• Experienced in ETL processes and data warehousing

• Proficient in programming languages like Python, SQL, and Java

• Skilled in working with big data technologies such as Hadoop, Spark, and Kafka

• Strong understanding of data modeling and database management

• Excellent problem-solving and communication sk
Answered by AI
Add your answer
Q2. Explain about your current project.
Ans. 
Developing a real-time data processing system for analyzing customer behavior on e-commerce platform.
• Utilizing Apache Kafka for real-time data streaming

• Implementing Spark for data processing and analysis

• Creating machine learning models for customer segmentation

• Integrating with Elasticsearch for data indexing and search functionality
Answered by AI
Add your answer
Q3. Big data concept
Add your answer
Q4. Spark related questions
Add your answer

Q1. How many systems are in human body ellobarate any one system
Add your answer
Q2. What is diabetes mellitus and types
Add your answer
Q3. What is meant ectomy, itis, otomy
Add your answer
Q4. Explain anatomy of the heart
Add your answer
Q5. What are coronary arteries and there types
Add your answer
Q6. Prepare basic physiology questions
Add your answer

Q1. What factors influenced your decision to pursue a career in medical coding?
Add your answer
Q2. What are the different body systems present in the human body?
Add your answer