Add office photos
i
Optum Global Solutions
CompareProud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
Optum Global Solutions Data Analyst Interview Questions and Answers
Optum Global Solutions Data Analyst Interview Experiences
7 interviews found
Selected
I applied via Naukri.com and was interviewed before Oct 2023. There were 2 interview rounds.
(2 Questions)
- Q1. Structured query language
- Q2. Python and Java and R
(2 Questions)
- Q1. Mangerial Ronund
- Q2. Salary expectations
Selected
I applied via Referral and was interviewed before May 2023. There were 2 interview rounds.
(2 Questions)
- Q1. Adobe Analytics basics
- Q2. What does your day look like at your current role
(2 Questions)
- Q1. Questions on a website - what would you do to make it better?
- Q2. How would you personalize experience for users?
- Ans.
Personalizing user experience involves analyzing data to understand user preferences and behavior, then tailoring content and recommendations accordingly.
Collect and analyze user data such as browsing history, purchase history, and demographic information
Use machine learning algorithms to predict user preferences and behavior
Tailor content recommendations, product suggestions, and marketing messages based on user data
I...
Interview Preparation Tips
Health are related ques and puzzles also there .
(2 Questions)
- Q1. Sql based ques logical puzzles
- Q2. Where vs having drop delete truncate
- Ans.
Where, Drop, Delete, Truncate are SQL commands used for manipulating data in a database.
WHERE is used to filter data based on a condition
DROP is used to delete an entire table or database
DELETE is used to remove specific rows from a table
TRUNCATE is used to remove all rows from a table
All these commands are used to manipulate data in a database
Interview Preparation Tips
Skills evaluated in this interview
Selected
I was interviewed before May 2023.
(2 Questions)
- Q1. Advance SQL questions
- Q2. Python questions
Optum Global Solutions interview questions for designations
Selected
I applied via Company Website and was interviewed before Feb 2023. There was 1 interview round.
(2 Questions)
- Q1. What are different types of joins?
- Ans.
Different types of joins include inner join, left join, right join, and full outer join.
Inner join returns only the matching records from both tables.
Left join returns all records from the left table and the matching records from the right table.
Right join returns all records from the right table and the matching records from the left table.
Full outer join returns all records when there is a match in either left or rig
- Q2. Difference between Rank and dense rank?
- Ans.
Rank assigns unique numbers to each row, while dense rank assigns consecutive numbers to rows with the same values.
Rank is used to assign a unique number to each row based on the order specified.
Dense rank is used to assign consecutive numbers to rows with the same values.
Rank leaves gaps between the numbers if there are ties, while dense rank does not.
For example, if we have a dataset with scores of students, rank wil...
Interview Preparation Tips
Skills evaluated in this interview
I applied via Campus Placement and was interviewed in Oct 2021. There were 4 interview rounds.
Basic cat type questions
(1 Question)
- Q1. Basics about python, some queries about SQL , something about machine learning
(4 Questions)
- Q1. What is your family background?
- Q2. Why are you looking for a change?
- Q3. Why should we hire you?
- Q4. Tell me about yourself.
Interview Preparation Tips
- Machines learning
I applied via Campus Placement and was interviewed in Oct 2021. There were 4 interview rounds.
Basic cat type questions
(1 Question)
- Q1. Basics about python, some queries about SQL , something about machine learning
(4 Questions)
- Q1. What is your family background?
- Q2. Why are you looking for a change?
- Q3. Why should we hire you?
- Q4. Tell me about yourself.
Interview Preparation Tips
- Machines learning
Interview questions from similar companies
I applied via Recruitment Consulltant and was interviewed in Mar 2024. There were 2 interview rounds.
(2 Questions)
- Q1. All SQL Question
- Q2. Related Join write query and Basic SQL
Python Leetcode Question they ask
Interview Preparation Tips
I applied via Naukri.com and was interviewed in Oct 2023. There were 4 interview rounds.
Create the table for consolidated.sql and enter the records as specified in it.
Close attention to what other's are saying.This shows respect for their opinions and allows you to build on or respond to their points.
(4 Questions)
- Q1. Start with a clear concise introduction.Briefly mention you name and the purpose of the discussion. this sets the tone and provides context
- Q2. If there's anything you're unsure about or if you need clarification, don't hesitate to ask it shows that you are engaged and interested in the conversation
- Ans.
Asking for clarification shows engagement and interest in the conversation.
Asking for clarification demonstrates active listening and a desire to fully understand the topic.
It can also help clarify any misunderstandings or uncertainties, leading to more productive discussions.
Examples: 'Could you please explain that concept in more detail?' or 'I'm not sure I understand, could you provide an example?'
- Q3. If you were faced with a specific challenge what steps would you take to address it
- Q4. How have your previous roles prepare you for this position
Interview Preparation Tips
Data Analyst Interview Questions & Answers
Societe Generale Global Solution Centre
Anonymous
posted on 13 Apr 2024
(2 Questions)
- Q1. Self introduction
- Q2. Previous job experiences
Optum Global Solutions Interview FAQs
Tell us how to improve this page.
Optum Global Solutions Interviews By Designations
- Optum Global Solutions Claims Associate Interview Questions
- Optum Global Solutions Clinical Investigator Interview Questions
- Optum Global Solutions Associate Software Engineer Interview Questions
- Optum Global Solutions Senior Software Engineer Interview Questions
- Optum Global Solutions Data Analyst Interview Questions
- Optum Global Solutions Medical Coder Interview Questions
- Optum Global Solutions Medical Coding Analyst Interview Questions
- Optum Global Solutions Software Developer Interview Questions
- Show more
Optum Global Solutions Data Analyst Interview Process
based on 4 interviews in last 1 year
1 Interview rounds
- Technical Round
People are getting interviews through
Data Analyst Interview Questions from Similar Companies
Fast track your campus placements
Optum Global Solutions Data Analyst Reviews and Ratings
based on 28 reviews
Rating in categories
|
Claims Associate
1k
salaries
|  ₹1.8 L/yr - ₹4.6 L/yr |
|
Senior Software Engineer
617
salaries
| ₹9.4 L/yr - ₹30 L/yr |
|
Software Engineer
433
salaries
| ₹5.1 L/yr - ₹20.1 L/yr |
|
Senior Claims Associate
369
salaries
| ₹2.3 L/yr - ₹5.5 L/yr |
|
Senior Associate
149
salaries
| ₹2.5 L/yr - ₹5.5 L/yr |
Cognizant
Accenture
IBM
TCS
Calculate your in-hand salary
- Home >
- Interviews >
- Optum Global Solutions Interview Questions >
- Optum Global Solutions Data Analyst Interview Questions
