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

Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards

zig zag pattern zig zag pattern

Filter interviews by

Optum Global Solutions Data Engineer Interview Questions and Answers

Updated 19 Oct 2024

Optum Global Solutions Data Engineer Interview Experiences

7 interviews found

Data Engineer Interview Questions & Answers

user image Anonymous

posted on 19 Oct 2024

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

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

Round 2 - HR 

(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

  • Answered by AI

Data Engineer Interview Questions & Answers

user image Anonymous

posted on 18 Apr 2024

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Referral and was interviewed in Oct 2023. There was 1 interview round.

Round 1 - Technical 

(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...

  • Answered by AI

Skills evaluated in this interview

Data Engineer Interview Questions Asked at Other Companies

asked in Cisco
Q1. Optimal Strategy for a Coin Game You are playing a coin game with ... read more
asked in Sigmoid
Q2. Next Greater Element Problem Statement You are given an array arr ... read more
asked in Sigmoid
Q3. Problem: Search In Rotated Sorted Array Given a sorted array that ... read more
asked in Cisco
Q4. Covid Vaccination Distribution Problem As the Government ramps up ... read more
asked in LTIMindtree
Q5. 1) If you are given a card with 1-1000 numbers and there are 4 bo ... read more

Data Engineer Interview Questions & Answers

user image Anonymous

posted on 11 Jun 2022

Round 1 - Coding Test 

Prime Number, Oops, SQL Coding

Round 2 - Technical 

(1 Question)

  • Q1. Spark, Big Data, Python, SQL

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare big data, SQL leetcode, Python, Spark
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed before Oct 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 - Technical 

(2 Questions)

  • Q1. SQL basics and window functions
  • Q2. Python basics and and cloud technology

Interview Preparation Tips

Interview preparation tips for other job seekers - Focus on SQL and any cloud services

Optum Global Solutions interview questions for designations

 Senior Data Engineer

 (1)

 Lead Data Engineer

 (1)

 Data Engineer 1

 (1)

 Data Engineer Analyst

 (1)

 Big Data Developer

 (1)

 Data Analyst

 (13)

 Data Scientist

 (9)

 Associate Data Analyst

 (6)

Data Engineer Interview Questions & Answers

user image Anonymous

posted on 30 Oct 2021

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

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - We should have strong base in sql also i was asked on some linux commands basics

Skills evaluated in this interview

Data Engineer Interview Questions & Answers

user image Anonymous

posted on 29 Apr 2021

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

Interview preparation tips for other job seekers - Overall Great experience & it happened within less period of time.

Data Engineer Interview Questions & Answers

user image Anonymous

posted on 14 Oct 2021

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 preparation tips for other job seekers - It is good, answered almost all the know questions and politely said no for which am not sure.

Interview questions from similar companies

I appeared for an interview before Jul 2021.

Round 1 - Technical 

(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 ...

  • Answered by AI
  • 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 ...

  • Answered by AI
  • 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...

  • Answered by AI
  • Q4. What is LINQ and some basic concept related it?

Interview Preparation Tips

Interview preparation tips for other job seekers - Interview was easy. Go through basic concepts of OOPs and SQL.

Skills evaluated in this interview

I applied via Campus Placement and was interviewed before Jul 2021. There were 3 interview rounds.

Round 1 - Aptitude Test 

In this round we have aptitude plus coding mcq questions

Round 2 - Coding Test 

Here we have to write full fledge code 2 questions were there and are easy

Round 3 - HR 

(1 Question)

  • Q1. Here we have hr plus technical interview

Interview Preparation Tips

Interview preparation tips for other job seekers - Keep working hard and the placement round is easy overall

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

Interview preparation tips for other job seekers - simple interview just be confident

Optum Global Solutions Interview FAQs

How many rounds are there in Optum Global Solutions Data Engineer interview?
Optum Global Solutions interview process usually has 1-2 rounds. The most common rounds in the Optum Global Solutions interview process are Technical, Coding Test and Resume Shortlist.
How to prepare for Optum Global Solutions Data Engineer 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 Azure, Big Data, AWS, Agile and Application Software.
What are the top questions asked in Optum Global Solutions Data Engineer interview?

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

  1. Query using sql window functio...read more
  2. How do you menage your wo...read more
  3. what is ADF in az...read more

Tell us how to improve this page.

Optum Global Solutions Data Engineer Interview Process

based on 3 interviews

1 Interview rounds

  • Technical Round
View more
Optum Global Solutions Data Engineer Salary
based on 286 salaries
₹6 L/yr - ₹22.5 L/yr
24% more than the average Data Engineer Salary in India
View more details

Optum Global Solutions Data Engineer Reviews and Ratings

based on 36 reviews

4.0/5

Rating in categories

3.7

Skill development

4.3

Work-life balance

3.5

Salary

3.9

Job security

3.9

Company culture

2.9

Promotions

3.7

Work satisfaction

Explore 36 Reviews and Ratings
Claims Associate
4.3k salaries
unlock blur

₹1 L/yr - ₹5.1 L/yr

Senior Software Engineer
2.9k salaries
unlock blur

₹9.5 L/yr - ₹32 L/yr

Software Engineer
2.7k salaries
unlock blur

₹5.3 L/yr - ₹18.4 L/yr

Medical Coder
1.3k salaries
unlock blur

₹1.5 L/yr - ₹8 L/yr

Senior Claims Associate
1.2k salaries
unlock blur

₹2.1 L/yr - ₹6 L/yr

Explore more salaries
Compare Optum Global Solutions with

Accenture

3.8
Compare

Wipro

3.7
Compare

Cognizant

3.7
Compare

Capgemini

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