ETL
We analyzed 182 interview reviews for ETL from various job sites, social network groups and forums.
Here are the most frequent job interview questions asked by HR managers during initial phone or onsite interviews. This list does not include technical or factual questions.
10 frequent non-technical questions for ETL:
According to our research, hiring managers looking to fill ETL role ask soft skills interview questions 3.0x more frequently than for other roles.
1. What is the biggest lesson you've learned from a mistake you made? top question
How to answer
It’s important to know how to answer a job interview question about mistakes.
They ask questions like this to learn if you are upfront and honest about mistakes that you made.
They also want to know if you learned from your experience and how you met the challenges to improve your performance.
-
About Yourself
Do your best to tell a positive story about how the mistake was made, how you dealt with it and what learned from it.
We all make mistakes from time-to-time. Answering some of the following questions will help you understand your own view of dealing with mistakes and their consequences.
For instance:
- How do you use a mistake to improve your abilities?
- Are you self-aware enough to acknowledge failure and weakness?
- Do you take smart risks?
- How do you view success, failure, and risk in general?
- Do you take responsibility for past mistakes instead of putting the blame on others?
- If the situation repeats, what would you do differently? What would you do again?
-
About The Company
Before the interview, look over the job listing, research the company.
Try to think of a mistake you have made in the past that is not too closely related to the requirements of the job you are interviewing for. What kind of challenges might you face if you get the job here?
-
About The Fit
It’s your opportunity to emphasize the skills or qualities you gained from your past negative experience that are important for the job you’re interviewing for now. The best way to answer a question like this is to use the Present-Past-Present method.
Start with the Present by ensuring the interviewer that even though you have made mistakes in the past, the lesson that you learned is to always carefully double-check your work and to make sure you plan ahead for any possible contingencies.
Next go back to the Past to relate a STAR story that will tell the interviewer about a time when you made a mistake but were able to make the right adjustment to turn a potential negative into a positive. You might say something like: "I was responsible to provide one of our best customers a time frame for completing an important project. In my eagerness to impress them I miscalculated how long it would take and we missed the deadline. The customer was very disappointed and we nearly lost their business. After my manager explained the problem to me I worked very hard to improve my approach to project management and meeting timelines and nothing like this has happened again."
Finally come back to the Present to tell the interviewer that you have the ability to learn from negative experiences and going forward you will approach all tasks with a mindset that will enable you to adjust quickly.
Pro Tip
Make absolutely sure that the interviewer understands that you learned from the experience.
Never blame others for what you did (however, if you were part of a team failure, you could relate this experience, just be sure to own up to your part in it).
Always be accountable for what you could have done differently in the failure. Demonstrate that you’ve had the maturity to benefit from previous “lessons learned” and you can move on with increased wisdom and competency.
2. Tell me about a time when you had an issue with your previous boss
How to answer
Every relationship, both personal and professional, encounters some sort of issues. This is why disagreements at work, especially with your manager, are likely to happen.
Hiring managers ask this question to get a sense of how you might handle possible disagreements with them once you are hired.
They want someone who can speak the truth to them in a way that builds a strong, positive relationship.
They are curious about the respect you show to a higher authority while having the courage enough to stand up for what you believe in.
Finally, they want to discover whether you are a team player who can get along well with your boss and others in the workplace.
-
About Yourself
Think of an issue you had with your boss, and how you behaved in that situation.
Which of the following elements played a role in that circumstance?
- What’s your ‘conflict style’?
- What’s your ideal way to solve a disagreement?
- Do you get very stressed out and confront it head-on?
- Do you just go along with what the boss wants even if you don’t agree?
- Or do you push forward until change happens?
- Are you able to be positive even about difficult situations?
- How did you personally grow from the experience?
-
About The Company
Research the company and its culture.
- What do they value?
- Is there anything that you can find about how they deal with conflict resolution?
- What problems and obstacles might an employee face in a conflict situation with this company?
-
About The Fit
Whatever you say regarding your old or current boss, keep it factual, relevant and positive.
The best way to respond is to use an example that illustrates a situation where you were able to persuade your boss to try things your way — and ultimately, it worked out well for both of you.
Your story should ideally show how competent you are at your work and how you will be a good fit for the company.
This answer can also display other great skills such as negotiating, selling an idea and inspiring others. Answer this question using the STAR method.
Your answer should reflect your strong communication skills, how you took appropriate action, and end with a good outcome. Try to keep the story to around 60 seconds but no longer than a minute and a half.
Pro Tip
Your response will reveal your interpersonal skills and your ability to create smooth working relationships even in difficult situations, which are important in every job.
Don’t speak badly about your previous supervisor; answer this question with extreme tact and diplomacy.
The key to a successful resolution of any issue is to fully listen and understand the other person’s perspective, then work together to come up with a solution. If you can identify a common goal, the solution is easier to find.
3. Tell me about a time you had to raise an uncomfortable issue with your manager
How to answer
Even though you may have a great relationship with your manager, there may have been times where you did not see eye to eye.
By describing how you managed to deal with an uncomfortable issue in the past, you give the interviewer insight into how you’d handle one in the future.
They are curious about the respect you show to a higher authority while having the courage to stand up for what you believe in.
-
About Yourself
On occasion we have all disagreed with our boss. Whether it had to do with a business decision or a more personal matter you should be able to think back on a conflict or disagreement you had with your manager where you responded well, either by suggesting a compromise or taking a calm, relaxed stance when you could have answered in a heated tone.
Getting along well with your manager shows your desire to work together and highlights your creative problem-solving abilities.
- What was the resolution of an issue?
- Did you and your manager come to an agreement?
-
About The Company
Research the company and its culture.
- What do they value?
- Is there anything that you can find about how they deal with conflict resolution?
- What problems and obstacles might employees face in the position you are applying for?
-
About The Fit
Your story should ideally show how competent you are at your work, which will give the hiring manager confidence in hiring you. This answer can also display other great skills such as negotiating, selling an idea and inspiring others.
Mr. Simon suggests that you use the Present-Past-Present method to showcase these skills.
Start with the Present by explaining how you always try to build trust with your colleagues and managers by looking for the best options in each situation regardless of differing points of view.
Next go back into the Past using the STAR method to describe a situation in which you had a disagreement with your manager about a specific situation and how even though your opinions differed, you listened to each other’s points of view and reached agreement on a solution you both liked.
Finally, come back to the Present to explain how you would bring these skills to your new position and ensure that meaningful dialogue would take place to help get things done.
Pro Tip
Tell the hiring manager that you believe it is better to raise uncomfortable questions and ask them directly. Emphasize that you always initiate communication by setting the tone of the conversation in a format of frankness on both sides.
A sincere and respectful conversation builds trust between people, even when the subject of your discussion may be difficult for each of you.
4. Tell me about yourself
How to answer
Most job candidates expect this to be one of the first interview questions and probably think of it as an “icebreaker” to get the interview started. It is much more than that! It is your opportunity to show the interviewer your relevance for the job. You want the employer to know that you are qualified to do the job, you are interested in doing the job and capable of getting it done.
-
About Yourself
What is your current occupation? Define yourself professionally in one statement.
Pick 3 key skills that make you great at your work (your Key Selling Points). How have you applied these skills?
Try to give some numbers to support your statement.
-
About The Company
Your first step is to Research the company to find out as much as you can about what they do and their approach to their business and their employees.
Based on what you know about the company and the job description, why are you interested in the position you are applying for?
-
About The Fit
Now is the right time to show the fit between your skills and the company's requirements. Your answer works best if you emphasize your relevance. How do you do this? You will have already researched the company, studied the job description to identify their needs and possible pain points and prepared the relevant Star Stories that show how you addressed similar issues in the past. Your next step is to develop your Present-Past-Present approach.
Start with the Present. Focus on the skills and experience from your most recent positions. What has enabled you to get the job done successfully and how this relates to what the employer is looking to accomplish.
Next go back to the Past. Here is where your Star story comes in. Explain how you were able to use your skills and experience to accomplish a task that relates to an area of concern for the employer.
Finally come back to the Present – summarizing the lessons you learned and how they shaped your response and approach today.
Remember, the whole conversation is about the present, not the past. Just one sentence can summarize why your approach works, and its applicability and relevance to this position.
Pro Tip
You can also end with a question like:
“Do you know what the current needs in the company/department are, where my skills and experience can help?”
That can help you learn more about the company and the job, turn the “interrogation” into a conversation and will allow you to relax some tension.
Read our blog post to learn more about how to answer this question.
5. Describe a time when you had to overcome a significant obstacle on a job
How to answer
Why do employers ask this question?
It is designed to help the interviewer understand your problem solving and decision making skills. They want to know that they’re hiring someone who can think on their feet and who is resilient when facing challenges.
Think of this question as a great opportunity to turn what may have been a big challenge into a great accomplishment on your part.
-
About Yourself
The employer is looking for the skills needed to overcome a significant obstacale on the job. This is not the place to discuss the ordinary problems that you might face on a daily basis at work.
Start with recalling a few examples of real obstacles and challenges you faced. For each of them, consider:
- What was the project or task you were trying to accomplish?
- What was the obstacle? This can be a specific problem related to your job or a higher-order issue across the organization.
- What steps did you take to address the issue?
- What decisions did you have to make?
- How did the company benefit from your decisions?
- How would you describe your approach, or what lessons have you learned?
Be careful how you respond to this question. The problem you faced and resolved for the company should not have been of your own making.
See this as your chance to show how you stepped up by turning to your skills and inner strength to find the right solutions.
-
About The Company
When you research the company, try and find out what kind of challenges they are facing. Try to find out what they need in terms of problem resolution.
Search for online reviews, complaints and any other useful resources. What problems and obstacles can the employees face with this position?
Pay particular attention to the requirements listed in the job description. It is quite possible that you have a a STAR story about overccoming an obstacle that relates directly to one of their needs. This would be a great opportunity to answer this question.
-
About The Fit
This is your opportunity to showcase your problem-solving skills, resilience, and strength of character. We recommend that you use the Present-Past-Present method to answer this question. The following is an example of how this method might be applied for the position of Blog Writer. The job description mentions that a successful candidate must have experience working “in a dynamic environment.”
Starting with the Present you might say "I really enjoy working in a fast-paced and dynamic environment" (repeating the words used in the job description is reinforcing to the interviewer).
Next go to a Past situation in which you had to write an article on extremely short notice. Your boss came to you at the last moment because your coworker failed to complete a very important assignment. The pressure was on but you worked extra hours to prepare the article successfully and on time. This story shows your sense of responsibility, ability to achieve results under stress, your willingness to go the extra mile, and your problem-solving skills.
Finally come back to the Present to again reiterate how working under pressure is a skill that you are proud of and you will bring to any assignment for the employer.
Pro Tip
This question is not about your past, it's how you deal with things that will happen in the future, so try to keep your answer short and focused.
After all, the interviewer is really looking for what you took away from the situation and doesn’t need to know the full backstory of what happened.
Use the STAR method to prepare your story and practice it so that you can stay within 1-2 minutes.
Make sure to show that you remained positive when overcoming a hurdle at work. Positive attitudes lead to positive outcomes.
6. What is your greatest weakness?
How to answer
This question ranks as the most challenging for many people. Fortunately, Mr. Simon is here to help!
Interviewers are not out to trick or trap you! They ask this question to gauge your level of self-awareness, your honesty and openness, and your capability for self-improvement.
-
About Yourself
No one is perfect and your interviewer doesn't expect you to be perfect either.
While it is good to be honest and open, it will not help you to put yourself down.
What's important is to find a weakness that you have overcome. How you turned what might be considered a negative into a positive.
-
About The Company
Research the company (website, social media, etc) to learn about the company culture.
What personal and professional qualities do they value?
-
About The Fit
This is the time to clearly state a true weakness that you have overcome.
Be as specific as possible and stay away from vague cliches like “I work too hard.” It would be difficult for anyone to try and explain how they overcame a weakness like that
Mr. Simon emphasizes the Present-Past-Present method of responding to behavioral questions. When you are asked about your greatest weakness, you should be able to successfully use this approach as well. Here is an example of how someone might answer this question.
Present - "I have always had a fear of public speaking, and believe this may have held me back in my career, especially when having to make presentations to management."
Past - "Last year I learned about Toastmasters International and decided to join this group to help me gain confidence in myself and improve my ability to present to others in just about any situation."
Present - "By overcoming this weakness I believe that it has made me a much stronger candidate for this position, someone you can count on to make presentations to management, conduct training and communicate at a high level."
It's important to show how well you've overcome a weakness by motivating yourself and learning a new skill to grow professionally.
Pro Tip
Use this question to sell yourself!
7. Tell me about a time you had a conflict at work. How did you handle it? What have you learned?
How to answer
Wherever you go, you will always have to work with people. This means that there is a greater chance for conflict to happen. This question helps the interviewer determine how well you would fit within the organization.
-
About Yourself
Think of the times you had to deal with conflict.
- What were the different ways you were able to address the situation?
- If you were the cause of the conflict, how did the other person talk you down from the conflict?
- What were the key lessons you learned through your experience?
-
About The Company
Research the company and its culture.
- What do they value?
- Is there anything that you can find about how they deal with conflict resolution?
Reading comments to their social media posts often prove helpful to see how they react to customers' complaints.
-
About The Fit
- What have you found out about the company’s culture and job description?
- Are they looking for someone who can take charge and resolve conflict?
Tell a story of how you addressed conflict and how it turned a negative into a positive. Try to conclude with your lessons learned or methodology for approaching conflicts - this will show the interviewer that you would be able to apply your methodology to future situations.
Use the STAR method to frame your story.
Pro Tip
A key to addressing conflict is listening, communication and emotional intelligence. Highlight these skills.
If you're able to, turn the question around and ask the interviewer if they have experienced the same thing. This will start a conversation, which is the goal of an interview.
8. Tell me about a successful project you were involved in. What was your role? What was the result?
How to answer
At first glance you might think that this question is only asked of project managers. That is clearly not the case. In the modern business environment, work is often organized in the form of projects across multiple disciplines involving many people at many different levels.
Projects allow companies to plan objectives and milestones in order to reach their goals, to monitor progress and performance, to clearly define deliverables and success.
-
About Yourself
Think about a few projects you have been involved in, regardless of your level of participation. These might range from small projects like organizing a party to large-scale multinational projects with participants and teams across the globe, million-dollar budgets and high risk and reward stakes.
Develop one or two project-based STAR stories.
Remember, all project-based STAR stories should start with the following descriptive elements:
- Project name
- Its purpose and goal
- Your role in it
- The duration of the project or its phases (in case only some phases were successful)
- The approximate number of people or stakeholders involved in it.
Once you have establish the base facts, its time to describe the challenges and results:
- What were the top 3 challenges?
- What was the end result?
- How did the company (or other stakeholders) benefit from the results?
- How can you define your contribution in 3-5 key phrases?
If you received any praise for your efforts from your boss, peers or clients, what did they say exactly?
-
About The Company
Based on the research you did on the company, what kinds of projects can you expect here?
- What do you know about the goals they are trying to achieve?
- What do you know about their current challenges?
- Can you imagine what success will look like for the projects in this company?
-
About The Fit
Once you decide which project best fits this question, use the Present-Past-Present approach to answer it.
Start with the Present by explaining your thinking on what you believe makes a project successful. You might say that your approach to all new projects is to set up the right project framework and tools before you begin, to help ensure that you get off to a good start.
Next go back to a Past situation in which you and your team took on a project and used your method of clarification to ensure that everyone knew their assignment and through hard work and focus, brought it to a successful conclusion.
Finally, come back to the Present to show how you will use your approach to help the employer tackle projects going forward.
Practice telling your story, using the STAR method.
Pro Tip
End your answer by asking the interviewer how they define success for the role you are applying for.
This will provide you with an insight into the company's environment and expectations for this role, as well as helping to transform the “interrogation” into a conversation as the interview continues.
9. Describe a time when you resolved a conflict with a colleague in your past role
How to answer
Wherever you go, you will always have to work with people and this means that there is always going to be a chance for conflict. Employers ask this question to gauge how well you handle disagreements and how you resolve contentious issues with your coworkers. Remember, if conflcts are not properly handled they may cause disruption in the running of the department or even the entire organization.
-
About Yourself
Think of the times you had to deal with conflict.
- What were the different ways you were able to address the situation?
- If you were the cause of the conflict, how did you handle it and what role did the other person play in helping to resolve the conflict?
- What were the key lessons you learned through your experience?
-
About The Company
Research the company and its culture.
- What do they value?
- Is there anything that you can find about how they deal with conflict resolution?
- Do sites such as Glassdoor give any indication of the kinds of conflicts that might occur and how they are handled?
Reading comments on the company's social media posts often prove helpful to see how they react to customers' complaints.
-
About The Fit
Consider the Present-Past-Present method to tell a story of how you addressed conflict and how it turned a negative into a positive.
Start with the Present to expain to the hiring manager how you always ask questions and listen carefully to your coworkers perspective to understand both sides of an issue and apply your sense of fairness when it comes to resolving potential conflicts with others.
Then go back to the Past using the STAR method to frame your story. Here is an example of how someone might relate just such a story:
"My coworker, who started with the company about 6 months before me explained the process the department used for tracking certain data metrics. In my "wisdom" I thought I had a better way. Without telling my colleague what I was doing I went ahead and tried my own way. Unfortunately my way did not quite do the job and as a result we had to start again. He was naturally upset but I brought out my best listening skills to understand his perspective and we agreed to start again with the next reports. I learned a lesson and we have worked together very well since that time."
Finally, come back to the Present to explain how you skills at listening to and doing your best to understand the other person's point of view is a valuable asset and makes you a strong candidate for the position.
Pro Tip
A key to addressing conflict is listening, communication and emotional intelligence. Highlight these skills.
If you're able to, turn the question around and ask the interviewer if they have experienced the same thing. This will start a conversation, which is the goal of an interview.
10. Describe a situation where you've had to deliver bad news to a customer, or your boss
How to answer
Things do go wrong from time-to-time and bringing bad news to your boss or to an important customer sometimes goes with the job.
Why do interviewers ask this question? With its help, they have the opportunity to see how you handle stressful situations at work, your level of emotional intelligence, and your problem-solving and quick decision-making skills.
-
About Yourself
Remember a tough situation from your previous jobs.
- What did you feel at that time?
- What steps did you take to minimize the damage?
- How did you deliver bad news without it becoming a shoot-the-messenger scenario?
- What did you learn from that situation?
- How would you handle a similar situation should it happen again in the future?
-
About The Company
Do your research about the company.
What challenges and kinds of situations might you face in your new role?
For example, does the company pride itself on its on-time delivery to its customers?
This would be a good thing to know going into an interview. Read the job description carefully and the list of responsibilities required.
-
About The Fit
Have at least 1-2 stories from your experience ready before the interview.
Describe the situation by using the STAR method.
Ensure the interviewer that you always try to stay calm and keep your emotions under control when a stressful situation occurs. That will demonstrate that you are prepared and professional.
Your attitude and the clarity of your message are two very important components in this conversation. The sooner you report your bad news to the boss or a customer, the more likely it is to fix it or at least minimize the damage.
You always get yourself prepared for all the questions that may arise about the bad news you’re sharing or about potential solutions to the problematic situation.
And surely you, as an ideal candidate, always have in mind possible techniques to correct the situation.
Pro Tip
Bad news takes many forms.
For instance, you have to tell the customer his order will be delayed for at least a month; or you have to let the boss know that the firm may have lost a very important customer due to continued delays in shipping goods to them.
You might be able to say to the interviewer that your previous co-workers often selected you to voice bad news. Not because it was your fault, but because you inspire confidence and security among the staff and clients.
This will be your additional advantage and will benefit you over other candidates for this role.
You don't have to be alone in your job search!
Mr. Simon invites you to join the Friends of Mr. Simon Meetup Group that supports both individuals seeking their next job role and working professionals. Members of our network come together to learn and practice new skills and network with others through our regular interactive events where they establish meaningful connections and have a chance to promote their personal brand and stand out in the marketplace.
Group membership is free of charge, courtesy of Mr. Simon.
Join our Friends of Mr. Simon Meetup Group to become part of our growing and supportive community!
This page has been updated on February 23, 2024.
