In SQL, how do you explain the differences between clustered and non-clustered indexes? Can you name a time that you used each?

"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."

iCIMS 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.

"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."

If you were asked to review a colleague's code that they had written, what key things would you look for?

"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."

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.

"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."

In your mind, when is monkey testing the most effective in testing new software?

"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."

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 iCIMS to test their products.

"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."

If hired here at iCIMS and tasked with helping design a UI for a new mobile app, what important factors would you consider in that design?

"Here at iCIMS, I envision users of your products in the banking industry to want security and ease of use in their products. In looking to design a UI for a new mobile app, my considerations would be a secure log-in screen and user profile section of the app. As well, I would put an automatic log out into place within the app. On top of these security items, I would prioritize ease of placement for a contact screen, services screen and an aesthetically pleasing home screen."

With consumer mobility being at an all-time high and only increasing year after year, just about every industry has entered the mobile app game and life at iCIMS is no different. For this question, it is important to have a good understanding of the different mobile UI designs and your job for this question will be tying the business needs of iCIMS into an effective mobile app. In your answer, talk about what you know about the business needs of iCIMS and then explain to your interviewer how you would build those into a great mobile app for their future.

"In the private insurance industry, I can imagine that an onboarding tutorial screen would be very beneficial to users using the app for the first time. I have experience designing these for a few different mobile apps. Other factors I would consider would be prioritizing the important information to have laid out within the app and how to best lay it out. If a menu will be utilized, I would work with key decision makers on what would make the most sense for a menu layout within the app."

If you were confronted with a time where you wouldn't be able to meet a deadline here at iCIMS, what steps would you take when you made that realization?

"In my current position, I am very used to handling multiple tasks and projects on a day to day basis. Last year, my team was tasked with what started as a low priority project. After assembling a team to initially discuss the details and set a deadline for completion with our management, the project unfortunately fell off the radar of everyone on the team with many more high priority projects coming up each week. As the initial project's deadline was within a week of being due, our CEO reached out to me for a progress report. I immediately took full responsibility for letting this fall off the radar and I ensured our CEO that we would have an updated timeline set by the end of the week. In doing this and completing the project to his satisfaction, this was really the tipping point in our department moving forward utilizing a detailed project management tracking system. To this day, I can't say enough about how appreciative I am about utilizing this awesome system. Moving forward, you can rest assured knowing that I take full accountability for my actions and do what is necessary to communicate new expectations and meet them fully."

At some point in any person's career, the inevitable happens and an important deadline needs to be missed. With your interviewer fully understanding this fact, they are solely interested in how you react to this situation and what you do to make the situation right. In your answer, focus on the refocused planning and communication needed while also avoiding blaming others for the situation. Your interviewer holds accountability as a desirable virtue, so be sure to take accountability for actions in your response.

"Having been in this situation before, I would first sit down to gather all the facts possible in the situation. What was the deadline, why wasn't it met and what can be done are all important questions moving forward. From there, communicating to all key parties is extremely important and doing so in a timely manner is critical. In this communication, taking accountability and setting new expectations for delivery in a concise and tactful manner will most often put stakeholders at ease and allow for successful completion."

Give an example of a time that you used a universal design practice in your work as a UI or UX designer. Why was it important to do this?

"From a very high level, the business success of a program really relies on being universally designed. If we pigeon hole ourselves, a product will only reach a very limited group of end users. But taking that a step further, universal design is the morally right thing to do to help reach people that may not have access to the average program design. Last year, I was part of a project that utilized a voice user interface for users that were deaf or hard of hearing. This simple yet effective design was a huge win for our current customers and in helping drive new business with our groundbreaking software."

In the technology, software and mobile app fields today, accessibility is a huge topic. As a designer with iCIMS, you will be expected to help create products that are as accessible as possible to as many end users as possible. In this two part question, talk about why you feel that universal design is important in the work that you will be doing with iCIMS and then really sell your ability to do this by giving an example of a time you used a universal design in your previous work.

