Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Optum Global Solutions Team. If you also belong to the team, you can get access from here

Optum Global Solutions Verified Tick

Compare button icon Compare button icon Compare
4.0

based on 5.8k Reviews

Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards

zig zag pattern zig zag pattern

Filter interviews by

Optum Global Solutions Associate Data Analyst Interview Questions and Answers

Updated 9 Jun 2024

Optum Global Solutions Associate Data Analyst Interview Experiences

6 interviews found

Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
4-6 weeks
Result
Selected Selected

I applied via Recruitment Consulltant and was interviewed before Jun 2023. There were 2 interview rounds.

Round 1 - Coding Test 

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

Round 2 - One-on-one 

(1 Question)

  • 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

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Company Website and was interviewed before Mar 2023. There were 3 interview rounds.

Round 1 - Coding Test 

Simple SQL knowledge test contained questions with options

Round 2 - Technical 

(1 Question)

  • Q1. Writing SQL queries mostly based on joins, subquery, window functions. Difficulty level was intermediate
Round 3 - One-on-one 

(1 Question)

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

Associate Data Analyst Interview Questions Asked at Other Companies

asked in Rapido
Q1. 5. What are stored procedures and when are they used?
asked in Rapido
Q2. 3. What was the finding from the project?
asked in Rapido
Q3. 5. Name three things that your learnt from your Data Science and ... read more
asked in Rapido
Q4. 3. Execute a SQL query to get the top second row.
asked in Internshala
Q5. What is the Execution Order in SQL Queries?
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Referral and was interviewed before Feb 2023. There were 3 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. Basic SQL functions and scenario based questions
Round 2 - Technical 

(1 Question)

  • Q1. SQL and Data warehousing questions of difficulty level 3/5
Round 3 - HR 

(1 Question)

  • Q1. Basic HR questions which contained behavioral round

Interview Preparation Tips

Topics to prepare for Optum Global Solutions Associate Data Analyst interview:
  • SQL
  • Pythone
  • Power BI
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed before Apr 2022. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - One-on-one 

(2 Questions)

  • Q1. 1. Joins 2. Guesstimates 3. Puzzles
  • Q2. Python basics. Read about encapsulation.

Interview Preparation Tips

Interview preparation tips for other job seekers - Freshers be fluent with basic SQL queries.

Optum Global Solutions interview questions for designations

 Associate Data Scientist

 (1)

 Senior Data Analyst

 (3)

 Data Scientist

 (9)

 Senior Data Scientist

 (1)

 Lead Data Scientist

 (1)

 Data Analyst

 (13)

 Associate Business Analyst

 (1)

 Associate Analyst

 (1)

I applied via Recruitment Consulltant and was interviewed before Jun 2021. There were 2 interview rounds.

Round 1 - Coding Test 

Basic js problems and questions about react and node and angular

Round 2 - Technical 

(1 Question)

  • Q1. Db questions and project and front and backend questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Basic js and node js and angular, practice problem solving medium level and understanding flow of web applications

I applied via Referral and was interviewed in May 2021. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. SAS and SQL related questions were asked

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident ans prepare well

Associate Data Analyst Jobs at Optum Global Solutions

View all

Interview questions from similar companies

Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Recruitment Consulltant and was interviewed in Nov 2024. There were 2 interview rounds.

Round 1 - HR 

(2 Questions)

  • Q1. Can you provide an overview of your background, including your past experiences and daily activities, as well as the tools you use in your routine?
  • Q2. What are the concepts of advanced Excel and Power BI projects, and how are they utilized within a company or for clients?
Round 2 - One-on-one 

(2 Questions)

  • Q1. Can you explain your project experience related to Advanced Excel and Power BI?
  • Q2. What are the concepts of credit and operations, particularly in relation to Know Your Customer (KYC) procedures and the privacy of client data?

Interview Preparation Tips

