AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Optum Global Solutions
CompareProud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
Optum Global Solutions Data Engineer Interview Questions and Answers
Optum Global Solutions Data Engineer Interview Experiences
7 interviews found
Anonymous
Asked me two string array question one was to reverse a string without any pre build function and second one was a medium question to print the number and the count of it into the next level of the tree
(2 Questions)
- Q1. Who is your idol?
- Q2. How do you menage your work?
- Ans.
I manage my work by prioritizing tasks, setting goals, staying organized, and communicating effectively with team members.
Prioritize tasks based on deadlines and importance
Set clear goals and milestones to track progress
Stay organized with tools like project management software
Communicate effectively with team members to ensure alignment and collaboration
I applied via Referral and was interviewed in Oct 2023. There was 1 interview round.
(3 Questions)
- Q1. RDD, Datafram, dataset difference
- Q2. Find the 2nd hightest salary
- Q3. What is ADF in azure
- Ans.
ADF in Azure stands for Azure Data Factory, a cloud-based data integration service that allows you to create, schedule, and manage data pipelines.
Azure Data Factory (ADF) is used to orchestrate and automate data movement and data transformation.
It supports a wide range of data sources, including Azure Blob Storage, Azure SQL Database, and on-premises data sources.
ADF allows you to create data pipelines using a visual i...
Skills evaluated in this interview
Prime Number, Oops, SQL Coding
(1 Question)
- Q1. Spark, Big Data, Python, SQL
Interview Preparation Tips
What people are saying about Optum Global Solutions
Selected
I applied via Referral and was interviewed before Oct 2022. There were 2 interview rounds.
(2 Questions)
- Q1. SQL basics and window functions
- Q2. Python basics and and cloud technology
Interview Preparation Tips
Optum Global Solutions interview questions for designations
I applied via Recruitment Consultant and was interviewed in Sep 2021. There was 1 interview round.
Interview Questionnaire
3 Questions
- Q1. Sql join with data given and predict output from the given inputs
- Q2. Query using sql case conditions
- Q3. Query using sql window functions
- Ans.
SQL window functions allow for calculations over a specific subset of data.
Window functions are used to perform calculations over a specific subset of data
They are used with the OVER() clause and can be used with aggregate functions
Examples include ROW_NUMBER(), RANK(), and LAG()
They are useful for calculating running totals, rankings, and comparing values across rows
Interview Preparation Tips
Skills evaluated in this interview
I applied via Naukri.com and was interviewed in Apr 2021. There were 3 interview rounds.
Interview Questionnaire
4 Questions
- Q1. Questions on ETL, case statements to handle failures
- Q2. Basic SQL questions
- Q3. Basics of Python & Libraries
- Q4. Unix Commands
Interview Preparation Tips
I applied via Naukri.com and was interviewed in Apr 2021. There were 4 interview rounds.
Interview Questionnaire
1 Question
- Q1. I was asked regarding my project and about the tool
Interview Preparation Tips
Interview questions from similar companies
I appeared for an interview before Jul 2021.
(4 Questions)
- Q1. What is Polymorphism and it’s type?
- Ans.
Polymorphism is the ability of an object to take on many forms. It allows objects of different classes to be treated as if they were of the same class.
Polymorphism is achieved through method overriding and method overloading.
Method overriding is when a subclass provides a specific implementation of a method that is already provided by its parent class.
Method overloading is when a class has two or more methods with the ...
- Q2. What is Dependency Injection?
- Ans.
Dependency Injection is a design pattern where the dependencies of an object are injected into it rather than created within it.
It helps in achieving loose coupling between objects
It makes testing easier as dependencies can be mocked or stubbed
There are three types of Dependency Injection - Constructor Injection, Setter Injection, and Interface Injection
Example: In a web application, the database connection object can ...
- Q3. How Garbage Collection works in .Net?
- Ans.
Garbage Collection in .Net automatically manages memory by freeing up unused objects.
Garbage Collector runs in the background and periodically checks for unused objects.
It frees up memory by deallocating objects that are no longer being used.
GC can be configured using different modes like Server, Workstation, Concurrent, etc.
GC can also be manually triggered using GC.Collect() method.
GC.SuppressFinalize() method can be...
- Q4. What is LINQ and some basic concept related it?
Interview Preparation Tips
Skills evaluated in this interview
I applied via Campus Placement and was interviewed before Jul 2021. There were 3 interview rounds.
In this round we have aptitude plus coding mcq questions
Here we have to write full fledge code 2 questions were there and are easy
(1 Question)
- Q1. Here we have hr plus technical interview
Interview Preparation Tips
I applied via Company Website and was interviewed in May 2021. There were 3 interview rounds.
Interview Questionnaire
2 Questions
- Q1. Why you wanna work in our company?
- Q2. Wh
Interview Preparation Tips
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 Software Engineer Interview Questions
- Optum Global Solutions Medical Coder Interview Questions
- Optum Global Solutions Clinical Investigator Interview Questions
- Optum Global Solutions Software Developer Interview Questions
- Optum Global Solutions Senior Software Engineer Interview Questions
- Optum Global Solutions Associate Software Engineer Interview Questions
- Optum Global Solutions Data Analyst Interview Questions
- Show more
Interview Questions for Popular Designations
- Senior Data Engineer Interview Questions
- Big Data Engineer Interview Questions
- Software Engineer Interview Questions
- Senior Software Engineer Interview Questions
- Database Admin Interview Questions
- Data Analyst Interview Questions
- System Engineer Interview Questions
- Associate Software Engineer Interview Questions
- Show more
Optum Global Solutions Data Engineer Interview Process
based on 3 interviews
1 Interview rounds
- Technical Round
Data Engineer Interview Questions from Similar Companies
Fast track your campus placements
Optum Global Solutions Data Engineer Reviews and Ratings
based on 36 reviews
Rating in categories
|
Claims Associate
4.3k
salaries
|  ₹1 L/yr - ₹5.1 L/yr |
|
Senior Software Engineer
2.9k
salaries
| ₹9.5 L/yr - ₹32 L/yr |
|
Software Engineer
2.7k
salaries
| ₹5.3 L/yr - ₹18.4 L/yr |
|
Medical Coder
1.3k
salaries
| ₹1.5 L/yr - ₹8 L/yr |
|
Senior Claims Associate
1.2k
salaries
| ₹2.1 L/yr - ₹6 L/yr |
Accenture
Wipro
Cognizant
Capgemini
- Home >
- Interviews >
- Optum Global Solutions Interview Questions >
- Optum Global Solutions Data Engineer Interview Questions
