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
4.1

based on 1.7k Reviews

Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards

zig zag pattern zig zag pattern

Filter interviews by

Optum Global Solutions Data Engineering Lead Interview Questions and Answers

Updated 3 Jul 2024

Optum Global Solutions Data Engineering Lead Interview Experiences

1 interview found

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Import vs direct query
  • Ans. 

    Import vs direct query

    • Importing data involves transferring data from a source to a destination, while direct query involves querying data directly from the source.

    • Importing data can be useful for offline analysis or data transformation, while direct query is more suitable for real-time analysis.

    • Importing data may require additional storage space, while direct query does not necessarily require storage.

    • Importing data ca...

  • Answered by AI
  • Q2. Power bi vs tableau
  • Ans. 

    Power BI and Tableau are both powerful data visualization tools, but they have some key differences.

    • Power BI is more user-friendly and integrates well with Microsoft products.

    • Tableau is known for its advanced analytics capabilities and flexibility in data visualization.

    • Power BI is often preferred by organizations already using Microsoft products, while Tableau is popular among data analysts and data scientists.

    • Tableau ...

  • Answered by AI
Round 2 - HR 

(2 Questions)

  • Q1. Salary expectation
  • Q2. Notice period negotiation

Skills evaluated in this interview

Interview questions from similar companies

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed in Sep 2024. There were 3 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. Spark memory management
  • Q2. Performance optimization in spark
  • Ans. 

    Performance optimization in Spark involves tuning configurations, optimizing code, and utilizing best practices.

    • Tune Spark configurations such as executor memory, number of executors, and shuffle partitions

    • Optimize code by reducing unnecessary shuffling, using efficient transformations, and caching intermediate results

    • Utilize best practices like using data partitioning, avoiding unnecessary data movements, and leveragi...

  • Answered by AI
Round 2 - Technical 

(2 Questions)

  • Q1. Transformations and actions in spark
  • Ans. 

    Transformations and actions are key concepts in Apache Spark for processing data.

    • Transformations are operations that create a new RDD from an existing one, like map, filter, and reduceByKey.

    • Actions are operations that trigger computation and return a result to the driver program, like count, collect, and saveAsTextFile.

  • Answered by AI
  • Q2. Glue context and spark context
Round 3 - HR 

(2 Questions)

  • Q1. About your career so far
  • Q2. Previous organizations and projects worked
  • Ans. 

    I have worked at ABC Company as a Data Engineer, where I led projects on data pipeline development and optimization.

    • Led projects on data pipeline development and optimization

    • Worked at ABC Company as a Data Engineer

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - prepare well before appearing for interview

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(5 Questions)

  • Q1. Technical Experience
  • Q2. Challenged faced
  • Q3. Solutions provided
  • Q4. Toughest Project Handled
  • Ans. 

    Developing a real-time monitoring system for a large-scale financial trading platform

    • Implemented complex algorithms to analyze market data in real-time

    • Designed a scalable architecture to handle high volume of transactions

    • Worked closely with traders and analysts to understand requirements and make necessary adjustments

    • Managed a team of developers to ensure project milestones were met

  • Answered by AI
  • Q5. Other Technical languages

Interview Preparation Tips

Interview preparation tips for other job seekers - If they feel you can fill their need then u r in
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Questions related to sql
  • Q2. Project which u have worked on
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

Sql, pyhton, azure databricks, azure data factory

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-

I applied via Campus Placement

Round 1 - Aptitude Test 

It was communication assesment round.It had good set of questions

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

I applied via Campus Placement and was interviewed in Feb 2023. There were 3 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 

Verbal.coding. c programing. Reasoning. Logical questions. Phargraf. Sa

Round 3 - Technical 

(5 Questions)

  • Q1. Oops concept Array Local and global variable Cyber security C structure Operating system
  • Q2. What wifro? Why should hire you? What is your weakness and strength? Wifro founder who? Salary's exception wifro? When campany joined? Percentage 10th and12puc? Backlogs your? Self introduction?
  • Q3. Your insfired person
  • Q4. Self introduction What is wifro?
  • Q5. When joining campany?

Interview Preparation Tips

Interview preparation tips for other job seekers - Apti first clear second tr question then hr.
Your cammuncation is important . and self confindence important
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Company Website and was interviewed in Jan 2024. There was 1 interview round.

Round 1 - Coding Test 

To automate REST API calls using ROBOT Framework.

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

Basic coding, logic implementation

Round 2 - Technical 

(1 Question)

  • Q1. Knowledge test regarding domain of require skills
Round 3 - Technical 

(1 Question)

  • Q1. Same like technical one with some other interviewer
Round 4 - HR 

(1 Question)

  • Q1. Salary and Documents, Discussion
Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed in Jun 2024. There was 1 interview round.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Java questions, spring boot
  • Q2. Microservices, devops, react js

Optum Global Solutions Interview FAQs

How many rounds are there in Optum Global Solutions Data Engineering Lead interview?
Optum Global Solutions interview process usually has 2 rounds. The most common rounds in the Optum Global Solutions interview process are Technical and HR.
How to prepare for Optum Global Solutions Data Engineering Lead 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, Docker, Github and HBase.
What are the top questions asked in Optum Global Solutions Data Engineering Lead interview?

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

  1. Import vs direct qu...read more
  2. Power bi vs tabl...read more
  3. Notice period negotiat...read more

Tell us how to improve this page.

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.2k Interviews
Accenture Interview Questions
3.9
 • 8k Interviews
Infosys Interview Questions
3.7
 • 7.5k Interviews
Wipro Interview Questions
3.7
 • 5.5k Interviews
Cognizant Interview Questions
3.8
 • 5.5k Interviews
Capgemini Interview Questions
3.8
 • 4.7k Interviews
Tech Mahindra Interview Questions
3.6
 • 3.8k Interviews
HCLTech Interview Questions
3.5
 • 3.7k Interviews
Genpact Interview Questions
3.9
 • 3k Interviews
LTIMindtree Interview Questions
3.9
 • 2.9k Interviews
View all
Optum Global Solutions Data Engineering Lead Salary
based on 10 salaries
₹13 L/yr - ₹30.5 L/yr
At par with the average Data Engineering Lead Salary in India
View more details
Claims Associate
1k salaries
unlock blur

₹1.7 L/yr - ₹5 L/yr

Senior Software Engineer
622 salaries
unlock blur

₹9 L/yr - ₹30 L/yr

Software Engineer
440 salaries
unlock blur

₹5.1 L/yr - ₹20.1 L/yr

Senior Claims Associate
369 salaries
unlock blur

₹2.3 L/yr - ₹5.5 L/yr

Senior Associate
147 salaries
unlock blur

₹2.5 L/yr - ₹5.5 L/yr

Explore more salaries
Compare Optum Global Solutions with

Cognizant

3.8
Compare

Accenture

3.9
Compare

IBM

4.1
Compare

TCS

3.7
Compare

Calculate your in-hand salary

Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and get your in-hand salary
Did you find this page helpful?
Yes No
write
Share an Interview