Optum Global Solutions Associate Data Analyst Interview Questions and Answers

Simple SQL knowledge test contained questions with options

Q1. Writing SQL queries mostly based on joins, subquery, window functions. Difficulty level was intermediate
Add your answer

Q1. Final round was with the hiring Manager. He/She will test your behavioural skills and whether you are fit for this role.
Add your answer

Q1. Basic SQL functions and scenario based questions
Add your answer

Q1. SQL and Data warehousing questions of difficulty level 3/5
Add your answer

Q1. Basic HR questions which contained behavioral round
Add your answer

Coding questions were asked and if we complete half of the program they will shortlist

Q1. Fibonacci series in python
Ans. 
Fibonacci series in Python is a sequence of numbers where each number is the sum of the two preceding ones.
• Use a loop to generate the Fibonacci series.

• Start with two initial numbers (0 and 1) and add them to get the next number in the series.

• Repeat this process to generate the entire series.
Answered by AI
Add your answer

Q1. 1. Joins 2. Guesstimates 3. Puzzles
Add your answer
Q2. Python basics. Read about encapsulation.
Add your answer