MockQuestions MockQuestions
Interviews Questions by Career
Interviews Questions by Company
Interviews Questions by Topic
Get Started
Interview Coach 1:1
Gain the confidence you need by asking our professionals any interview scenario, question, or answer you are unsure about.
Let Us Review Your Answers
Our interviewing professionals will gladly review and revise any answer you send us. Allowing you to craft perfect responses for your next job interview.
Interview Questions by Topic
Interview Questions by Career
Interview Questions by Company

REI Systems Interview
Questions

28 Questions and Answers by Ryan Brunner

Published December 13th, 2019 | Ryan has over 10 years of experience interviewing
candidates in the healthcare, public service, and private manufacturing/distribution industries.
Question 1 of 28
What do you consider to be a good litmus test for when you would automate a test process for a new system versus testing manually?
View Answers
How to Answer
As your role with REI Systems will look to help further their automate testing processes for new systems, you will need to have a good sense for when automation makes sense and when it does not. Reiterate your sense for this to your interviewer by sticking to the high level response that repetitive tasks, as are common with large software companies, are prime candidates for automation whereas one time test cases are not.
1000s of Interview Questions
Win your next job by practicing from our question bank. We have thousands of questions and answers created by interview experts.
Interview Q&As
Explore expert tips and resources to be more confident in your next interview.
Behavioral
Common
Phone
Tough
Leadership
All Interview Topics
All Career Q&As
Top 25 REI Systems, Inc. Interview Questions with Full Content
1.
What do you consider to be a good litmus test for when you would automate a test process for a new system versus testing manually?
As your role with REI Systems will look to help further their automate testing processes for new systems, you will need to have a good sense for when automation makes sense and when it does not. Reiterate your sense for this to your interviewer by sticking to the high level response that repetitive tasks, as are common with large software companies, are prime candidates for automation whereas one time test cases are not.

Ryan's Answer #1
"Having been in automation in both manufacturing for many years and now software for the last three years, a common misconception among people is that automation can help improve any situation and that couldn't be further from the truth. The amount of time, effort and resources that goes into an automation process makes it ideal for repetitive tasks and tests that have multiple data sets. If a testing process calls for unique and one time process, it would make the most sense to run that process manually."
Ryan's Answer #2
"I"n my current position, most of the automation testing that I design is in program sanity testing. These automated tests work great because they run on similar systems following changes in code to ensure that no bugs remain in the system. If our group of engineers are working on unique, one off type projects, my automation processes are not utilized."
2.
When would you utilize a trigger within Oracle to execute a function automatically?
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.

Ryan's Answer #1
"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 REI Systems, you could have full confidence in my ability to utilize triggers within Oracle."
Ryan's Answer #2
"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."
3.
In your current work, what are the important steps you take in the data validation process?
Depending on your training and your past roles prior to interviewing at REI Systems, 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.

Ryan's Answer #1
"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."
Ryan's Answer #2
"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"
4.
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?
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 REI Systems.

Ryan's Answer #1
"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."
Ryan's Answer #2
"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."
5.
How do you measure the success of a data integration project?
Similar to evaluating any project, measuring the success and impact of any data integration project should rely on goals that were defined at the start of the project. In your answer, be sure that you speak about the consideration for the people involved in the project (i.e. customers, sales, IT, engineering) and how success was measured in their eyes. Another great point to touch on in your answer is using the SMART method for setting goals to assure that they are specific, measurable, attainable, relevant and time oriented.

Ryan's Answer #1
"With any large data integration project that I have managed in the past, success starts with setting realistic yet high standard goals for the project. To do this, I need to make sure that I get input from all key stakeholders in the project. With a recent project, we measure our success in a few different ways. Because of the need set forth by our sales force to be more competitive with our competition in the market, we measured timeliness of the system pre and post integration. Then, to measure the financial impacts of the project, we measured our end of project costs versus what was budgeted. Because our goals were measurable, it was easy to see that the project was a huge success."
Ryan's Answer #2
"I think that I can best demonstrate this by talking about a recent data integration project we worked on in creating new banking software. At the beginning of the project, we clearly defined the end goals of the project in the data we wanted converted with a set deadline for completion. Our design team added their expectations on their desired workflow following the data conversion. One integration was complete, our goals were easily measured for the project to be considered a success."
View All 28 REI Systems Questions and Answers
Sign up to access our library of 50,000+ Q&As,
plus coaches for one-on-one support, so you can interview more confidently.
More Interview Q&As
Explore expert tips and resources to be more confident in your next interview.
Behavioral
Common
Phone
Tough
Leadership
All Interview Topics
All Career Q&As
About Our Interview Q&As
Our interview questions and answers are created by experienced recruiters and interviewers. These questions and answers do not represent any organization, school, or company on our site. We do not claim they will be asked in any interview you may have. Our goal is to create interview questions and answers that will best prepare you for your interview, and that means we do not want you to memorize our answers. You must create your own answers, and be prepared for any interview question in any interview.