Bi Engineer Interview Questions
A business intelligence engineer, or BI engineer for short, will probably receive several questions about their ability to use scripting languages, processors and programs used by the prospective employer's company. Though some questions about human relations may come up, the BI Engineer interview may be more involved with your experience level in data analysis.
Top BI Engineer Interview Questions & How To Answer
Here are three top BI engineer interview questions and tips on how to answer them:
Question No. 1: Describe a previous project you are proud to have worked on?
How to answer: Going into the interview, you will want to be prepared to talk about a past project you can describe in depth. Whether it is because of the people you worked with or your contribution to making it successful, showing that you have a passion for your work is key. Make sure you highlight the skills you used for the project.
Question No. 2: Which languages/programs/software are you comfortable using now?
How to answer: BI engineering is all about using tools to analyse data. You may be asked an interview question about the tools you are comfortable using. Make sure you can confidently speak about the languages, programs and software you claim proficiency in.
Question No. 3: How would you...?
How to answer: It is very likely that your interview for a BI engineer position will contain a puzzle or problem that you must solve. Whether it is how to handle a SQL issue or calculating performance in Tableau, you should be ready to answer it. Generally, in-depth knowledge of the tools required by the job posting will help you successfully navigate these questions.
What work have you done? work related and experience related
4 Answers↳
Dod they communicate to yoy about the offer or not then?
↳
No I have followed up many times. They are not answering call... I just asked 5% more than what they were offering... Less
↳
How much increment did they offer?
There is a table named GEO, having state and city as it's attribute! Write a query to select the state having multiple cities in it?
3 Answers↳
Solved it! select state from geo group by state where count(*) > 1;
↳
select state from employee group by state having count(cityname)1
↳
select state from employee group by state having count(cityname)1
What is your profession? Where did you worked? Do you know SQL solution for this ... problem? Are you familiar with databases like ORA, Postgres, etc...?
2 Answers↳
Cite your CV, and show up SQL statements or procedure for the problem.
↳
Can you please tell me what kind of sql statements were they
Puzzle: A coin is in one of the inverted bags. First bag says 'Coin is in third bag', second says: 'There is no coin here' and third says: 'There is no coin here'. Considering one statement is true while two are false, where is the coin?
2 Answers↳
I answered second bag. But, he said it was wrong.
↳
coin is in first bag as: put first statement false i.e. coin is not in third in third bag put third statement true i.e. coin is not in third bag so it's concluded by two statements that coin is not in third bag. now put the second statement true which says coin is not here i.e. coin is not in 2 or 3 bag Less
How to remove duplicate records
2 Answers↳
Use CTE.
↳
or to clarify duplicates into a staging table when you are taking a subset of all the fields and you know what specific fields you are after, INSERT INTO > (>) SELECT > FROM (>) GROUP BY > having count(*)>1 and to add only those that are not duplicates INSERT INTO > (>) SELECT > FROM >) T GROUP BY > having count(*)=1 Less
