United Health Group ( UHG ) Optum Hyderabad Interview Questions

United Health Group / Unitedhealth Group / UHG / Optum interview Questions: The most important part of preparing for an interview is practice. Knowing what job interview questions you might be asked is essential – that way, you can craft your answers well in advance, and feel confident in your responses when the pressure is on.

Wouldn’t it be great if you knew exactly what interview questions are asked for the Test Engineer, QA for Manual & Automation Positions, We can’t read minds, unfortunately, but we’ll give you the next best thing: a list of previously asked United Health Group UHG interview questions and answers.

Post On:	United Health Group / Unitedhealth Group / UHG / Optum
Post Type:	Interview Questions
Published On:	www.softwaretestingo.com
Applicable For:	Freshers & Experience
Get Updates:	Software Testingo Telegram Group

We have tried to share some of the manual testing interview questions, selenium interview questions & testing interview questions also, but we are recommending spending some quality time to get comfortable with what might be asked when you go for the United Health Group UHG interview.

Still, we need you are love and support to make this platform more helpful to our fellow testers. So it would be great if you will share your recent interview questions and experience with us. You Can share those details by connecting us at softwaretestingo.com@gmail.com.

OPTUM UGH Company Interview Questions

Company Location: Bangalore, India
Attended on: 14.11.2021

• What are your roles and responsibilities?
• What is STLC?
• What are the primary key and unique keys?
• What is referential integrity?
• Tell me Unix commands?
• How can you find out the orphan records?
• What are metric validations?
• What star schema and snowflake schema?
• What slowly changing dimensional tables?
• What is a mean junk dimensional table?
• Data flow of ur projects?
• Find out the 3rd highest salary?

Unitedhealth Group Interview Questions

Company Location: Hyderabad, India
Attended on: 14.11.2021

• Tell me about your project?
• Which validation are you performing between ods and staging tables?
• Are you using aggregate operations without group by clause?
• Sel sum(sal) from emp group by deptno where deptno=10
• Having count(*)>1 what is the order of execution?
• How do you get the top five records in Unix?
• How to find duplicate records?
• How to delete duplicate records?
• Difference between delete and truncate?
• Write syntax for instr and substr?
• How do you show which constraints you have used on a table in oracle DB?
• Difference between filter and router?
• What is meant by active and passive transformations?

OPTUM Company Hyderabad Interview Questions

Company Location: Hyderabad, India
Attended on: 14.11.2021

• Explain your project?
• Difference between the star and snowflake schema?
• What is meant by clustered index?
• Difference between primary and unique keys?
• What is meant by integration check?
• Explain about smoke and sanity tastings?
• Explain about subqueries?
• What are the different types of transformations available in Informatica?
• Explain dim table with an example?
• Difference between DWH and DW?
• Two tables have the same columns then how do you get common columns without using joins?
• In your project how many dim and how many fact tables do you have?
• How to find out 3rd highest salary?

A	B
10	10
20	20
30	50
40	60

O/p for a) inner join b) left outer join c) right outer join d) cross join

OPTUM UHG Hyderabad Interview Questions

Company Location: Hyderabad
Interview Date: June 5, 2021
Experience: 2 years 9 months
Position: Quality Engineer(SDET)
Updated on: 02.07.2021

Thanks to Kushal Gupta, for Sharing the interview questions and interview Experience with us.

My resume got shortlisted from the Naukri portal and received a call regarding the role and job description and they scheduled the interview. The interview process consisted of two rounds:

• Online F2F technical round (1 HOUR)
• Online F2F Managerial round (30 MIN)

For me, they wrapped up two rounds on the same day.

Online F2F Technical Round

• Tell me about yourself.
• Explain previous project frameworks and domains you worked in.
• Explain which type of selenium framework you worked in.
• Gave me a java program and asked me to provide the output.
• Asked me to write a program where I have to use add(),get(),remove(),size() methods on a dynamic array in the same program.
• How many types of TestNG annotations are available and when should we use them.
• What is the significance of actions class in selenium?
• Why hashcode is used in java.
• Asked me about the BDD framework like why the BDD framework is used, what type of language you will use in the feature file of the BDD framework, and how you will establish a connection between the feature file and step definition file.
• Asked me to write a scenario in the feature file format and the methods inside the feature file will represent the methods in step definition and types of keywords used in the feature file.
• difference between scenario and scenario outline keyword in the feature file.
• How can we use multiple data in the feature file?
• Explain Defect lifecycle.
• Asked me how familiar I am with SQL. gave two tables and asked to explain what will be the output for different kinds of joins.
• What is the difference between union and union All?
• When will you use where clause, having clause and difference between them.
• Which comes first having or where.
• Asked output for query – Select 8 from a table.
• Asked about basic GIT commands.
• Asked about Jenkins integration with maven.

Online F2F Managerial Round

• Tell me about yourself.
• Why are you looking for a job change
• Some scenario-based questions

United Health Group ( UHG ) Optum Hyderabad Interview Questions

Company Location: Hyderabad, India
Updated on: 26.06.2021

• Explain method overriding and method overloading
• Difference between put and post
• Difference between run and compile polymorphism
• Bug life cycle
• Scenario-based test cases
• SQL outer joins
• Java program reverse string
• What is a test runner in cucumber?

UnitedHealth Group UHG Optum Interview Question

• In collections, what are ArrayList and link list and what’s the difference?
• Diff. b/w List, Queue, Set.
• Why SET<> doesn’t allow duplicate values, tell me it’s background implementation.
• In a string “ABC DEF” reverse each word without any inbuilt function.
• Tell me ur framework project structure.
• Tell me the procedure of interacting with Excel files.
• Types of Xpath.
• Write an XPath using content, following siblings.
• How to perform parallel execution.
• Few selenium exceptions.
• Diff. b/w thread & wait.
• Perform drag and drop between two frames.
• Types of wait statements.
• Reporting in selenium.
• How to switch b/w Tabs.
• How do u execute scripts, Ajax using Java?
• Have you made webdriver static or not?
• An example of an Abstract class & Interface class.
• How can we create a method with a body in Interface?
• From which Java version can we create a static method with a body in Java.
• Selenium version you are working on.

Unitedhealth Group UHG Optum Gurgaon Interview Questions

• Write class having encapsulation
• Static topic
• Final topic
• Armstrong Program
• How to delete only special characters from the string. write code
• Write code for the n*n*n program and how will you input values
• 3 inner for loops and if for most inner loop break statement is executed. write code it should come out of all three loops
• 5 Interfaces in selenium
• Write code for re-execution logic in selenium
• Data table vs Scenario outline in BDD Framework
• Write code for drag and drop selenium
• Write all git commands. how you checkout, check-in, merge, commit, create PR
• Difference between abstraction and interface
• Linked list structure
• What is a linked hashmap
• When ArrayList can be used and when linked list