i
Optum Global Solutions
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
I applied via Job Portal and was interviewed in May 2024. There was 1 interview round.
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
I applied via Campus Placement and was interviewed in May 2020. There were 6 interview rounds.
I applied via Company Website and was interviewed in Nov 2020. There were 3 interview rounds.
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
I appeared for an interview before Dec 2020.
Round duration - 120 Minutes
Round difficulty - Medium
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...
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'
Round duration - 60 Minutes
Round difficulty - Medium
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...
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.
Round duration - 50 Minutes
Round difficulty - Easy
Tip 1 : Focus more on SQL
Tip 2 : Keep up with ongoing projects in the company
Tip 1 : Be honest about what you add.
Tip 2 : Don't forget to mention extra curriculars.
I applied via Company Website and was interviewed in Jun 2021. There were 5 interview rounds.
I applied via Naukri.com and was interviewed in Feb 2021. There were 4 interview rounds.
I applied via Referral and was interviewed in Nov 2020. There were 5 interview rounds.
I applied via Campus Placement and was interviewed in Jun 2021. There was 1 interview round.
based on 1 interview
Interview experience
based on 1 review
Rating in categories
Claims Associate
4.3k
salaries
| ₹1.5 L/yr - ₹5.6 L/yr |
Senior Software Engineer
3k
salaries
| ₹9.6 L/yr - ₹32.6 L/yr |
Software Engineer
2.7k
salaries
| ₹5.5 L/yr - ₹24 L/yr |
Medical Coder
1.4k
salaries
| ₹1.5 L/yr - ₹8 L/yr |
Senior Claims Associate
1.2k
salaries
| ₹2.1 L/yr - ₹6 L/yr |
Accenture
Wipro
Cognizant
Capgemini