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

Filter interviews by

Clear (1)

Optum Global Solutions Business Analyst Interview Questions and Answers

Updated 11 Sep 2024

Optum Global Solutions Business Analyst Interview Experiences

1 interview found

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

They start with sequel then slide you move to python

Round 2 - Aptitude Test 

Start with aptitude test and asking to detail regarding the study case

Business Analyst Jobs at Optum Global Solutions

View all

Interview questions from similar companies

Interview Questionnaire 

3 Questions

  • Q1. About my self and my experience.
  • Q2. What's the reason for leaving previous job?
  • Q3. Technical question depends on process.

I applied via Walk-in and was interviewed before Jun 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Da tools

Interview Preparation Tips

Interview preparation tips for other job seekers - Get referal

I applied via Company Website and was interviewed before Jun 2020. There were 4 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Python data structures
  • Q2. MongoDB database algorithms
  • Ans. 

    MongoDB database algorithms are used for efficient data storage, retrieval, and processing.

    • MongoDB uses various algorithms for indexing, sharding, and aggregation.

    • Indexing algorithms include B-tree, hash, and text search indexes.

    • Sharding algorithms include range-based, hash-based, and zone-based sharding.

    • Aggregation algorithms include map-reduce and aggregation pipeline.

    • MongoDB also uses algorithms for query optimizati

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepared with your basics

Skills evaluated in this interview

I was interviewed before Dec 2020.

Round 1 - Coding Test 

(1 Question)

Round duration - 120 Minutes
Round difficulty - Medium

  • Q1. 

    Ninja and His Secret Information Encoding Problem

    Ninja, a new member of the FBI, has acquired some 'SECRET_INFORMATION' that he needs to share with his team. To ensure security against hackers, Ninja dec...

  • Ans. 

    The task is to encode and decode 'SECRET_INFORMATION' for security purposes and determine if the transmission was successful.

    • Read the number of test cases 'T'

    • For each test case, encode the 'SECRET_INFORMATION' and then decode it

    • Compare the decoded string with the original 'SECRET_INFORMATION'

    • Print 'Transmission successful' if they match, else print 'Transmission failed'

  • Answered by AI
Round 2 - Face to Face 

(1 Question)

Round duration - 60 Minutes
Round difficulty - Medium

  • Q1. 

    Equilibrium Index Problem Statement

    Given an array Arr consisting of N integers, your task is to find the equilibrium index of the array.

    An index is considered as an equilibrium index if the sum of elem...

  • Ans. 

    Find the equilibrium index of an array where sum of elements on left equals sum on right.

    • Iterate through the array and calculate prefix sum and suffix sum at each index.

    • Compare prefix sum and suffix sum to find equilibrium index.

    • Return the left-most equilibrium index or -1 if none found.

  • Answered by AI
Round 3 - HR 

Round duration - 50 Minutes
Round difficulty - Easy

Interview Preparation Tips

Professional and academic backgroundI applied for the job as Data Analyst in PuneEligibility criteria7 CGPACapgemini interview preparation:Topics to prepare for the interview - Data Structures, OOPS, SQL, Python, JavaTime required to prepare for the interview - 1 MonthInterview preparation tips for other job seekers

Tip 1 : Focus more on SQL
Tip 2 : Keep up with ongoing projects in the company

Application resume tips for other job seekers

Tip 1 : Be honest about what you add.
Tip 2 : Don't forget to mention extra curriculars.

Final outcome of the interviewSelected

Skills evaluated in this interview

I applied via Walk-in and was interviewed before Aug 2021. 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 Resume tips
Round 2 - Technical 

(1 Question)

  • Q1. How to transpose data set
  • Ans. 

    Transposing a data set involves flipping rows and columns.

    • Identify the data set to be transposed

    • Create a new table with the columns and rows flipped

    • Copy the data from the original table to the new table

    • Transpose can be done using Excel, Python, R, SQL, etc.

    • Example: Transposing a table of sales data to have products as rows and months as columns

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Was asked hard hitting questions by interviewer. Ultimately failed

I applied via Recruitment Consultant and was interviewed in Aug 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Prior experience,questions related to data analysis tools.

