28 Optum Interview Questions & Answers
1. How do you ensure that you have a healthy work-life balance in your career?
How to Answer
In the fast paced world in software and technology development, heavy work loads and potential on-call duties have created a lot of burnout in professionals. Your interviewer is looking to hear that you are cognizant of the risks of burnout and that you do what is necessary to maintain your own personal health and well being and that of your family as well. While you can use this time to talk about personal interests or hobbies outside of work, try to focus on how these items help keep you refreshed for the work that you'll be doing for Optum.
1st Answer Example
"As I am passionate about my career as a UX designer, I am also passionate about my family. Any moments outside of work are spent coaching my kids traveling baseball teams in the summer months and then spending as many weekends as possible on the ski slopes. These activities help keep me active, physically fit and keep my mind centered on what it truly important in my life when work weeks get stressful."
2nd Answer Example
"Having watched many of my senior colleagues over time suffer from work burnout that has caused marital issues and health issues, I make it a priority to maintain a healthy balance between my work and my home life. My free time is spent in the outdoors with my wife, whether that be on the lakes and rivers fishing or biking around town. I consider myself fortunate to be considered for a position here at Optum because I know that you put a focus on your employees maintaining this healthy balance because the organization realizes how important this is to be productive."
2. Our cloud computing at Optum requires our experts to take proper security measures in their work. What security measures are you familiar with utilizing in a cloud platform?
How to Answer
As with any server or database storage, unique security risks are posed to organizations that have moved their data and applications to the cloud. At Optum, part of your role will be to ensure that all security measures are in place with the organizations data in the cloud and your interviewer is looking to hear that you are familiar with diagnosing security risks and taking action to prevent them with this question. Talk about your knowledge of the different cloud service providers and other security measures that you are familiar with taking in your work.
1st Answer Example
"For me, the planning stage of the cloud deployment process really sets the groundwork for security in a project. In my current role, each project adopts a cloud framework that suits the project the best. This framework is the base for our security measures in the cloud. From there, I always look to utilize a cloud service that encrypts our data and take all measures to steer away from storing sensitive information within the cloud. Last, as with any project, I help implement strict testing measures to check on the security of our cloud operations."
2nd Answer Example
"In my current role, the biggest security risks that we face are loss of sensitive data and malware infections. To take all security measures possible, our first plan of attack for security is to ensure that all of our data is backed up locally with electronic copies of data. To prevent malware in all ways possible, we have implemented a strict password strength policy and we install anti-virus software in our own equipment and recommend that customers do the same as well."
3. How do you stay organized and on track when working on multiple projects or duties at the same time?
How to Answer
In this role with Optum, you will likely be expected to manage multiple projects at the same time. Your ability to plan, manage deadlines and handle high needs items that come up on a regular basis will be essential to your success in this role and your interviewer is looking to hear how you plan for success. Whether you utilize an electronic tool or a written list, there are no right or wrong answers as long as you can prove in your answer that this method works out great for you.
1st Answer Example
"With any project that I am working on, I make sure to set benchmarks to meet deadlines ahead of time and set early personal deadlines to allow for some wiggle room. To do this, I am a proponent of using the Microsoft Outlook calendar and tasks functions to help keep me organized. I find that this method helps me stay on track with multiple projects while also leaving me wiggle room each day to fight the high needs fires that do come up in this job."
2nd Answer Example
"For me to stay on track, I make sure to take ten minutes at the end of each day to recap what was accomplished, what new came up on my task list and re-prioritizing my work for the next day. Then, upon arriving the next day and working through emails from the previous evening, I can adjust my task list for the day if needed. I tend to set aside two hours per day to work on long-term project needs while focusing a majority of my time on the short-term needs."
4. If you were asked to review a colleague's code that they had written, what key things would you look for?
How to Answer
For this question, your interviewer will obviously be looking to hear that you have adequate knowledge when it comes to coding processes. But most importantly, your interviewer will be looking to gauge your ability to be a team player and focus on the bigger picture when working on a project. In your answer, focus on your attention to detail and your ability to help others when needed.
1st Answer Example
"As an experienced software engineer, I fully expect my colleagues to reach out to me for my insight and I never hesitate to provide open and honest feedback. When asked to do this, my main focus is ensuring that the code is readable and functional. If there are lines of code that need to be removed, I don't hesitate to let my colleague know that while also giving them feedback on why I feel it is unnecessary."
2nd Answer Example
"When I'm asked to do this in my current position, my main focus is on regulatory requirements that were put in place for the project and security issues. I work with a team of great engineers that are very efficient coders and these two areas are most often overlooked."
5. At Optum we value organization. Tell us about a time when you were particularly effective on prioritizing tasks and completing a project on schedule.
How to Answer
An interviewer needs to hear that you have a plan in place to keep yourself organized. Start off by mentioning that you are typically an organized person. From here, dive into a recent time-consuming project that you were involved with.
You might say, 'I recently was involved with a project that required 30 hours of my time in a two week period while I was also in the middle of several other projects.'
Tell the interviewer that you started off by ensuring you had your schedule mapped out before you dove into your workload. Discuss if you made a to-do list, updated your calendar, or created a color-coded agenda. Share whatever organization method worked for you! Next, tell the interviewer how you prioritized the work. You may share that each day you sat down to determine the urgent needs for that day and marked them with a letter A. Perhaps you identified anything that would be nice to get done that day with a letter B. And, maybe you just left everything else that could wait for another day unmarked. Tell the interviewer how you diligently stuck with this plan for the duration of the project and how it allowed you to complete the project on time without any stress successfully.
Answer Example
"Last week I was asked to lead our team while our manager was away. I created a checklist of things that needed to be completed to reach our deadlines. I gathered the team to discuss our goals and asked for input and ideas to get us there. It was a great experience for me because not only was I able to exercise my leadership capabilities; I was also able to learn more about prioritizing, from my team."
6. In SQL, how do you explain the differences between clustered and non-clustered indexes? Can you name a time that you used each?
How to Answer
Optum uses indexes to improve query performances within their software and for this question, your interviewer is looking to hear that you have a basic understanding of both clustered and non-clustered indexes. Explain the differences between the two types of indexes and be sure you can either speak to relevant times that you've used each or when would be the appropriate application to use each.
1st Answer Example
"In the simplest of terms, a clustered index order records in a table the way that they are physically stored. There can only be one clustered index per table. Non-clustered indexes do not store data to match the physical order that it is stored. Rather, it can hold up to 249 indexes per table. Both types come with their own benefits over the other. In my experience, clustered indexes are suited best for programs that use primary key as an identity integer column. On the other hand, non-clustered make the most sense for programs that need JOIN and WHERE clauses within them."
2nd Answer Example
"In my experience, clustered indexes are faster to read but very slow when it comes to update data within. Non-clustered indexes are just the opposite in that they are slower to read but much fast to insert new data into them. In my current role, I mostly use clustered indexes when large numbers of rows need to be retreived and when insert operations are important. Most other times, I will use non-clustered as the standard."
7. What do you feel are the primary features and benefits of the Java programming language?
How to Answer
As a company that utilizes Java, Optum and your interviewer want to make sure that you have an understanding of the Java programming language and they do so by asking this question. Obviously a language packed with unique features, talk about the features that you can speak the most knowledgeably about and tie your direct experience to.
Answer Example
"When I started working with Java three years ago, the first huge benefit was the fact that the Java syntax was based on C++. At that time, I had a great working knowledge of C++ and my transition to Java was absolutely seamless. The other amazing feature that I've come to appreciate with Java is how robust the memory management is in exception handling and automatic garbage collection."
8. What is one unique personality trait you possess that would help you be successful in this role with Optum?
How to Answer
This question is allowing you to have the floor during your interview to wow your interviewer with something they might not know about you yet from your resume or time so far during the interview. Think about a strong, unique trait that you have that has led to prior success in your field and explain in detail how this will help further you in your career with Optum. If possible, be very unique in your answer to draw a direct line between your personality and success in this role.
1st Answer Example
"From what my parents have told me about me as a young child, passion has been a personality trait that has driven me my whole life. When I tackle something in life, I need to be passionate about it for it to be a success. From my time as a young child up to today, I have been passionate about physical fitness and this has driven me to participate in running and biking races across the country. This same passion in the pursuit of excellence has translated into my career as a software engineer. From tinkering with computer hardware at a young age and learning the internal components of a system to learning how to create and design software, you'll quickly find that my passion to engineer the most unique software here at Optum will be extremely beneficial to your team."
2nd Answer Example
"I would have to say that my humility has been instrumental in getting me to where I am at today in my career. Having worked with one of the largest software companies in the world, egos were certainly high with a lot of my teammates and I have always used my humility to let my work do my talking for me while remaining a friendly and curious colleague to all."
9. If you can, please provide your thoughts on the function of managed object context in developing iOS apps and software.
How to Answer
While the core data framework and the managed object context may seem pretty easy to comprehend and simple from a first look, a deeper look into managed object context shows that it can be misused to the point where obscure bugs can enter the system. Give your interviewer your own personal insight into the purpose of managed object context and how it works behind the scenes to help an app properly run.
1st Answer Example
"In my current work, I work with both main queue and private queue manged object contexts. It is important that I avoid non user related data processing on the main queue of an app that I am developing. In times where this has happened in the past, the user interface becomes unresponsive and crashes. As well, I work to avoid instances passing between the main and private queues to avoid corruption of data within the app."
2nd Answer Example
"Knowing that a managed object context's job is to manage a number of records within an app, my job is to successfully manage each object within the app and assign it to a correlating context within the app. I have to consider the persistent store coordinator and code the app to fetch requests from the correct one."
10. In designing Android software, what is your experience using parcelable versus serializable within an app?
How to Answer
Because parcelable is optimized for Android to be faster and more customizable, your interviewer will be looking to hear that you are willing to put in the extra work to utilize the parcelable method to achieve better performance within the software that you design. Give your interviewer your thoughts on the differences between the two methods of passing object references to activities within an app that you design and make sure that they understand that you are ready to perform the work to utilize the parcelable method when necessary.
1st Answer Example
"Having written code for Android apps for many years now, I am very familiar with both serializable and parcelable methods. In my first hand experience, parcelable provides a much faster and better user experience so I will always strive to take the time to write custom code for marhsaling and unmarshaling to create less garbage objects within an app."
2nd Answer Example
"Due to it being a standard Java interface and its ease of implementation, serializable interface is pretty commonly used. But, because it uses reflection, many temporary objects are created within Android apps and this creates a very poor user experience. When the parcelable interface was introduced for Android systems, I have extensively focused on its use and finished products have benefited greatly."
11. In your current work, what are the important steps you take in the data validation process?
How to Answer
Depending on your training and your past roles prior to interviewing at Optum, you may be familiar with one or two of the many trains of though regarding the steps of a data validation. Whatever formal process you are familiar with, be sure to check the boxes of discussing data screening and data verification as part of your process. Your interviewer will be looking to hear that you check those boxes as they are imperative in the software field.
1st Answer Example
"As I embark on a data validation process in my current role, my first step is to roadmap a detailed plan to keep on task. I utilize benchmarks and the expectations of key stakeholders as my guide. Once underway, I validate the database and the data formatting to ensure that data is properly screened for its overall health. Then, by finishing with sampling, tests are performed to hopefully show that the data is useful within the system."
2nd Answer Example
"The most important steps in a data validation process are determining the data to sample, scouring the existing database and validating the final data format. My first step is to use my best judgment to determine if I will validate a sample or the entire data set. This determination is based on overall size of the set and the timeframe that I have to work on the project. Then, I take the time to screen data in the existing database to calculate the number of unique ID's and records to come into the system. Last, I have to verify that the source data matches the schema within the targe"
12. What programming languages would you consider yourself fluent in?
How to Answer
While this question gives your interviewer insight into the diversity of your programming language experience, they most importantly want to know that you are adaptable and able to learn on the fly if needed. Talk about the different languages that you consider yourself fluent in and, if possible, do as much research into Optum as you can prior to your interview and try to speak to the specific languages that they work with.
1st Answer Example
"From the start of college, where software engineering grew into a passion for me, I've become very fluent in Java, JavaScript and C++. My current role has me working primarily with C++, but I pride myself on my ability and passion to learn new programming languages and would be able to do so if hired for this role with Optum."
2nd Answer Example
"During my training to be an engineer and then in my current role since graduating, a majority of my experience falls within Python. My current role delves deeply into artificial intelligence and Python is awesome with this advanced technology. As I understand it from talking to another engineer here at Optum, a requirement would be for me to learn Scala. Though I haven't worked directly with Scala, I believe my experience and willingness to learn would have me up and running in no time if hired for this role."
13. If hired here at Optum, what do you feel would be the biggest hurdle for you to overcome from the start?
How to Answer
The key to answering this question with confidence starts with understanding that you are interviewing with Optum because your interviewer feels that you are a strong candidate for this position. What your interviewer is focusing on with this question is how they could be of most help to you if hired for the job. So, take the time prior to your interview to think about an aspect of the position that would be the most difficult for you to overcome to be up and running at full speed and then take time to explain how you would plan to overcome that hurdle if hired. This structured answer will tell your interviewer that you have put thought to your potential shortcoming with a plan of action.
1st Answer Example
"As you can see from my resume, I don't have any direct working experience with the financial industry and I would see that as my largest learning opportunity if offered this position. Like I did with my current job in the healthcare industry, I would take the time to learn the basics of the industry that would help me design the most intuitive user interfaces in the products here at Optum."
2nd Answer Example
"Being a team player by nature, I've always considered my first challenge at any new company to be the task of getting to know my colleagues, their work preferences and their work styles. In the same breath, I want them to know who I am and how I best work as part of a team with them. To accomplish this, I would take the initiative to set one on one meetings with individuals that I didn't get to touch base with during my orientation process to get to know them better."
14. What software analysis and design tools do you have familiarity working with?
How to Answer
As a software engineer for Optum, your interviewer wants to hear that you have experience in utilizing tools that you make you more proficient in your work. Dig back on your past experiences and talk openly about your experiences with the different analysis and design tools that are available to help you be better in the work that you do. In the end, make sure that your interviewer understands that you are proficient in the use of these tools and open to learning and using new tools as well.
1st Answer Example
"As my career and experience in software engineering has grown over the years, I've come to really appreciate and utilize these tools that are available. A great example of this would be my recent education and use of Structured English for designing insurance claim software for a large auto insurer. The simplicity of the structured decisions in the program were a perfect example of a program that could utilize the tool and the end product ended up very functional for our customer."
2nd Answer Example
"I have great working knowledge in creating and reading data flow diagrams. To help with both our own sales staff and with customers, DFD's have been super helpful and I consider myself very proficient in creating them. I've also recently been introduced to decision tables to aid in product testing. I was working on a new system that involved some very complicated business rules and the decision table helped outline everything perfectly for our testing."
15. Culture fit is important to us at Optum. How would you describe your personality?
How to Answer
Personality and character are two very different things. The interviewer is looking for more information on your traits vs. your integrity. This answer could include buzzwords such as introverted, energetic, and confident.
1st Answer Example
"I would describe my personality as approachable, light-hearted, and positive. I believe that, if asked, my colleagues and supervisor would say the same about me."
2nd Answer Example
"Try to include a variety of words that the interviewer does not hear all the time. Be unique! Here are some ideas:
- Adaptable
- Considerate
- Diligent
- Intuitive
- Persistent
- Resourceful
- Sincere
- Witty"
16. At Optum, we take security risks very importantly in our products. In your experience, what are the biggest security risks in software and what is your experience in any prevention methods?
How to Answer
As an expert in software industry, you are obviously aware of the many security risks that systems face in this day and age. For your answer to this question, talk knowledgeably about the security risks that you are most familiar with combating in your day to day work. Explain why the posed risk is important to combat against and talk about the methods you used to minimalize risk in the finished product.
1st Answer Example
"As I'm fully aware, cyber-security has become a very important issue over the past ten years. In my current role, our biggest security risk is injection of code used by hackers to access information in our web applications. To help prevent any risks associated with injection, we've implemented the use of a safe API and using specific LIMIT and other SQL controls within queries to prevent loss of records in case of an injection."
2nd Answer Example
"In the healthcare field where I currently work, broken authentication vulnerability has allowed attackers to hack into electronic medical records and gain control over those systems. This type of attack potentially puts hundreds of thousands of people at risk within a given system. We use many methods to prevent this type of security risk. First, we take the time to properly test the code before rolling out new updates to software. We also utilize very detailed external security audits. Other details we have implemented have been multi-factor authentication processes and recommendations to align password requirements with the NIST guidelines."
17. Do you have experience working with different CASE tools? If so, what do you have experience with?
How to Answer
The world of software engineering has greatly benefited from advancements in computer aided software engineering tools. Because Optum is at the forefront of the industry, your interviewer will be looking to hear which tools you have experience with. Make sure not to concern yourself with providing a correct answer here, but rather focus on your flexibility to learn new aides when needed while explaining what you have experience with.
1st Answer Example
"In my current role, I regularly utilize both diagramming and web development tools. The diagram tools assist our software projects by outlining the system data and components in a graphical form for us and this saves us a great amount of time while also being very reliable. The web development tools greatly help me visualize site changes that I am making because I don't have a deep background in web development. If hired for this position, I'd look forward to learning other CASE tools for prototyping, quality assurance and maintenance."
2nd Answer Example
"During my career and in my experience with CASE tools, most of my experience is in the lower CASE elements that focus on coding and testing the software after initial development. CASE tools have certainly made life as a software engineer more efficient and effective and I'd look forward to learn any new CASE tools if hired for this position here at Optum."
18. If hired for this position here at Optum, would you be comfortable handling overall project manager responsibilities for new software development?
How to Answer
As a skilled software engineer, you have all of the necessary tools in your bag to be a successful engineer at Optum. This question is allowing your interviewer to get a better sense of your project management skills and people skills if you were to join the team at Optum. In your answer, talk about your ability to estimate the time and cost of a project, the staffing needed and the overall scope of planning for a particular project. If you have direct experience in being the lead on a large development project, be sure to discuss that experience with your interviewer.
1st Answer Example
"Looking to join the team here at Optum directly out of college, I feel very confident in my abilities to manage the entire scope of a new development project. I have leadership experience as my campus' president of the software engineering club. In that role, I developed skills that would help me utilize staff and resources in the best way possible. During my internship, I was exposed to the planning stages of new projects and I have a very good feel of estimating the budget and length of time needed to have a fully functional system."
2nd Answer Example
"I would absolutely be comfortable if tasked with project manager duties here at Optum. In my last two roles, I have led successful projects that started with great planning and budgeting process and went through to completion with great people and processes in place under my leadership. While it's not a regular duty for me in my current role, I always welcome leadership duties."
19. Do you have experience writing a custom exception in Java?
How to Answer
As a Java expert, you will hopefully have the ability to inform your interviewer that you do have experience in writing custom exceptions in Java. As a reputable software company, the engineers and architects with Optum often need to demonstrate the ability to do just this. While talking about the experience that you do have, be sure to discuss your thought process in initially determining the need for writing a custom exception above and beyond the standard Java exceptions.
Answer Example
"Yes, I certainly do have experience writing custom exceptions in Java in my time in the financial software industry. Because some of the business logic and workflow needed customization, I was tasked with extending the exception class and all subclasses in standard Java to create the custom exceptions needed."
20. Looking at our products and services, what do you think we do better at Optum than any of our competitors?
How to Answer
Before your interview, be sure to research Optum and any awards or recognition they have recently received. In their industry, and competitive space, where do they stand out? Be sure to speak positively about the organization's recent achievements to show that you are interested and engaged in their work.
1st Answer Example
"When I was preparing for this interview I noticed that Optum was recently recognized for innovation in XYZ. You are a trailblazer in this particular arena which is amazing."
2nd Answer Example
"After reading reviews on your company, I believe that your reputation is the most solid and sincere of all your competitors. Amazing service is always the best way to stand out."
21. What SDLC models are you familiar in working with?
How to Answer
As a software engineer, you are very familiar with the software development life cycle. For this question, your interviewer is looking to hear what models you have worked on in the past. While there isn't necessarily a right or wrong answer to this question, try to show your flexibility to working with different SDLC models by bringing up your past experiences. Then, show you have knowledge of different models like the waterfall model or agile model. It is also a good idea to use this question as an opportunity for you to learn more about Optum by asking your interviewer which model they work off of.
1st Answer Example
"During my training in software engineering and in my early career, the waterfall model was the standard. In this model, each phase of the development process happens in a set order and projects using this model are easily managed. But over time, as the development projects that I have led have become more complicated and intricate, I have implemented the spiral model. This model has allowed the ability of end users to give feedback early on and often during development and helps to build a more customized product to our customers."
2nd Answer Example
"In my current position with XYZ Company, my department utilizes the agile model in development life cycle. Since our products are so tailored to the needs of our customers, we get a working product very early on in the process and then I work hand in hand with customers to fine tune the software moving forward. It is a very effective model that has built a great reputation for our software among customers. I also have familiarity working with the iterative model and it has similar advantages to the agile model. If I were hired here at Optum, can you expand on what models you use here in your software development life cycle?"
22. Here at Optum, we strive for continuous delivery and continuous deployment with our software. Are you familiar with these processes in your current work?
How to Answer
In the industries that Optum works in, updates to software are vital to end users for them to stay at the forefront of their business. To ensure that updates happen as quick and smoothly as possible, Optum utilizes continuous delivery and continuous deployment for their customers. For this question, talk about what you know about these processes as a software architect, why they are important and what experience you have with them.
1st Answer Example
"In my current role, we utilize a 100% continuous deployment process with our end users when we role out new changes to existing software. We use automated testing in our process to validate that code changes are correct and able to be deployed without issue. Once validated, changes are automatically rolled out to our end users. Having once utilized a continuous delivery system, I am very appreciative of working in an environment utilizing continuous deployment as it negates any need for human intervention in the roll out."
2nd Answer Example
"In my current position, we've slowly grown from a continuous integration process to a continuous delivery process. I love the automated testing process when we are looking at rolling out new changes to existing software and my role as the architect for our projects puts me in the drivers seat for sending out these changes. If hired for this role here at Optum, I'd be very intrigued at learning and working with continuous deployment practices as well."
23. Here at Optum, we utilize feasibility studies with our customers to consider all impacts of a new system for them. Do you have familiarity working with feasibility studies in your work as a software engineer?
How to Answer
To properly answer this question, make sure you understand the reasons why feasibility studies are important. In essence, a feasibility study helps to determine if conditions are right to implement a project. The study looks at economic, operation, legal and technical aspects of the project to determine if moving forward with the project is best for all involved. If you have experience in the studies, talk about a specific time that you utilized a study, the steps you took and explain why it was important to do in the end. Make sure that your interviewer walks away from the interview comfortable with your ability to utilize feasibility studies in your work.
Answer Example
"I do have familiarity with feasibility studies throughout my career as a software engineer. On a current project that I am working on, we utilized a study to analyze if the project we were tasked with could use current technologies available to us while meeting a timeline for completion. On my end, I had to spend time researching the resources that were available, gauge their functionality and come up with a plan for action based on that. Where the project stands today, we are on pace for delivering a revolutionary system for a large security industry customer."
24. What do you see as the top benefits of moving to a cloud based computing platform?
How to Answer
While cloud based computing has certainly had its positive impacts across many different industries, the field of software and technology development has its own unique benefits. For this question, your interviewer will be looking to hear that you understand just how a cloud based platform benefits the field. In your answer, focus on resources that impact both the work that the team at Optum performs and the end users of the software.
1st Answer Example
"Over the past couple of years in my current position, we have greatly benefited from the vast amount of testing and staging servers that available on the cloud. In developing new programs, our testing and delivery has greatly increased our team's productivity to new levels. Add on the simple cost savings of the cloud and a move to the cloud was a no brainer for us in the end. If hired for this role here at Optum, I'd be able to bring new cloud computing ideas to your team from day one on the job."
2nd Answer Example
"As with any of the work that I have done in this field, I focus on the consumer and the benefits that they can reap from my work. In the cloud, updates to existing software are made available almost instantaneously and end users have access to those updates with the simple click of a button. Rewind to years prior, these software updates took time and manpower that are almost unthinkable by today's standards."
25. What experience do you have in the different types of software maintenance?
How to Answer
As a reputable company, Optum takes their software maintenance processes seriously and your interviewer is looking to hear that you are familiar with the four different types of software maintenance. Talk to your interviewer about any work you have done in the past with corrective, adaptive, perfective and/or preventative software maintenance. Use specific examples and make sure that your interviewer walks away from your conversation knowing that you understand the importance of proper system maintenance.
1st Answer Example
"Being familiar with all four types of software maintenance, my most used method of maintenance in my current role is corrective. Based on bug reports from end users, I work through coding and logic issues to resolve issues in a timely and effective manner. In the maintenance I perform, I never hesitate to pick up the phone and contact customers to hear first hand about what they are experiencing. By doing this, they feel like they are an important part of the process and it reflects well on me and my organization."
2nd Answer Example
"In my current role, I'd definitely say that a majority of the maintenance work that I do is adaptive maintenance. Working in banking software that is used around the globe, I help perform system maintenance for changes in currency on a pretty regular basis. This work requires research and talking with end users to help adapt the programs for their use. If hired here at Optum, I also have experience performing perfective, preventative and corrective maintenance on software as well."
26. What data cleaning methods are you familiar with and comfortable using if hired for this role at Optum?
How to Answer
To improve data quality and increase overall productivity of a system, Optum relies on their data analysts to use data cleansing methods to ensure quality data exists in their software. Be open and honest with the ways that you've helped ensure quality and accurate data in the systems that you've worked with while also showing that you have an open mind to learning and utilizing more methods if hired for this position.
1st Answer Example
"In my current work, I use a very methodical fashion in cleaning data for finished systems. My first step is to remove duplicate and irrelevant observations within the data. Then I scan the data to remove extra spaces, convert numbers stored as text into numbers and remove duplicate data. These steps help ensure clean and accurate data and I never overlook them. If hired for this position, what methods does the current data analyst team her at Optum utilize?"
2nd Answer Example
"I am familiar with many methods used in the cleansing of data. The initial monitoring of errors within a system is very important to identifying where errors occur and give insight into how to fix corrupt data. I have utilized the tools within Domo software to validate data accuracy and scrub for duplicate data in my processes as well. Being very proficient in data analysis, I'm very open to learning new methods as well if hired for this position."
27. What do you feel is one of the top issues that is faced by data engineers today?
How to Answer
Being in the midst of the greatest technological revolution in the history of man, data engineers face many difficult issues in the work that they perform on a daily basis. While there are many directions that you can go with this question, be sure to focus your answer on something that you can speak passionately about. If you can research a common issue in the industry that Optum works in, you may likely score some bonus points with your interviewer.
1st Answer Example
"Over the past couple of years, I've come to realize that one of the largest issues we face as data engineers is the large amounts of data that are needed to store and then draw information from. Here at Optum, I can only imagine how big of an issue that is in the healthcare industry. I have a lot of experience with cloud based data storage and also server based storage."
2nd Answer Example
"In my recent experiences, continuous, real-time integration is an issue that we will face each and every day moving forward. The need for fast paced information is certainly to blame for this. To stay on top of the continuous integration landscape, I am happy to hear that new and improved systems are being created to stay more real-time and up to the minute. Here at Optum and working in the financial industry, how have you seen this need for real-time data impact your products?"
28. Here at Optum, we ask our test engineers to follow specific QA protocols. What role do you feel QA plays in software development and testing?
How to Answer
As an experience software testing engineer, quality assurance should be ingrained in your brain and your interviewer is looking to get a sense of your personal feelings towards it in your work with this question. In your answer, be sure to highlight QA's importance in reducing errors, maintaining specifications, testing failure parameters and preventing defects from occurring. In the end, make sure that quality is your mantra in the eyes of your interviewer by giving an example or two of how you put QA in the forefront of your work.
1st Answer Example
"As a test engineer, I take great pride in my role of ensuring that systems go out to consumers as error free as possible. In my current role, I take the time to learn all of the system specifications that are laid out by our design engineers and customize my testing to follow those specifications."
2nd Answer Example
"In my work throughout my career, quality assurance in my testing was an every minute of every day job on my part. While creating effective testing processes on new software is extremely important in following QA protocols, the recording of defects, issuing of reports and assisting the designers on fixing issues are equally important parts of the process that I'd love to let shine here at Optum."