Add office photos
Filter interviews by
Optum Data Engineer Interview Questions and Answers
Updated
19 Oct 2024
6 interviews found
Sort by:
Popular
Anonymous
Interview experience
Excellent
Difficulty level
-
Duration
-
Result
-
2 Interview Rounds
1
Coding Test Round
Asked me two string array question one was to reverse a string without any pre build function and second one was a medium question to print the number and the count of it into the next level of the tree
2
HR Round (2 Questions)
- Q1. Who is your idol? Add Answer
- Q2. How do you menage your work? View Answers (1)
Interview experience
Average
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
No response
I applied via Referral and was interviewed in Oct 2023.
1 Interview Round
1
Technical Round (3 Questions)
- Q1. RDD, Datafram, dataset difference Add Answer
- Q2. Find the 2nd hightest salary Add Answer
- Q3. What is ADF in azure View Answers (1)
Skills evaluated in this interview
2 Interview Rounds
1
Coding Test Round
Prime Number, Oops, SQL Coding
2
Technical Round (1 Question)
- Q1. Spark, Big Data, Python, SQL Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - Prepare big data, SQL leetcode, Python, Spark
I applied via Recruitment Consultant and was interviewed in Sep 2021.
1 Interview Round
Interview Questions
- Q1. Sql join with data given and predict output from the given inputs
Add Answer
- Q2. Query using sql case conditions
Add Answer
- Q3. Query using sql window functions
View Answers (1)
Interview Preparation Tips
Interview preparation tips for other job seekers - We should have strong base in sql also i was asked on some linux commands basics
Skills evaluated in this interview
Optum interview questions for designations
I applied via Naukri.com and was interviewed in Apr 2021.
3 Interview Rounds
Interview Questions
- Q1. Questions on ETL, case statements to handle failures
Add Answer
- Q2. Basic SQL questions
Add Answer
- Q3. Basics of Python & Libraries
Add Answer
- Q4. Unix Commands
Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - Overall Great experience & it happened within less period of time.
I applied via Naukri.com and was interviewed in Apr 2021.
4 Interview Rounds
Interview Questions
- Q1. I was asked regarding my project and about the tool
Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - It is good, answered almost all the know questions and politely said no for which am not sure.
Top trending discussions
View All
Interview Tips & Stories
2w (edited)
a consultant
Alternate documents for Employee verification?
My new employer asked for my previous offer letters and salary slips. When I inquired, they said it was for background verification.
However, I feel that providing these documents might affect salary negotiations, and it feels a bit unethical too.
What alternative documents can I provide for employment verification?
Got a question about Optum?
Ask anonymously on communities.
Interview questions from similar companies
Interview experience
Average
Difficulty level
Easy
Duration
Less than 2 weeks
Result
Not Selected
I applied via Company Website and was interviewed in Nov 2024.
2 Interview Rounds
1
Technical Round (2 Questions)
- Q1. Sql constrainsts, star schema, dml dcl commands Add Answer
- Q2. About cureent project and responsibilities Add Answer
2
Technical Round (2 Questions)
- Q1. Current projects and resposibilities Add Answer
- Q2. Where vs having, reason for job change Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - 1. Technical - about you current project and responsibilities, basic SQL question-constraints, starschema, DML DCL command, one sql query write.
2. Technical with senior manager- about project ,where vs having , reason of job change
2. Technical with senior manager- about project ,where vs having , reason of job change
Interview experience
Poor
Difficulty level
-
Duration
-
Result
-
3 Interview Rounds
1
Coding Test Round
Oops dsa sql network
2
Technical Round (2 Questions)
- Q1. Dsa based python question Add Answer
- Q2. Dsa based python question on tress Add Answer
3
Technical Round (2 Questions)
- Q1. Sql question queries Add Answer
- Q2. Sql question query Add Answer
Interview experience
Excellent
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Selected
I applied via Recruitment Consulltant and was interviewed in Jun 2024.
1 Interview Round
1
One-on-one Round (20 Questions)
- Q1. Tell me about yourself View Answers (1)
- Q2. Project Architecture Add Answer
- Q3. Rate yourself out of 5 in Pyspark , Python and SQL View Answers (1)
- Q4. How to handle duplicates in python ? View Answers (1)
- Q5. Methods of migrating Hive metdatastore to unity catalog in Databricks ? View Answers (1)
- Q6. Read a CSV file from ADLS path ? View Answers (1)
- Q7. There was a table provided on coding screen and asked to write different programs and SQL queries from the table and tell the approach you are taking ? Like age...read more Add Answer
- Q8. How many stages will create from the above code that I have written View Answers (1)
- Q9. Narrow vs Wide Transformation ? View Answers (1)
- Q10. What are action and transformation ? View Answers (1)
- Q11. What happens when we enforce the schema and when we manually define the schema in the code ? View Answers (1)
- Q12. What all the optimisation are possible to reduce the overhead of reducing the reading part of large datasets in spark ? View Answers (2)
- Q13. Write a sql query to find the name of person who logged in last within each country from Person Table ? View Answers (1)
- Q14. Difference between List and Tuple ? View Answers (1)
- Q15. Difference between Rank , Dense Rank and Row Number and when we are using each of them ? View Answers (1)
- Q16. What is List Comprehension ? View Answers (2)
- Q17. Tell me about the performance optimization done in your project ? Add Answer
- Q18. Difference between the interactive cluster and job cluster ? View Answers (1)
- Q19. How to add a column in dataframe ? How to rename the column in dataframe ? View Answers (1)
- Q20. Difference between Coalesce and Repartition and In which case we are using it ? View Answers (2)
Interview Preparation Tips
Topics to prepare for Accenture Data Engineer interview:
- Spark
- Databricks
- SQL
- Python
- ETL
Skills evaluated in this interview
Interview experience
Good
Difficulty level
Moderate
Duration
2-4 weeks
Result
Not Selected
I applied via Naukri.com and was interviewed in Sep 2024.
3 Interview Rounds
1
Coding Test Round
Some multiple choice, 2 sql and 2 python questions were asked
2
Technical Round (2 Questions)
- Q1. Tell me about you project View Answers (1)
- Q2. Optimising technique that you have used View Answers (1)
3
Technical Round (2 Questions)
- Q1. Window partition question was asked Add Answer
- Q2. Project related question Add Answer
Skills evaluated in this interview
Optum Interview FAQs
How many rounds are there in Optum Data Engineer interview?
Optum interview process usually has 1-2 rounds. The most common rounds in the Optum interview process are Coding Test, Technical and HR.
How to prepare for Optum Data Engineer 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. The most common topics and skills that interviewers at Optum expect are ETL, Python, SQL, Spark and Big Data.
Tell us how to improve this page.
Optum Interviews By Designations
- Optum Claims Associate Interview Questions
- Optum Software Engineer Interview Questions
- Optum Medical Coder Interview Questions
- Optum Software Developer Interview Questions
- Optum Clinical Investigator Interview Questions
- Optum Senior Software Engineer Interview Questions
- Optum Associate Software Engineer Interview Questions
- Optum Data Scientist Interview Questions
- Show more
Interview Questions for Popular Designations
- Senior Data Engineer Interview Questions
- Big Data Engineer Interview Questions
- Software Engineer Interview Questions
- Senior Software Engineer Interview Questions
- Database Admin Interview Questions
- Data Analyst Interview Questions
- System Engineer Interview Questions
- Associate Software Engineer Interview Questions
- Show more
People are getting interviews through
based on 4 Optum interviews
Job Portal
Recruitment Consultant
Referral
50%
25%
25%
Moderate
Confidence
?
Moderate Confidence means the data is based on a sufficient number of responses received from the candidates
Data Engineer Interview Questions from Similar Companies
Fast track your campus placements
30%
more
than the average Data Engineer Salary in India
View more details
Optum Data Engineer Reviews and Ratings
based on 21 reviews
Rating in categories
|
Claims Associate
3.1k
salaries
|  ₹1.5 L/yr - ₹5.6 L/yr |
|
Senior Software Engineer
2.1k
salaries
| ₹9.5 L/yr - ₹32.5 L/yr |
|
Software Engineer
2k
salaries
| ₹5.3 L/yr - ₹22 L/yr |
|
Medical Coder
1k
salaries
| ₹1.5 L/yr - ₹8 L/yr |
|
Senior Claims Associate
766
salaries
| ₹2.1 L/yr - ₹6.5 L/yr |
Explore more salaries
Compare Optum with
Accenture
Compare
Cognizant
Compare
Infosys
Compare
TCS
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
- Home >
- Interviews >
- Optum Interview Questions >
- Optum Data Engineer Interview Questions
Share an Interview