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

Dassault Systems Enovia Corp. Interview
Questions

28 Questions and Answers by Ryan Brunner

Published December 11th, 2019 | Ryan has over 10 years of experience interviewing
candidates in the healthcare, public service, and private manufacturing/distribution industries.
Question 1 of 28
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?
View Answers
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 Dassault Systems Enovia..
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
1.
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 Dassault Systems Enovia..

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."
2.
Do you have experience working with data in a cloud computing environment?
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 Dassault Systems Enovia., 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 Dassault Systems Enovia..

Ryan's Answer
"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 Dassault Systems Enovia., I think I would bring a wealth of cloud based experience to the data engineering team."
3.
In Oracle, do you understand what a join is and what the various types of joins are?
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.

Ryan's Answer #1
"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."
Ryan's Answer #2
"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."
4.
In SQL, how do you explain the differences between clustered and non-clustered indexes? Can you name a time that you used each?
Dassault Systems Enovia. 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.

Ryan's Answer #1
"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."
Ryan's Answer #2
"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."
5.
What experience do you have in the different types of software maintenance?
As a reputable company, Dassault Systems Enovia. 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.

Ryan's Answer #1
"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."
Ryan's Answer #2
"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 Dassault Systems Enovia., I also have experience performing perfective, preventative and corrective maintenance on software as well."
View All 28 Dassault Systems Enovia Corp. 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.