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 Company Website and was interviewed before Oct 2021. There were 5 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 - Aptitude Test 

Basic Aptitude with some difficult questions

Round 3 - Coding Test 

3 set of coding question were asked 1 easy ,1 medium ,1 hard

Round 4 - One-on-one 

(1 Question)

  • Q1. This was personal technical interview asking all related to my cv and the one they are looking for
Round 5 - HR 

(1 Question)

  • Q1. Basic personality questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare everything basic and from the CV and you will be good to go.Research about the company a bit that will add cherry on top.

Interview Questionnaire 

1 Question

  • Q1. TELL ME ABOUT UR SELF

Interview Preparation Tips

Interview preparation tips for other job seekers - ITS GOOD

I applied via Walk-in and was interviewed before Apr 2021. There were 4 interview rounds.

Round 1 - Group Discussion 

There were atleast 200 Aaplicants in which there separation of groups into 30 applicants and names were called out and have to say more that 4 to 5 lines on any topic u want to talk about as extempore.

Round 2 - Aptitude Test 

There were quest as pharmacology, pharmaceutics, reasoning knowledge, mathematics, English section.

Round 3 - Technical 

(1 Question)

  • Q1. The questions were asked on Pharma knowledge with subjective knowledge
Round 4 - HR 

(1 Question)

  • Q1. Question were asked regarding my expectations my working flexibility ets

Interview Preparation Tips

Topics to prepare for Cognizant Data Analyst interview:
  • Pharmacovigilance
  • Clinical Trials
  • ICH - GCP Guidelines
  • Pharmacology
  • Pharmaceutics
  • Current Profile
  • Basic
Interview preparation tips for other job seekers - Please make sure you are fully prepared for the Pharmacovigilance, ICH GCP guidline, basic Pharma knowledge, subjective knowledge. Be presentable and confident.

I applied via Naukri.com and was interviewed in Jun 2021. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. Difference between C and Java
  • Ans. 

    C is a procedural language while Java is an object-oriented language.

    • C is compiled while Java is interpreted

    • C has pointers while Java does not

    • Java has automatic garbage collection while C does not

    • Java is platform-independent while C is not

    • Java has built-in support for multithreading while C does not

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Cognizant Data Analyst interview:
  • Java
Interview preparation tips for other job seekers - Good one and Well Good It is useful to implement our knowledge and about interview experience

Skills evaluated in this interview

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

Round 1 - Aptitude Test 

Regning , English,Math and General knowledge

Round 2 - HR 

(3 Questions)

  • Q1. 1- Tell me about your self
  • Ans. 2- If you will get job then how will you help your family
  • Answered Anonymously
  • Q2. 3- What want you job family presher
  • Q3. 4- Tell me the details of the project you have done

Interview Preparation Tips

Interview preparation tips for other job seekers - 1- Identify your strength
2- Look for certification job
3- Build a strong resume
4- Apply for job directly

I applied via Campus Placement and was interviewed before Nov 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 tips
Round 2 - HR 

(2 Questions)

  • Q1. Asked basic HR question as to why i want to join, what am i looking for , ever faced any harships in my internship.
  • Q2. Why did i puckup coding and biggest regret, weakness, strengths.

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well and answer honestly and keep it simple. They may ask about your projects as well.

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

Interview Questionnaire 

1 Question

  • Q1. Technical questions related to domain

Interview Preparation Tips

Interview preparation tips for other job seekers - Have a great interview experience with Accenture. They were 2 rounds technical and HR and released the offer in a couple of days
Thanks Naukri for this great initiative..👍

I applied via Walk-in and was interviewed in Apr 2021. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. What is c++.
  • Ans. 

    C++ is a high-level programming language used for developing system software, application software, and video games.

    • C++ is an extension of the C programming language.

    • It supports object-oriented programming concepts like classes, inheritance, and polymorphism.

    • C++ is used for developing operating systems, device drivers, and embedded systems.

    • It is also popular for developing video games and high-performance applications.

    • ...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - I need an advice from others and the given

Skills evaluated in this interview

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

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

Interview Questions from Similar Companies

Accenture Interview Questions
3.8
 • 8.3k Interviews
Wipro Interview Questions
3.7
 • 5.7k Interviews
Cognizant Interview Questions
3.7
 • 5.7k Interviews
Capgemini Interview Questions
3.7
 • 4.9k Interviews
Genpact Interview Questions
3.8
 • 3.2k Interviews
LTIMindtree Interview Questions
3.7
 • 2.9k Interviews
IBM Interview Questions
4.0
 • 2.4k Interviews
DXC Technology Interview Questions
3.7
 • 804 Interviews
Nagarro Interview Questions
4.0
 • 765 Interviews
View all
Optum Global Solutions Data Engineer 1 Salary
based on 4 salaries
₹12 L/yr - ₹12.6 L/yr
30% 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

₹1.5 L/yr - ₹5.6 L/yr

Senior Software Engineer
3k salaries
unlock blur

₹9.7 L/yr - ₹32.6 L/yr

Software Engineer
2.6k salaries
unlock blur

₹5.5 L/yr - ₹19 L/yr

Medical Coder
1.4k salaries
unlock blur

₹1.5 L/yr - ₹8 L/yr

Senior Claims Associate
1.2k salaries
unlock blur

₹2 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