Optum Global Solutions Software Engineer Interview Questions, Process, and Tips

Q1. Able to answer scenario based question
Ans. Data base performance tuning Code is not working Data is not getting populated correctly
Answered Anonymously
Add your answer
Q2. How to do ETL Design
Ans. 
ETL design involves identifying data sources, defining data transformations, and selecting a target system for loading the transformed data.
• Identify data sources and determine the data to be extracted

• Define data transformations to convert the extracted data into the desired format

• Select a target system for loading the transformed data

• Consider scalability, performance, and data quality issues

• Use ETL tools such as Inform...read more
Answered by AI
Add your answer

Pattern: 2 coding questions and few technical+non-technical mcqs
platform: Mettl .com

Q1. 1 Coding Ques was asked and Some concept of OOPs, Networking and DBMS. And discussion on projects and internship.
Add your answer
Q2. Arrange the array in decreasing order without extra space and without sort function & reverse function.
Ans. 
Use bubble sort algorithm to rearrange the array in decreasing order.
• Iterate through the array and compare adjacent elements, swapping them if they are in the wrong order.

• Repeat this process until the array is sorted in decreasing order.

• Example: ['apple', 'banana', 'cherry'] -> ['cherry', 'banana', 'apple']
Answered by AI
Add your answer
Q3. What is encapsulation, TDP, UDP, Normalization etc
Ans. 
Encapsulation is the concept of bundling data and methods that operate on the data into a single unit.
• Encapsulation helps in hiding the internal state of an object and restricting access to it.

• It allows for better control over the data by preventing direct access from outside the class.

• Example: In object-oriented programming, classes are used to implement encapsulation by combining data attributes and methods.

• TDP stand...read more
Answered by AI
Add your answer
Q4. Asked about projects and Internship
Add your answer

Q1. Mostly from resume
Add your answer

Q1. Core java, spring, junits, sql, docker, kubernates
Add your answer

Round duration - 75 minutes
Round difficulty - Hard

There was a coding question for 50 marks which had two given test cases and 15 hidden test cases. With some basic knowledge of coding you'll be able to do it.
25 questions were there for 1 mark each on all the concepts of Computer Science.

Q1. 
Armstrong Number Problem Statement
You are provided an integer 'NUM'. Determine if 'NUM' is an Armstrong number.
Explanation:
An integer 'NUM' with 'k' digits is an Armstrong number if the sum of its di...read more
Add your answer

Round duration - 60 Minutes
Round difficulty - Medium

I got the time slot of noon 12. The interviewer was very friendly. Asked some casual questions like how are you doing in these COVID Times and about hobbies to make me comfortable. Then asked me to give my introduction.Then proceeded with the technical questions. 

Round duration - 15 Minutes
Round difficulty - Easy

It was a simple round where the HR asked about my interests and hobbies. Asked my preferred location and explained about my compensation.