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 1 Interview Questions and Answers for Experienced

Updated 14 Nov 2024

Optum Global Solutions Data Engineer 1 Interview Experiences for Experienced

1 interview found

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

I applied via Job Portal and was interviewed in May 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Pyspark Architecture
  • Q2. Hive Optimization techniques
  • Ans. 

    Hive optimization techniques improve query performance in Hive by optimizing data storage and query execution.

    • Partitioning tables based on commonly used columns to reduce data scanned during queries

    • Using bucketing to evenly distribute data across files for faster reads

    • Using indexes to speed up query processing by creating index tables on frequently queried columns

    • Optimizing query execution by using appropriate join str

  • Answered by AI

Skills evaluated in this interview

Interview questions from similar companies

I applied via Naukri.com and was interviewed in Aug 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Oops Concepts and Data Structure Questions.

Interview Preparation Tips

Interview preparation tips for other job seekers - Oops And Data Structure, Collection.

I applied via Campus Placement and was interviewed before Feb 2020. There were 6 interview rounds.

Interview Questionnaire 

4 Questions

  • Q1. Was interviewed as fresher?
  • Q2. Written test conducted? with verbal ability test ? GD
  • Q3. How would u deal with a problematic situation when you are working in a team?
  • Q4. What are your plans about higher studies?

Interview Preparation Tips

Interview preparation tips for other job seekers - it was basic with apptiude test and attitiude test.

I applied via Company Website and was interviewed before Feb 2020. There was 1 interview round.

Interview Questionnaire 

2 Questions

  • Q1. They asked about dbms questions in the form of table formate
  • Q2. They asked code for some python program

Interview Preparation Tips

Interview preparation tips for other job seekers - Firstly they conducted computer based technical exam and then after qualifying that then we will go for face face interview and then lastly HR round will be held.

I applied via Campus Placement and was interviewed in Oct 2020. There were 4 interview rounds.

Interview Questionnaire 

5 Questions

  • Q1. Wap of bubble sort
  • Ans. 

    Bubble sort is a simple sorting algorithm that repeatedly steps through the list, compares adjacent elements and swaps them if they are in the wrong order.

    • Start from the first element and compare it with the next element

    • If the next element is smaller, swap them

    • Repeat this process for all elements in the array

    • Continue this process until no more swaps are needed

  • Answered by AI
  • Q2. Wap of prime number
  • Ans. 

    A program to print all prime numbers

    • Take input from user for range of numbers

    • Loop through the range and check if each number is prime

    • Print the prime numbers

  • Answered by AI
  • Q3. What is hashmap?
  • Ans. 

    Hashmap is a data structure that stores key-value pairs and allows constant time access to values based on their keys.

    • Hashmap uses a hash function to map keys to indices in an array.

    • Collisions can occur when multiple keys map to the same index, which can be resolved using techniques like chaining or open addressing.

    • Examples of hashmap implementations include Java's HashMap class and Python's dict type.

  • Answered by AI
  • Q4. What is inheritance
  • Ans. 

    Inheritance is a mechanism in object-oriented programming where a new class is created by inheriting properties of an existing class.

    • Inheritance allows code reuse and promotes code organization.

    • The existing class is called the parent or superclass, and the new class is called the child or subclass.

    • The child class inherits all the properties and methods of the parent class and can also add new properties and methods.

    • For...

  • Answered by AI
  • Q5. Call by value and call by reference

Interview Preparation Tips

Interview preparation tips for other job seekers - Be yourself

Skills evaluated in this interview

I applied via Walk-in and was interviewed in Mar 2021. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Introduction your self in interview

Interview Preparation Tips

Interview preparation tips for other job seekers - Interview should be very easy and comfortable to the students. And be confident at the infront of interviewer
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
4-6 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed before Dec 2021. There were 2 interview rounds.

Round 1 - Aptitude Test 

Basic logical reasoning and verbal questions . Easy to clear

Round 2 - HR 

(2 Questions)

  • Q1. 1.Tell me about yourself? 2.What are Your achievements?
  • Q2. 3. Your strengths? 4. How did you face a situation using your key skills?

Interview Preparation Tips

Interview preparation tips for other job seekers - Be Confident . Care to explain more instead of giving single word answers . Good luck

I applied via Campus Placement and was interviewed before Oct 2020. There were 3 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. About project done
  • Q2. Core Java basics
  • Q3. NodeJs basics

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well on Java and the technology you have used in your projects always be truthful and answer directly

Interview Questionnaire 

1 Question

  • Q1. A-Z in MySQL, programming languages(only concepts)

I applied via Company Website and was interviewed in Dec 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Self introduction

Interview Preparation Tips

Interview preparation tips for other job seekers - say individual ideas,plans, story's.say different opinions,speek confidentially, correctly answer Yes or no questions, correctly say interested and confidential job,

Optum Global Solutions Interview FAQs

How many rounds are there in Optum Global Solutions Data Engineer 1 interview for experienced candidates?
Optum Global Solutions interview process for experienced candidates usually has 1 rounds. The most common rounds in the Optum Global Solutions interview process for experienced candidates are Technical.
What are the top questions asked in Optum Global Solutions Data Engineer 1 interview for experienced candidates?

Some of the top questions asked at the Optum Global Solutions Data Engineer 1 interview for experienced candidates -

  1. Hive Optimization techniq...read more
  2. Pyspark Architect...read more

Tell us how to improve this page.

Optum Global Solutions Data Engineer 1 Interview Process for Experienced

based on 1 interview

Interview experience

5
  
Excellent
View more
Optum Global Solutions Data Engineer 1 Salary
based on 4 salaries
₹12 L/yr - ₹12.6 L/yr
35% more than the average Data Engineer 1 Salary in India
View more details

Optum Global Solutions Data Engineer 1 Reviews and Ratings

based on 1 review

3.0/5

Rating in categories

3.0

Skill development

5.0

Work-life balance

3.0

Salary

4.0

Job security

5.0

Company culture

3.0

Promotions

2.0

Work satisfaction

Explore 1 Review and Rating
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