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
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed in Aug 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 - Technical 

(1 Question)

  • Q1. Data projects carried out. How to create pipeline How to process millions of request Web crawler and scraping technologies How to read large CSV python
  • Ans. 

    Creating data pipelines, processing requests, web crawling, scraping, and reading large CSV files in Python.

    • Use tools like Apache Airflow or Luigi to create data pipelines

    • Implement distributed computing frameworks like Apache Spark for processing millions of requests

    • Utilize libraries like Scrapy or Beautiful Soup for web crawling and scraping

    • Use pandas library in Python to efficiently read and process large CSV files

  • Answered by AI
Round 3 - Technical 

(1 Question)

  • Q1. Scrum role. Daily activities of a development Automation framework
  • Ans. 

    The Scrum role involves daily activities in development and implementing an automation framework.

    • As a Data Engineering Specialist, the Scrum role involves participating in daily stand-up meetings to discuss progress and obstacles.

    • Daily activities may include coding, testing, debugging, and collaborating with team members to deliver high-quality software.

    • Implementing an automation framework involves creating scripts or ...

  • Answered by AI

Skills evaluated in this interview

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:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
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
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed before Jun 2023. There were 3 interview rounds.

Round 1 - HR 

(1 Question)

  • Q1. Experience and profile check
Round 2 - Technical 

(1 Question)

  • Q1. Knowlege check and some protocols testing
Round 3 - HR 

(1 Question)

  • Q1. Salary discussion and negotiation
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Recruitment Consulltant and was interviewed in Jul 2022. There were 4 interview rounds.

Round 1 - Coding Test 

Coding questions will be in data structures and algorithms. Mostly from binary tree, linked list, and tree map. Interviewer will ask depth about space and time complexity

Round 2 - One-on-one 

(2 Questions)

  • Q1. 1. Executor service in java 2. String array coding questions 3. Design pattern with industry example (in your current project) 4. Async communication between microservices 5. Event based architecture 6...
  • Q2. 12. Spring boot annotations ( you probably never heard ) like sneakythrows 13. Integration test
Round 3 - Technical 

(1 Question)

  • Q1. Manager round most of the question are scenario based like conflict management, stakeholders management, product support, impact in production delivery
Round 4 - HR 

(1 Question)

  • Q1. Even hr will ask behaviour questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Be strong in your core skills .
Scenario based questions so answer efficiency.

I applied via Referral and was interviewed in Jun 2021. There were 3 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. What is Exploratory Testing
  • Ans. 

    Exploratory testing is a type of testing where the tester designs and executes tests simultaneously.

    • It is an unscripted testing approach

    • Testers use their domain knowledge and experience to identify defects

    • It is useful in finding defects that are difficult to identify through scripted testing

    • It is often used in Agile development environments

    • Example: A tester explores a new feature of an application and tries to identify

  • Answered by AI
  • Q2. What is Load and Stress Testing
  • Ans. 

    Load testing checks system performance under normal and peak loads. Stress testing checks system performance beyond peak loads.

    • Load testing checks system performance under normal and peak loads

    • Stress testing checks system performance beyond peak loads

    • Load testing is done to ensure the system can handle expected traffic

    • Stress testing is done to identify the breaking point of the system

    • Examples of load testing tools: JMe...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Focus on your basics. Make sure your concepts about the different types and levels of Testing is clear.

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Properly align and format text in your resume. A recruiter will have to spend more time reading poorly aligned text, leading to high chances of rejection.
View all tips
Round 2 - Technical 

(1 Question)

  • Q1. Java 8 questions date,stream
Round 3 - Technical 

(1 Question)

  • Q1. Java,Java 8 exceptions project related questions
Round 4 - One-on-one 

(1 Question)

  • Q1. HR round for final discussion

Interview Preparation Tips

Interview preparation tips for other job seekers - Mainly Java concepts with some coding programs.Java 8 stream, Exception etc
Interview experience
1
Bad
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Double-check your resume for any spelling mistakes. The recruiter may consider spelling mistakes as careless behavior or poor communication skills.
View all tips
Round 2 - One-on-one 

(4 Questions)

  • Q1. According to smt department
  • Q2. Electronic control unit
  • Q3. Chip mounter, AOI, SPG, SPI, LASER MACHINE
  • Q4. Reflow, conveyor, ok board loder, ng board unloder

Interview Preparation Tips

Interview preparation tips for other job seekers - Very responsibility on working time . In my life part of wipro company. It is very hard working in honesty in my life

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