28 OpenText Interview Questions & Answers
1. How have you handled obstacles that you've faced during information gathering processes in your time as a technical writer?
How to Answer
To successfully document and write about software products, information gathering from subject matter experts will be a key part of your process if hired for this role at OpenText. As you have likely experienced during your career, the information gathering process can be one of the most painstaking processes within the life of a project. For this question, your interviewer is looking to hear what obstacles you have faced in this situation in the past and how you handled those situations. This will give them insight on how you will work as part of a larger team in handling these perceived obstacles if hired for this position.
Written by Ryan Brunner on February 24th, 2020
1st Answer Example
"Because the information gathering phase is a vital step in my finished projects, I take the time to meet as many credible sources as possible. This includes design engineers, automation engineers, product designers and many other folks and the biggest hiccup that I usually come across is coordinating time with folks that have busy schedules. To help minimize the total time frame for info gathering, I am very direct in my communications to key leaders that I want to meet with to finish a project and my directness is always taken well. Like any obstacle we face in our work, I find that being upfront and direct is the best manner for handling them."
Written by Ryan Brunner on February 24th, 2020
2nd Answer Example
"I'd say that one of the more common obstacles that I have faced in my current role as a technical writer is a lack of expectations from the experts that I consult with through the process. To better this over time, I have created a set of general expectations that I provide to people ahead of our meetings that help them prepare information ahead of time. This approach not only helps me get more relevant information up front, but also helps speed the information process up significantly."
2. How would you handle a situation where a colleague was being very difficult to work with?
How to Answer
In the team based atmosphere at OpenText, departments with different skills and backgrounds can often see things from different points of view and these situations can cause some internal conflict between coworkers. With this question, your interviewer is looking to hear how you handle situations where you are working with someone that can be seen as difficult. To give them the sense that you are able to work through conflict in a professional and sensible manner, try to talk through how you handled a conflict at work previously in the past and highlight the interpersonal skills that you used to help make it a positive situation.
Written by Ryan Brunner on February 24th, 2020
1st Answer Example
"In all honesty, any great work atmosphere that I've been a part of in the past has involved conflict between colleagues. In situations I have witnessed, conflict has stemmed from very open-minded people giving their two cents in particular situations and two people not seeing eye to eye. This happened recently to me in the planning phases of a new project. On of our UX Designers and I had a disagreement on the final layout of a new software roll out we were planning. It worked best for both of us to talk about our ideas and list the pro's and con's for our ideas. I kept an open mind to learn from her point of view and she did the same to me on my end. This led us to come up with a great compromise in the end."
Written by Ryan Brunner on February 24th, 2020
2nd Answer Example
"Last year, we had a new engineer join our team that was hired on from his internship with us. From his first day, he made it very evident that he would only handle certain tasks within our team and only work on certain projects. As his mentor to help get him up and running, I sat him down and discussed the expectations of each of our engineers as part of our larger team. I explained to him that our approach was not to pigeonhole ourselves into smaller tasks, but rather be well rounded engineers that could handle any project and be able to cover for each other if needed. He really appreciated this approach when I explained the benefits for his long term career goals with this approach. This example shows my approach to being very direct with people that I have a conflict with in the workplace and doing so in a very professional and educational manner."
3. Do you have experience working with data in a cloud computing environment?
How to Answer
Over recent years, more and more companies are converting to cloud based computing services because the conversion allows them to save money and have better auditing trails. As a prospective data engineer with OpenText, your interviewer will be looking to hear that you are at least familiar with the concepts of working with cloud based data. Talk in details about the experiences you have while keeping your mind open to working with more in the future if hired with OpenText.
Written by Ryan Brunner on February 24th, 2020
Answer Example
"My current organization has been using Apprenda, a PaaS, that allows us to develop, test and maintain our software projects. I also have experience mining and converting data off of public, community and private cloud networks. If hired here at OpenText, I think I would bring a wealth of cloud based experience to the data engineering team."
Written by Ryan Brunner on February 24th, 2020
4. When do you consider a project to be finished?
How to Answer
When answering this question, be sure to understand what the employer is truly asking. They are looking to see where you think the project ends, whether that is when it's completed and all testing is done, or whether you think projects are ongoing and require constant work. It can be a trick question as many companies believe a project is never truly finished. Be sure to give an explanation with your answer to back up your belief.
Written by Marissa Letendre on February 24th, 2020
1st Answer Example
"In my mind, a project is never truly finished. Once it's rolled out, upgrades will have to be performed, quality checks will have to be completed, and the product will inevitably change based on customer needs, new technologies, and trends in the market. We have to take that all into consideration when working on a project and while maintaining the product that was completed as a result of the project."
Written by Marissa Letendre on February 24th, 2020
2nd Answer Example
"I should disclose to you that I have a mark on my criminal record. I have a DUI from 1998. Since then I have maintained a clean record and I am willing to comply with any form of background check that you require."
5. 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 OpenText, 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.
Written by Ryan Brunner on February 24th, 2020
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."
Written by Ryan Brunner on February 24th, 2020
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."
6. 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 OpenText, 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.
Written by Ryan Brunner on February 24th, 2020
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."
Written by Ryan Brunner on February 24th, 2020
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"
7. What software analysis and design tools do you have familiarity working with?
How to Answer
As a software engineer for OpenText, 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.
Written by Ryan Brunner on February 24th, 2020
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."
Written by Ryan Brunner on February 24th, 2020
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."
8. 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 OpenText 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.
Written by Ryan Brunner on February 24th, 2020
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."
Written by Ryan Brunner on February 24th, 2020
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 OpenText."
9. In your mind, when is monkey testing the most effective in testing new software?
How to Answer
By utilizing random inputs to check the behavior of a program, monkey testing has its time and place in the software testing process. For this question, your interviewer is looking to hear that you have an understanding of the theory behind monkey testing and how you would look to put it to work at OpenText to test their products.
Written by Ryan Brunner on February 24th, 2020
1st Answer Example
"In my experience, monkey testing has been very effective in load testing and stress testing new software as standard testing methods couldn't do this without a lot of extra work. Because of the adhoc approach to the testing, load and stress on the software was most highly gauged through monkey testing."
Written by Ryan Brunner on February 24th, 2020
2nd Answer Example
"Because monkey testing is able to find unique bugs that standard testing won't find, I've found it to be very effective for testing new pilot software programs that are reaching new bounds. At my current job, I helped design a brilliant monkey testing process that utilized user behavior to look for certain probabilities of bugs within our systems that we were designing."
10. Would you say that you are a goal oriented on the job? What would I be able to do as your manager to help you achieve your goals if hired here at OpenText?
How to Answer
At the heart of this question lies your interviewers desire to see what motivates you as a potential employee at OpenText. Make it clear to your interviewer that you certainly are motivated by on the job goals and do this by using an example of a time where you were motivated by and achieved a goal. Then, think deeply about the type of manager that you like to work for in terms of goal setting and helping our achieve your goals. Let your interviewer know what type of management styles you appreciate the most while being open to any style.
Written by Ryan Brunner on February 24th, 2020
1st Answer Example
"I would definitely say that I am goal oriented on the job in wanting to contribute any way that I can to the overall benefit of the organization. In my current organization, our leadership focuses on overall sales numbers at the end of the year. To help achieve these goals, our department creates our own goals to help achieve the sales numbers needed to succeed. Last year, one of those goals was to be as creative as possible in our user experience design processes. With the launch of an exciting new app midyear, sales numbers skyrocketed and our department was instrumental in that. For me, it was important that we determined our goals as a team with the final stamp of approval from our manager. While this style of management really helped motivate me, I can thrive under any management style as long as expectations and goals for my work are clearly set."
Written by Ryan Brunner on February 24th, 2020
2nd Answer Example
"For me, my day to day work is much more meaningful when I have goals to work for. In my current role, we have set timelines for our projects and this helps lay the framework for our goals. If hired for this position, my expectations of you as my manager would be to have goals clearly defined and a supportive atmosphere to be provided to work within."
11. If hired here at OpenText, 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 OpenText 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.
Written by Ryan Brunner on February 24th, 2020
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 OpenText."
Written by Ryan Brunner on February 24th, 2020
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."
12. Talk about a time when things didn't go as planned on the job. What was the situation and what allowed your to persevere in that situation?
How to Answer
As a professional in the tech industry, you have likely had a project that failed, a promotion that passed you over or a meltdown occur at some point in time. Realizing that your interviewer fully understands and expects that failure happens, talk openly and honestly about a situation where you experienced failure or failed plans. Most importantly in your answer, focus on how you overcame the particular situation and discuss lessons that you learned moving forward that you can bring to this role at OpenText.
Written by Ryan Brunner on February 24th, 2020
1st Answer Example
"A couple of years ago in my first role as a UI designer out of college, my team was tasked with coming up with a very short notice proposal for a potential high end customer. With a week turnaround time, I set right to spending my time gathering information on the company to build a mock design. When the proposal was submitted, I found out that the potential customer scoffed at my idea and the customer went with another organization's proposal for their use. The biggest piece of feedback that I got was that the UI design just wasn't conducive to the type of customers they were expecting. From that point forward, whether it has been with short notice or long-term products, I take the time to communicate with key decision makers from clients to gather information for making my design as user friendly as possible."
Written by Ryan Brunner on February 24th, 2020
2nd Answer Example
"Last year, I was working on a large scale project that put me face to face with a key customer. After traveling onsite with the customer to spend time with them, I exchanged contact information with two of the key decision makers. In the weeks following, I was sending them follow up emails with our business proposals and was getting frustrated at the lack of response from the clients. After my manager had questioned the viability of the potential customer, I picked up the phone and called them directly. It turns out that their responses back to me were being sent to a junk email folder that I neglected to consider. I apologized for the mistake, took action quickly and we came to a great agreement on future business together. After having a laugh about it with my boss, I now incorporate diligent communication follow ups both by phone and email with customers while also regularly checking all email inboxes."
13. What do you feel are the primary features and benefits of the Java programming language?
How to Answer
As a company that utilizes Java, OpenText 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.
Written by Ryan Brunner on February 24th, 2020
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."
Written by Ryan Brunner on February 24th, 2020
14. 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
OpenText 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.
Written by Ryan Brunner on February 24th, 2020
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."
Written by Ryan Brunner on February 24th, 2020
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."
15. Can you describe the software development lifecycle?
How to Answer
With this question, employers are looking to test your knowledge. They want to know how much you've participated in the projects you've been involved in to truly understand the software development lifecycle. The question may seem basic to some, but employers are expecting an accurate answer to know that they're hiring a true pro.
Written by Marissa Letendre on February 24th, 2020
1st Answer Example
"Absolutely. In my last job, we leveraged the waterfall method, making sure we completed each phase of the project - and completed it on time and to the highest quality, before moving on. The software development lifecycle consists of 6 steps, starting with planning, of course, followed by implementation, testing, documentation, deployment, and maintenance. Every step is crucial to ensure we're producing a quality product and also maintaining that product to meet the changing needs and demands of our end users."
Written by Marissa Letendre on February 24th, 2020
2nd Answer Example
"I am new to my career in financial services and sales; however, I have taken an online course focused on cold calling. This course was incredibly helpful and I look forward to meeting and exceeding my targets with OpenText."
16. As a consultant with OpenText, your role will be vital in gather information from our customers in building new technology for them. What would be your goals in an initial consultation with a new or existing client?
How to Answer
Software consultants are the bridge between the end users and the development teams of new software to help come up with new and creative solutions for the business. In this role with OpenText, you will be expected to live in two different worlds and this question focuses on how you will work with end users of the companies products. In an initial consultation, focus your efforts on how you will learn the business needs of the client, talk about what can potentially be offered and then how you will start the creative problem solving process with them.
Written by Ryan Brunner on February 24th, 2020
1st Answer Example
"As an experienced consultant looking to break into the technology field, I will break a lot of awesome client focused skills to your team. In an initial consultation, my number one goal is to learn the business of the client and listen to what they are looking for in my products. Once their need is known, I can knowledgeably speak to the products that I work with to help them create a custom solution to fit their needs. If hired for this position, my first order of business would be to work very closely with the design and engineering staff to know the possibilities of customization. From there, my natural ability to consult with clients would take over in a win-win situation for all involved."
Written by Ryan Brunner on February 24th, 2020
2nd Answer Example
"In consulting with a new client or an existing client looking for system modifications, my number one goal in a first meeting with them would be to lay the framework for how we will move forward and to set expectations moving forward. I would look to understand their business needs and talk with them about all of the solutions possible for them with us as their software provider. From there, I have the ability to set expectations on a time frame for a solution proposal and we can move forward from there. At the end of a first meeting, I want to ensure that the key decision makers are comfortable with me and the business that I represent so they don't hesitate to reach out to me with questions or for clarification on items discussed."
17. We seek to hire highly ambitious people. Where would you like your career with OpenText take you?
How to Answer
Have you researched OpenText enough to know how their internal hierarchy works? Do they have a variety of departments and management levels, offering you choices when it comes to carving out your career path? Talk to the interviewer about your career ambitions specifically related to this role and their organization.
1st Answer Example
"One of the reasons I was so excited to interview with OpenText is because of the endless growth opportunities you appear to offer your high performing employees. My biggest ambition is to be awarded a management role in the next 3-5 years."
2nd Answer Example
"What interests me most about your company is that there are so many options when it comes to career growth. Ideally, I would like to earn my way into a team lead role, then a division manager position in the digital management department. Eventually, a CDO (Chief Data Officer) level role would be ideal. Of course, I understand that this will take many years of dedication and hard work."
18. What experience do you have in the different types of software maintenance?
How to Answer
As a reputable company, OpenText 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.
Written by Ryan Brunner on February 24th, 2020
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."
Written by Ryan Brunner on February 24th, 2020
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 OpenText, I also have experience performing perfective, preventative and corrective maintenance on software as well."
19. What is one unique personality trait you possess that would help you be successful in this role with OpenText?
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 OpenText. If possible, be very unique in your answer to draw a direct line between your personality and success in this role.
Written by Ryan Brunner on February 24th, 2020
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 OpenText will be extremely beneficial to your team."
Written by Ryan Brunner on February 24th, 2020
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."
20. Do you consider yourself stronger in C++, C#, Java, or Python?
How to Answer
Before your interview, do some research to understand what tech stack OpenText uses so you can best prepare and highlight your expertise. If you aren't as strong in one of the skills you feel is necessary, be sure to explain how you've used it and how you are growing your knowledge to become better. Be sure to be honest in your answer, as the company will likely test your strengths.
Written by Marissa Letendre on February 24th, 2020
1st Answer Example
"In my last company, we had a bit of an outdated tech stack and used C# and .NET. I found myself fully immersed in those technologies, but had a strong desire to learn more and become more familiar with modern technologies and how I can apply that in my career. That's what has me so interested in this role. Over the last year, I've taken courses in Java and C++, which I noticed you prefer. I've become proficient in the skills and in side projects, applied my increasingly strong knowledge. I'm probably strongest professionally in C# as that has been where my experience lies, but my passion and dedication is on the Java and C++ side, as I feel that's the more modern alternative. I'm excited about the possibility of applying that knowledge in a role at OpenText."
Written by Marissa Letendre on February 24th, 2020
2nd Answer Example
"I am motivated and excited about this new opportunity because it will challenge me to grow in my (X) skills. I love soccer and enjoy spending time with my teammates. I am interested in continuing my education by studying (Y) to further my career."
21. 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 OpenText as you can prior to your interview and try to speak to the specific languages that they work with.
Written by Ryan Brunner on February 24th, 2020
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 OpenText."
Written by Ryan Brunner on February 24th, 2020
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 OpenText, 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."
22. In Oracle, do you understand what a join is and what the various types of joins are?
How to Answer
As a software developer that utilizes Oracle databases, your interview will expect that you have a strong working knowledge of concepts within oracle. One such concept is joins. Let your interviewer know that you understand that join is used to combine columns from multiple tables based on values within the columns to allow you to query data from those multiple tables. Then, explain what you know about left, right, inner, full outer and cross joins.
Written by Ryan Brunner on February 24th, 2020
1st Answer Example
"Having worked with Oracle for the past five years, I have a strong experience in using join to query data from multiple tables within the system. I have written queries utilizing left and right join, but the majority of my work in my current role utilizes inner join. This query looks to select data that is common in multiple tables and has been extremely useful in healthcare related software."
Written by Ryan Brunner on February 24th, 2020
2nd Answer Example
"I do fully understand the join process in Oracle and have experience working with all of the types of joins that are possible in querying in the system. I've recently become very familiar with the cartesian cross join that basically joins all rows from multiple tables. In recently helping develop a program for the auto sales industry, I created a grid in Oracle that populated all of the common specs of makes and models of vehicles and the cross join made this much easier."
23. When would you utilize a trigger within Oracle to execute a function automatically?
How to Answer
To answer this question, it is important to first have an understanding of what a trigger is within Oracle. Simply defined, a trigger is a named block stored within the database that executes on its own when a certain even takes place. While you talk about your understanding of what a trigger is, be sure that you explain that you understand how to create a trigger in Oracle and that you understand that proper situations to utilize them in.
Written by Ryan Brunner on February 24th, 2020
1st Answer Example
"In the current work that I do in Oracle, I utilize triggers to prevent invalid transactions within the software that I am working with. I have a full understanding of how to write create trigger statements using declaration statements, executable statements and exception handling statements to set the appropriate triggers. If hired for this role here at OpenText, you could have full confidence in my ability to utilize triggers within Oracle."
Written by Ryan Brunner on February 24th, 2020
2nd Answer Example
"With my two prior years spent working on Oracle, I have written database triggers using insert, update and delete statements that are issued against a table. These database triggers allow our end users to be able to reap the benefits of the triggers. The instances that I've utilized database triggers have been for pulling statistical information from the tables within the system."
24. Here at OpenText, 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.
Written by Ryan Brunner on February 24th, 2020
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."
Written by Ryan Brunner on February 24th, 2020
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 OpenText."
25. The next cloud engineer that we hire here at OpenText needs to be able build a system that can handle a high amount of traffic. How would you test our system's ability to handle large amounts of traffic?
How to Answer
This question allows your interviewer to gain insight into your thought process and ability surrounding building a cloud network that has an architecture that can handle large amounts of traffic without failure. Some key points to focus on your answer are your ability to match capacity to system demand and use horizontal scaling in the design of the system.
Written by Ryan Brunner on February 24th, 2020
1st Answer Example
"Cloud computing has certainly revolutionized the storage of high amounts of data and a key piece that cloud based systems bring to the table are their elasticity for handling large amounts of traffic. I see my job as building a cloud based system to scale horizontally to be able to handle the most data and traffic possible. To test systems, I've used a few different tools that were all very accurate prior to go-live."
Written by Ryan Brunner on February 24th, 2020
2nd Answer Example
"In my current position as a cloud engineer, I have utilized internet scale services like Amazon S3 and Elastic Load Balancing to ensure that our cloud systems could handle large volume that fluctuate seasonally. Because of the great functionality of the internet scale services, internal testing wasn't necessary as we knew we were in good hands through those services."
26. 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.
Written by Ryan Brunner on February 24th, 2020
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."
Written by Ryan Brunner on February 24th, 2020
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."
27. We are looking for innovators to join us here at OpenText. Where have you brought innovation in automation to a process in your career?
How to Answer
Innovation in software has occurred in many phases over the last 20 years and OpenText is always striving to be on the forefront of innovation in their field. For this question, think back on your automation experience and talk about a concept that you helped create that you felt was innovative. Really sell your interviewer on your ability to think outside of the box with this question by hammering home the idea that you can help bring new innovations to the team at OpenText.
Written by Ryan Brunner on February 24th, 2020
1st Answer Example
"To be very honest with you, I was really drawn to the automation side of engineering because of the constant need to be flexible and continuing me education to stay ahead of new trends. Last year, I helped develop a codeless test automation for my company that brought together our software engineers and end users to test in environments in a fast and efficient manner. The codeless testing was a first for my organization and really helped free up time for our software engineers to come up with solutions rather than spend time testing."
Written by Ryan Brunner on February 24th, 2020
2nd Answer Example
"About four years ago, I was on a team that developed an AI bot that could test scripts and provide analysis on extremely large amounts of data in a short period of time. Our work focused on the algorighms that the AI would utilize in its testing work. From the start, the AI process was extremely accurate and efficient. Now, as things have changed over time, modifications to the AI system all center around changes to the algorithms. Based on our success, we presented our AI system at a national conference last year and it received a lot of great accolades."
28. At OpenText, we rely on a full team effort to deliver top quality products to our customers. Tell me about a time that you worked well as part of a team. Are you comfortable in a similar role here?
How to Answer
While this potential role with OpenText will require your to be an independent worker that can think on your feet, you will also need to work as part of a larger team that is working toward one common goal. Because of this fact, your interviewer will want to hear that you thrive in an environment where you work with team members from other disciplines than you are trained in. In your example, stress to your interviewer that you have excellent communication skills and that you fully understand that every person on a team plays a vital role in the organization's success.
Written by Ryan Brunner on February 24th, 2020
1st Answer Example
"Throughout my career, I've always enjoyed working as part of a larger team on the job and this personal enjoyment started with my love of and participation in team sports like baseball and basketball. Growing up playing sports, I learned that each team member brought a unique skill set that could help us achieve our goals. Through a great coaching staff that knew how to make these individual skills shine, this same philosophy holds true for a team that is looking to design a new software system. I know that my skills as an engineer are just part of the final product and I work very well with designers, architects, analysts and sales to help build the greatest system possible."
Written by Ryan Brunner on February 24th, 2020
2nd Answer Example
"I am a people person by nature and my current role has me working very closely with our engineering and design staff on writing technical manuals for our products. While I certainly can handle long days at my computer in solitude, my desire to work hand in hand with others really sets me apart from my peers in this field. I have excellent verbal, listening and written communication skills that, if hired here at OpenText, your entire team would appreciate from my first day on the job."