Interview preparation tips for other job seekers - If your resume is shortlisted, then there is a higher chance that you will be selected.
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. What is the importance of data analysis?
  • Q2. What steps should be taken to become a data analyst?
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(3 Questions)

  • Q1. Difference between bagging and boosting
  • Ans. 

    Bagging and boosting are ensemble learning techniques used to improve the performance of machine learning models by combining multiple weak learners.

    • Bagging (Bootstrap Aggregating) involves training multiple models independently on different subsets of the training data and then combining their predictions through averaging or voting.

    • Boosting involves training multiple models sequentially, where each subsequent model c...

  • Answered by AI
  • Q2. Parameters of Decision Tree
  • Ans. 

    Parameters of a Decision Tree include max depth, min samples split, criterion, and splitter.

    • Max depth: maximum depth of the tree

    • Min samples split: minimum number of samples required to split an internal node

    • Criterion: function to measure the quality of a split (e.g. 'gini' or 'entropy')

    • Splitter: strategy used to choose the split at each node (e.g. 'best' or 'random')

  • Answered by AI
  • Q3. Explain any one of your project in detail
  • Ans. 

    Developed a predictive model to forecast customer churn in a telecom company

    • Collected and cleaned customer data including usage patterns and demographics

    • Used machine learning algorithms such as logistic regression and random forest to build the model

    • Evaluated model performance using metrics like accuracy, precision, and recall

    • Provided actionable insights to the company to reduce customer churn rate

  • Answered by AI

Skills evaluated in this interview

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Approached by Company and was interviewed in Sep 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Gave one easy question and asked what will be the output
  • Q2. Leetcode 2 sum question

Interview Preparation Tips

Interview preparation tips for other job seekers - I was pretty much sure that I would pass L1 round and hoping for L2 round. I was interviewing for Generative AI Engineer. It was full 1 hr. The interviewer was less experienced than me. He asked me about my current work and focused more on previous work. I gave 80% correct answers and still did not make it. Don't know what they were expecting from me. Then I thought, maybe they are just taking the interview for the name sake. Sometimes, rejections are baseless.

Optum Global Solutions Interview FAQs

How many rounds are there in Optum Global Solutions Associate Data Analyst interview?
Optum Global Solutions interview process usually has 2-3 rounds. The most common rounds in the Optum Global Solutions interview process are Technical, Coding Test and One-on-one Round.
How to prepare for Optum Global Solutions Associate Data Analyst interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Optum Global Solutions. The most common topics and skills that interviewers at Optum Global Solutions expect are SQL, Base SAS, Data Analysis, MS SQL and MSBI.
What are the top questions asked in Optum Global Solutions Associate Data Analyst interview?

Some of the top questions asked at the Optum Global Solutions Associate Data Analyst interview -

  1. Fibonacci series in pyt...read more
  2. SQL and Data warehousing questions of difficulty level ...read more
  3. Basic SQL functions and scenario based questi...read more

Tell us how to improve this page.

Optum Global Solutions Associate Data Analyst Interview Process

based on 4 interviews

Interview experience

3.8
  
Good
View more

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.4k Interviews
Accenture Interview Questions
3.9
 • 8.1k Interviews
Infosys Interview Questions
3.6
 • 7.6k Interviews
Wipro Interview Questions
3.7
 • 5.6k Interviews
Cognizant Interview Questions
3.8
 • 5.6k Interviews
Capgemini Interview Questions
3.7
 • 4.8k Interviews
Tech Mahindra Interview Questions
3.5
 • 3.8k Interviews
HCLTech Interview Questions
3.5
 • 3.8k Interviews
Genpact Interview Questions
3.8
 • 3k Interviews
LTIMindtree Interview Questions
3.8
 • 3k Interviews
View all
Optum Global Solutions Associate Data Analyst Salary
based on 33 salaries
₹5.5 L/yr - ₹16 L/yr
79% more than the average Associate Data Analyst Salary in India
View more details

Optum Global Solutions Associate Data Analyst Reviews and Ratings

based on 24 reviews

4.0/5

Rating in categories

3.7

Skill development

4.4

Work-life balance

3.8

Salary

4.0

Job security

4.3

Company culture

3.3

Promotions

3.7

Work satisfaction

Explore 24 Reviews and Ratings
Associate Data Analyst

Bangalore / Bengaluru

3-5 Yrs

₹ 10-13.47288 LPA

Associate Data Analyst

Bangalore / Bengaluru

1-4 Yrs

Not Disclosed

Explore more jobs
Claims Associate
4.3k salaries
unlock blur

₹1.6 L/yr - ₹5.6 L/yr

Senior Software Engineer
2.8k salaries
unlock blur

₹9.4 L/yr - ₹29.6 L/yr

Software Engineer
2.6k salaries
unlock blur

₹6.2 L/yr - ₹22 L/yr

Senior Claims Associate
1.2k salaries
unlock blur

₹2.1 L/yr - ₹5.8 L/yr

Medical Coder
1.1k salaries
unlock blur

₹1.5 L/yr - ₹8 L/yr

Explore more salaries
Compare Optum Global Solutions with

Cognizant

3.8
Compare

Accenture

3.8
Compare

IBM

4.0
Compare

TCS

3.7
Compare
Did you find this page helpful?
Yes No
write
Share an Interview