"Early in my career, the best piece of advice that I receive was from an experience designer and she said that when UX doesn't consider all potential users, we are no longer working on the user experience. We live in a very diverse world and the programs that I've designed for in the past have certainly had the goal to reach a wide audience. With your financial products here at iCIMS, this same philosophy applies. Last year, based on some feedback from current customers, we switched our design to include a strong color contract to make the system much more user friendly to color blind users. This was both a simple and very effective change to enhance the look of the program."

As a consultant with iCIMS, 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?

"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."

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 iCIMS, 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.

"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."

Do you have experience working with data in a cloud computing environment?

"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 iCIMS, I think I would bring a wealth of cloud based experience to the data engineering team."

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 iCIMS, 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 iCIMS.

What SDLC models are you familiar in working with?

"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."

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 iCIMS by asking your interviewer which model they work off of.

"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 iCIMS, can you expand on what models you use here in your software development life cycle?"

As you reflect back on your career to this point in your search for a new position, what would you say is your ideal work environment or culture?

"As I begin this job search now 15 years out of college, I'm looking for an employer that promotes and encourages innovation, new ideas and collaboration among all members of the team. From what I know about iCIMS from speaking with others, you sound like a perfect match for what I am looking for in a career."

While using this question as a key indicator on how you'll fit with the team and the organization at iCIMS, it will be very important for you to research as much as you can on the work environment at iCIMS so you can match your priorities to that environment. If you have the opportunity to speak with an employee at iCIMS prior to your interview, that can shed valuable information. In the end, the culture and value of an organization are often a key indicator of long-term success in a job, so make sure that you reflect your values into what the company values.

"With all of the companies that I have both worked for and consulted with in the past, I realize that a company culture is basically the personality of the company and I am looking for a new organization that really meshes well with my personality. I am a casual person that believes in hard work, teamwork and having fun on the job. As I embarked on a job search, I was so happy to see that iCIMS was hiring because I believe our styles will fit perfectly together."

Do you have experience working with different CASE tools? If so, what do you have experience with?

"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."

The world of software engineering has greatly benefited from advancements in computer aided software engineering tools. Because iCIMS 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.

"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 iCIMS."

Our implementation consultants here at iCIMS often face conflicts with our customers while onsite during implementations. What interpersonal skills do you use to handle conflicts with clients?

"Any time that I face a conflict in the workplace, I maintain my own personal composure by not taking things personally and keeping a smile on my face. After setting myself, I look to gain insight into the potential conflict by using my reflective listening skills and then problem solve from there. In this role, I would listen to the needs of the client and be empathetic in my approach with them. My ability to creatively problem solve would take over from there to help find a solution for the client."

In the software implementation process for large customers of iCIMS, you will be working with top level managers and key decision makers onsite and more often than not, issues can arise. In your role as the implementation consultant, these issues come directly to you and your interviewer will be looking to hear how you will handle these issues to maintain both a great relationship with the customer and honor to the iCIMS. In your answer, focus on finding solutions to issues that benefit both parties and talk about the important communication skills that you possess that will make this possible in any situation that you may face.

"The biggest skill that I would bring to the team here at iCIMS as a consultant to clients would be my ability to express mutual respect to all that I work with. As an organization, iCIMS has their own goals that I will be vital in helping to achieve. Your clients also have their own goals that can offer different greatly from yours. A sense of mutual respect allows me to put myself in the shoes of all involved and that really helps me find solutions that work for everyone."

What programming languages would you consider yourself fluent in?

"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 iCIMS."

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 iCIMS as you can prior to your interview and try to speak to the specific languages that they work with.

"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 iCIMS, 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."

What skills do you use to cope with the day to day stress and pressure on the job?

"Where many others get overtaken by stress to the point that they can't function in this field, high pressure situations sharpen my focus and that helps me work through them with ease. Last year, I was assigned a high priority, short notice project for a high profile customer. My manager gave it to me because of my proven success in those situations. From the start, I created a timeline for completion and mapped out a plan to make it happen. While staying in communication with my leaders and the client, I was able to create a great system update in just a few short weeks."

In modern technology industries, consumer demand has led to high volume of work and high pressure situations to work on tight deadlines. To prove that you are able to handle high stress, high pressure situations on the job, your interviewer is looking to hear first hand how you handle this type of environment in your own words. As you answer the question, try to turn potential perceived stress into a positive by highlighting your personal skills that enable you to perform well in those situations. If possible, try to use specific examples in your answer.