Interview Preparation Tips

Interview preparation tips for other job seekers - Interview process is fast,mine got done in a day but if you are selected and your salary negotiation is finished, it will take almost a month to get offer letter,so need not worry till that time you will surely get it.
The reason behind the offer letter delay is they have to get approvals from multiple teams which creates a delay on the process.

I applied via Naukri.com and was interviewed before Aug 2021. 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 Resume tips
Round 2 - Technical 

(1 Question)

  • Q1. What is Structured Query Language?
  • Ans. 

    Structured Query Language (SQL) is a programming language used to manage and manipulate relational databases.

    • SQL is used to create, modify, and delete databases, tables, and data

    • It is used to retrieve data from databases using queries

    • SQL is used to perform operations on data such as sorting, filtering, and grouping

    • Examples of SQL-based database management systems include MySQL, Oracle, and Microsoft SQL Server

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - My Goal is to get the Job as a Data Analyst or Business analyst

Skills evaluated in this interview

I was interviewed in Aug 2017.

Interview Preparation Tips

Round: Group Discussion
Experience: every one put their views
Tips: just tell anything. no one listen
Duration: 5 minutes

Round: Test
Experience: online test
Tips: do those question which can be solved without usingpen paper first
Duration: 5 minutes
Total Questions: 50

Skills: Relieving Pressure

I was interviewed in Sep 2016.

Interview Questionnaire 

2 Questions

  • Q1. Behavioral questions, what will you choose knowledge or money?Why?, etc . Other curricular activities that showcase your managerial skills, etc
  • Q2. Focused on projects from resume and cross questioning. Can ask you about the tools or languages related questions if you have added that to CV. Followed by guesstimates where you will have to provide detai...

Interview Preparation Tips

Round: Technical + HR Interview
Tips: It is advantageous if you have prior experience with data handling tools eg advanced EXCEL , SPSS

Contribute & help others!
anonymous
You can choose to be anonymous

Optum Global Solutions Interview FAQs

How many rounds are there in Optum Global Solutions Business Analyst interview?
Optum Global Solutions interview process usually has 2 rounds. The most common rounds in the Optum Global Solutions interview process are Coding Test and Aptitude Test.
How to prepare for Optum Global Solutions Business 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 Business Analytics, Data Analysis, Data Analytics, Data Modeling and Data Reporting.

Recently Viewed

INTERVIEWS

Jio Platforms

No Interviews

INTERVIEWS

Prama Hikvision India

No Interviews

INTERVIEWS

Amphenol Omniconnect - India

No Interviews

INTERVIEWS

Expeditors International

5.6k top interview questions

INTERVIEWS

MCM Telecom Equipment

No Interviews

INTERVIEWS

Hindustan Coca Cola Beverages

No Interviews

INTERVIEWS

Afcons Infrastructure

No Interviews

JOBS

Hindustan Coca Cola Beverages

No Jobs

INTERVIEWS

Atlas Copco

No Interviews

INTERVIEWS

Lava International

No Interviews

Tell us how to improve this page.

Optum Global Solutions Business Analyst Interview Process

based on 2 interviews

Interview experience

4.5
  
Good
View more
Optum Global Solutions Business Analyst Salary
based on 247 salaries
₹4.9 L/yr - ₹17 L/yr
14% more than the average Business Analyst Salary in India
View more details

Optum Global Solutions Business Analyst Reviews and Ratings

based on 34 reviews

3.9/5

Rating in categories

3.8

Skill development

4.1

Work-life balance

3.3

Salary

4.1

Job security

3.7

Company culture

3.2

Promotions

3.8

Work satisfaction

Explore 34 Reviews and Ratings
Business Analyst

Noida

2-5 Yrs

Not Disclosed

Explore more jobs
Claims Associate
4.3k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Software Engineer
2.8k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Engineer
2.6k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Medical Coder
1.2k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Claims Associate
1.2k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Optum Global Solutions with

Cognizant

3.7
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
Rate your experience using AmbitionBox
Terrible
Terrible
Poor
Poor
Average
Average
Good
Good
Excellent
Excellent