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

Updated 14 Nov 2024

Optum Global Solutions Data Engineer 1 Interview Experiences

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 Campus Placement and was interviewed in May 2020. There were 6 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. 1.In frst round they gave two programs like palindrome,leap year which is quite easy only, aptitude consists of 60qns .
  • Q2. 2.In second round which is technical round, again they gave one pgm which is lightly complicated and also questions will be asked based on our resume and branch.
  • Q3. 3.HR round based on your personal skill.

Interview Preparation Tips

Interview preparation tips for other job seekers - Try to be perfect in basic coding and also aptitude,it is not much tough and also be bold while answering in technical round,try to do more projects......

I applied via Company Website and was interviewed in Nov 2020. There were 3 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Question related technologies you have worked on and there versions..how your production cycle worked in last company and some oops related questions
  • Q2. Be confident they don't take more than 2-3 rounds.your basic must be perfect

Interview Preparation Tips

Interview preparation tips for other job seekers - They don't take more than 2-3 rounds.be confident and basics must be perfect

Interview Questionnaire 

1 Question

  • Q1. Occurs, precompile , file status codes , sql queries and scenarios on sql.

Interview Questionnaire 

1 Question

  • Q1. What types of transformation used in your project What is lookup and what are the types So many basic questions regarding organization
  • Ans. 

    Answering questions about transformation and lookup types used in a project

    • Transformation types used in the project may include data mapping, aggregation, filtering, and sorting

    • Lookup is a process of searching for a specific value in a table or database

    • Types of lookup include exact match, range match, and fuzzy match

    • Questions about organization may refer to project management, team collaboration, or software developmen

  • Answered by AI

I appeared for an interview before Dec 2020.

Round 1 - Coding Test 

(1 Question)

Round duration - 120 Minutes
Round difficulty - Medium

  • Q1. 

    Ninja and His Secret Information Encoding Problem

    Ninja, a new member of the FBI, has acquired some 'SECRET_INFORMATION' that he needs to share with his team. To ensure security against hackers, Ninja dec...

  • Ans. 

    The task is to encode and decode 'SECRET_INFORMATION' for security purposes and determine if the transmission was successful.

    • Read the number of test cases 'T'

    • For each test case, encode the 'SECRET_INFORMATION' and then decode it

    • Compare the decoded string with the original 'SECRET_INFORMATION'

    • Print 'Transmission successful' if they match, else print 'Transmission failed'

  • Answered by AI
Round 2 - Face to Face 

(1 Question)

Round duration - 60 Minutes
Round difficulty - Medium

  • Q1. 

    Equilibrium Index Problem Statement

    Given an array Arr consisting of N integers, your task is to find the equilibrium index of the array.

    An index is considered as an equilibrium index if the sum of elem...

  • Ans. 

    Find the equilibrium index of an array where sum of elements on left equals sum on right.

    • Iterate through the array and calculate prefix sum and suffix sum at each index.

    • Compare prefix sum and suffix sum to find equilibrium index.

    • Return the left-most equilibrium index or -1 if none found.

  • Answered by AI
Round 3 - HR 

Round duration - 50 Minutes
Round difficulty - Easy

Interview Preparation Tips

Professional and academic backgroundI applied for the job as Data Analyst in PuneEligibility criteria7 CGPACapgemini interview preparation:Topics to prepare for the interview - Data Structures, OOPS, SQL, Python, JavaTime required to prepare for the interview - 1 MonthInterview preparation tips for other job seekers

Tip 1 : Focus more on SQL
Tip 2 : Keep up with ongoing projects in the company

Application resume tips for other job seekers

Tip 1 : Be honest about what you add.
Tip 2 : Don't forget to mention extra curriculars.

Final outcome of the interviewSelected

Skills evaluated in this interview

I applied via Company Website and was interviewed in Jun 2021. There were 5 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Web development questions
  • Ans. I have worked on tensor flow and django techs
  • Answered Anonymously

Interview Preparation Tips

Interview preparation tips for other job seekers - Not much but be confident to which you answer

I applied via Naukri.com and was interviewed in Feb 2021. There were 4 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Any suggestions from me to improve myself.
  • Q2. What do you think I'm fit for this role

Interview Preparation Tips

Interview preparation tips for other job seekers - What ever you know speak confidently

I applied via Referral and was interviewed in Nov 2020. There were 5 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Web scrapping assignment
  • Q2. Competetive programming questions

Interview Preparation Tips

Interview preparation tips for other job seekers - standard cp questionsljc lkd lkdf vklfd vlkf vlkf dvlk flkv fdlkv fdklv lkfd vlkfd vlkfd vklfd

I applied via Campus Placement and was interviewed in Jun 2021. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Ds Algo based

Interview Preparation Tips

Interview preparation tips for other job seekers - Good

Optum Global Solutions Interview FAQs

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

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

  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

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.6 L/yr - ₹32.6 L/yr

Software Engineer
2.7k salaries
unlock blur

₹5.5 L/yr - ₹24 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.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