"I am confident in high stress work situations because of my ability to adapt, communicate and be organized in my work. These skills came in very useful a few weeks ago when our support staff were experiencing an extremely high volume of help desk calls. My adaptability helped me go with the flow and handle items on at a time. My communication skills enabled me to quickly and efficiently call on needed support. My organization skills helped me be prepared for anything on that day and enabled me to work through tickets in a quick and efficient manner."

What methods do you use to stay up-to-date on the latest trends in tech?

"I have leveraged a number of sources to stay up-to-date on my knowledge, including LinkedIn Learning and industry sites such as TechCrunch. I'm also active on Github where I'm able to work on projects to grow my knowledge. Quora is a place where I lend my knowledge to others and also read about topics I may not be fully versed in, or want to learn more about. Technology has really benefited me in learning more about technology and that excites me about what the future holds for further learning and development."

With technology constantly changing, employers want to know that they are hiring people who are committed to learning and growing. Be sure to explain to your prospective employer how you stay up-to-date and how you're committed to growing your knowledge as your industry grows. They want to know that they're investing in someone who is also investing in themselves.

"I am newer to my financial services career and have worked very hard to develop a strong portfolio this past year. Currently my portfolio is worth $$. What size of portfolio would I be responsible for at iCIMS?"

What do you feel are the primary features and benefits of the Java programming language?

"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."

As a company that utilizes Java, iCIMS 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.

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?

"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."

As your role with iCIMS 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.

"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."

Do you consider yourself stronger in C++, C#, Java, or Python?

"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 iCIMS."

Before your interview, do some research to understand what tech stack iCIMS 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.

"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."

iCIMS embraces an Agile environment. Explain your experience in Agile methodologies and why you think it is important.

"The majority of my experience has been in an Agile environment. For ten years I have been personally responsible for leading agile teams, and I have helped define team goals and milestones. This approach is important to me as I see how Agile methodology helps employees deliver better products in less time. In my current role, team productivity increased by 34% once we introduced an Agile environment, and our on-time project rate skyrocketed another 18%."

The interviewer would like to understand the depth of your knowledge in Agile. The interviewer would also like to know if you work well with team collaboration, are responsive to stakeholder needs, and can work well with team defined milestones. Give a specific example of your experience.

"I especially want to work for iCIMS because I have friends who have worked here before with really positive feedback on their experiences. I am looking for a positive work environment where I can stay for a long time to come."

What do you feel is one of the top issues that is faced by data engineers today?

"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 iCIMS, 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."

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 iCIMS works in, you may likely score some bonus points with your interviewer.

"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 iCIMS and working in the financial industry, how have you seen this need for real-time data impact your products?"

What is one thing that really tests your patience when dealing with your coworkers?

"As a person that values diversity and differences of opinion in the workplace, there aren't many things that grind my personal gears when it comes to my colleagues. The only real true test of my patience is a coworker that doesn't pull their weight in a team effort. When I've been in this situation in the past, I first seek to learn if the issue is a lack of training or knowledge. If it is, I take the necessary steps to help my colleague get on track. But if I find that it is due to a lack of effort, I talk to the person immediately in a professional manner. The sum is only as good as the effort of all of its parts and a team efforts requires everyone's maximum effort."

While on the surface this question may seem like your interviewer is trying to get you to talk negatively about a situation, it is really more of a test to see what can potentially drive you crazy on the job in a team atmosphere and how you handle those situations. In your answer, be honest about your pet peeves when it comes to coworkers and do so in a positive light. Then, expand on your answer by talking about how you handle those situations."As a person that values diversity and differences of opinion in the workplace, there aren't many things that grind my personal gears when it comes to my colleagues. The only real true test of my patience is a coworker that doesn't pull their weight in a team effort. When I've been in this situation in the past, I first seek to learn if the issue is a lack of training or knowledge. If it is, I take the necessary steps to help my colleague get on track. But if I find that it is due to a lack of effort, I talk to the person immediately in a professional manner. The sum is only as good as the effort of all of its parts and a team efforts requires everyone's maximum effort."

