Tip 1 : prepare the data structures and algorithms thoroughly with commen SQL query in hands on practice.
Tip 2 : prepare the execution flow for the SQL queries with in-depth knowledge about all the basic stuff. I mean what you are writing in query, you should know why you are writing it.
Tip 3 : prepare for the workplace conflict, synergy and leadership skills by putting yourself in the made up scenarios, very important to prepare for the immediate reaction and always answer them to the point and how you got into it and overcome that personally and with team.
Tip 1 : proof read everything and only write what you know. always leave room where you explain things rather than writing long paragraphs.
Tip 2 : projects names makes a lot of impact make sure to make them sound interesting and little backstory to why and how you got started. Always be ready to answer how and why you started something in your resume be it your education or project or any hobbies.
2 programing and 30 mcqs.
Programing questions were medium with one being array manipulation and other being graph based.
MCQ were from Oops concepts, SQL, operating system and network, prepare the in depth knowledge for all the topics.



'N' = 3, 'A' = {3, 1, 2, 3}, 'X' = 4, 'Y'= 2, 'SUM' = 14
For 'i' = 1, 'j' = 2, Value of the expression = 4 * 3 + 2 * 1 = 14.
For 'i' = 1, 'j' = 3, Value of the expression = 4 * 3 + 2 * 2 = 16.
For 'i' = 1, 'j' = 4, Value of the expression = 4 * 3 + 2 * 3 = 18.
For 'i' = 2, 'j' = 3, Value of the expression = 4 * 1 + 2 * 2 = 8.
For 'i' = 2, 'j' = 4, Value of the expression = 4 * 1 + 2 * 3 = 10.
For 'i' = 3, 'j' = 4, Value of the expression = 4 * 2 + 2 * 3 = 14.
The possible pairs are :
(1, 3), (3,4)



Suppose given input is "abacb", then the length of the longest substring without repeating characters will be 3 ("acb").
Sliding window approach
Morning teams interview, DSA, SQL RDBMS and leadership questions in depth.
The interviewer will give you situation and ask you how you will react in the situation mostly pretty much basic human behaviour cycle and workplace situations, how will you react to it.
How did you overcome loss situation personally?
Tip 1 : Make sure to first think before speaking the first words.Dont ever start to speak instantly
Tip 2 : Give your answer in brief and always have few situations ready from your past to support your answer to maximize your personal and team experience as well.
Tip 3 : always have a smile on and if you are nervous always try to lighten the mood rather than digging a long answer grave.
What situation made you give up on your dreams?
Tip 1 : Make sure to first think before speaking the first words.Dont ever start to speak instantly. These type of questions are there to judge your motivation skills so don't go into negatives of your situation too much, rather try to make them your strengths.
Tip 2 : Give your answer in brief and always have few situations ready from your past to support your answer to maximize your personal and team experience as well.
Tip 3 : always have a smile on and if you are nervous always try to lighten the mood rather than digging a long answer grave.
What is an Index? Explain its different types.
What are Constraints in SQL?
Hr round was pretty much a casual conversation about why optum, work location, joining availablity and what qualities you would like to highlight about yourself.
Why optum and what qualities you would like to highlight?
Tip 1 : go through wiki page or google about the working of company
Tip 2 : qualities should more aligned to company's values.
Tip 3 : show your interest in working with the organisation and how will you contribute to the team.

Here's your problem of the day
Solving this problem will increase your chance to get selected in this company
How do you remove whitespace from the start of a string?