"Having been raised in a rural farm setting, I have always been a stickler for being on time and holding meetings to set lengths of time. While watching people show up late for meetings has bothered me internally because of how I am wired, I don't let it bother me on the exterior. We are all very busy in our lines of work and showing up a few minutes late is only normal from time to time."

We are looking for innovators to join us here at iCIMS. Where have you brought innovation in automation to a process in your career?

"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."

Innovation in software has occurred in many phases over the last 20 years and iCIMS 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 iCIMS.

"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."

Talk about your previous user interface design experience in detail. Why do you feel that this experience will translate well to this role with iCIMS?

"Ten years into my career out of college, I consider myself very blessed to have such a well rounded background in user interface design. I have experience designing cutting edge mobile app designs, website design, video game design and software design. Here at iCIMS, your education software would greatly benefit from my creative designs to be user friendly and appealing to educators, parents and students and I'd love to bring these skills to work for you."

While your interviewer can get a good sense of your experience from your resume, they are looking for you to talk in details about your experiences in UI design in your previous work. While explaining your previous experience, be sure to highlight the skills that you developed that will help you be successful in designing new products with iCIMS. Prior to your interview, be sure you research and are family with the products that iCIMS puts out.

"While my experience in user interface design has really focused on web design over the past five years, I think my current skill set will benefit the team here at iCIMS greatly. In my web design, I prepare mockups and wireframes for customers and have experience utilizing a lot of different resources in doing these. In the software world, I would love to use these same principles. As well, my web experience has really driven me to be user focused. In this role, a more user focused drive is required out of your user interface design and I would be able to bring that to the team here."

If hired for this position here at iCIMS, would you be comfortable handling overall project manager responsibilities for new software development?

"Looking to join the team here at iCIMS 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."

As a skilled software engineer, you have all of the necessary tools in your bag to be a successful engineer at iCIMS. 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 iCIMS. 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.

"I would absolutely be comfortable if tasked with project manager duties here at iCIMS. 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."

In your current work, what are the important steps you take in the data validation process?

"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."

Depending on your training and your past roles prior to interviewing at iCIMS, 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.

"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"

Do you have any unique skills or past work experiences that we can't see on your resume that would benefit the team here at iCIMS?

"In my current role as a data engineer, I have gotten the opportunity over the last five years to work with clients in many industries. One of the industries that I've worked most closely with has been the private insurance industry. This experience and my gaining of insider knowledge in the insurance industry would benefit me greatly if brought aboard the team here at iCIMS."

This question is providing you the opportunity to potentially set yourself apart from your competition for this position. To do just that, it will be important for you to make sure that the unique skill or experience that you discuss matches with a critical need for iCIMS and the position that you are interviewing for. Whether you talk about a unique skill or experience, your research on this job will prove vital in your ability to make sure that it impresses your interviewer.

What unique values can you bring to iCIMS in your user experience design skills?

"I have really taken pride in my ability to add value to the business needs of the customers that I work with. During any design project, I take the time to work with end users to find their wants and needs out of the program. Then, as I create the UX design, I keep their needs at the forefront and do anything possible to exceed their expectations."

While your interviewer has shown confidence in your technical abilities to succeed at iCIMS as a UX designer, this question is helping them gain insight into your ability to see the big picture in the work that you do. As you think about the unique personal values that you would bring to the role, try and paint a picture of your work tying to the end user and how you can help make it more productive, enjoyable and satisfying for them.

"As you can see from my resume, I have formal training and experience in user experience research and I know that this would benefit the work that I would be doing here at iCIMS if hired for this position. I pursued this additional training in my career because of my passion for the customer journey in the programs that I design."

How do you ensure that you have a healthy work-life balance in your career?

"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."

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 iCIMS.

"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 iCIMS 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."

iCIMS Interview Questions

Go Back

1. In SQL, how do you explain the differences between clustered and non-clustered indexes? Can you name a time that you used each?
2. If you were asked to review a colleague's code that they had written, what key things would you look for?
3. In your mind, when is monkey testing the most effective in testing new software?
4. If hired here at iCIMS and tasked with helping design a UI for a new mobile app, what important factors would you consider in that design?
5. If you were confronted with a time where you wouldn't be able to meet a deadline here at iCIMS, what steps would you take when you made that realization?
6. Give an example of a time that you used a universal design practice in your work as a UI or UX designer. Why was it important to do this?
7. As a consultant with iCIMS, 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?
8. Do you have experience working with data in a cloud computing environment?
9. What SDLC models are you familiar in working with?
10. As you reflect back on your career to this point in your search for a new position, what would you say is your ideal work environment or culture?
11. Do you have experience working with different CASE tools? If so, what do you have experience with?
12. Our implementation consultants here at iCIMS often face conflicts with our customers while onsite during implementations. What interpersonal skills do you use to handle conflicts with clients?
13. What programming languages would you consider yourself fluent in?
14. What skills do you use to cope with the day to day stress and pressure on the job?
15. What methods do you use to stay up-to-date on the latest trends in tech?
16. What do you feel are the primary features and benefits of the Java programming language?
17. 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?
18. Do you consider yourself stronger in C++, C#, Java, or Python?
19. iCIMS embraces an Agile environment. Explain your experience in Agile methodologies and why you think it is important.
20. What do you feel is one of the top issues that is faced by data engineers today?
21. What is one thing that really tests your patience when dealing with your coworkers?
22. We are looking for innovators to join us here at iCIMS. Where have you brought innovation in automation to a process in your career?
23. Talk about your previous user interface design experience in detail. Why do you feel that this experience will translate well to this role with iCIMS?
24. If hired for this position here at iCIMS, would you be comfortable handling overall project manager responsibilities for new software development?
25. In your current work, what are the important steps you take in the data validation process?
26. Do you have any unique skills or past work experiences that we can't see on your resume that would benefit the team here at iCIMS?
27. What unique values can you bring to iCIMS in your user experience design skills?
28. How do you ensure that you have a healthy work-life balance in your career?

iCIMS Interview Questions

1. In SQL, how do you explain the differences between clustered and non-clustered indexes? Can you name a time that you used each?

2. If you were asked to review a colleague's code that they had written, what key things would you look for?

3. In your mind, when is monkey testing the most effective in testing new software?

4. If hired here at iCIMS and tasked with helping design a UI for a new mobile app, what important factors would you consider in that design?

5. If you were confronted with a time where you wouldn't be able to meet a deadline here at iCIMS, what steps would you take when you made that realization?

6. Give an example of a time that you used a universal design practice in your work as a UI or UX designer. Why was it important to do this?

7. As a consultant with iCIMS, 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?

8. Do you have experience working with data in a cloud computing environment?

9. What SDLC models are you familiar in working with?

10. As you reflect back on your career to this point in your search for a new position, what would you say is your ideal work environment or culture?

11. Do you have experience working with different CASE tools? If so, what do you have experience with?

12. Our implementation consultants here at iCIMS often face conflicts with our customers while onsite during implementations. What interpersonal skills do you use to handle conflicts with clients?

13. What programming languages would you consider yourself fluent in?

14. What skills do you use to cope with the day to day stress and pressure on the job?

15. What methods do you use to stay up-to-date on the latest trends in tech?

16. What do you feel are the primary features and benefits of the Java programming language?

17. 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?

18. Do you consider yourself stronger in C++, C#, Java, or Python?

19. iCIMS embraces an Agile environment. Explain your experience in Agile methodologies and why you think it is important.

20. What do you feel is one of the top issues that is faced by data engineers today?

21. What is one thing that really tests your patience when dealing with your coworkers?

22. We are looking for innovators to join us here at iCIMS. Where have you brought innovation in automation to a process in your career?

23. Talk about your previous user interface design experience in detail. Why do you feel that this experience will translate well to this role with iCIMS?

24. If hired for this position here at iCIMS, would you be comfortable handling overall project manager responsibilities for new software development?

25. In your current work, what are the important steps you take in the data validation process?

26. Do you have any unique skills or past work experiences that we can't see on your resume that would benefit the team here at iCIMS?

27. What unique values can you bring to iCIMS in your user experience design skills?

28. How do you ensure that you have a healthy work-life balance in your career?