do not disclose behavioral Case study Technical
Business Intelligence Engineer Interview Questions
1,082 business intelligence engineer interview questions shared by candidates
-- Given the movie_cast table, select all the movies where Brad Pitt and Leonardo Di Caprio did NOT act together -- Data tables -- create temp table movie_cast ( movie_title varchar(100), actor_name varchar(100) ); insert into movie_cast (movie_title, actor_name) values ('Once Upon A Time in Hollywood', 'Brad Pitt'), ('Once Upon A Time in Hollywood', 'Leonardo Di Caprio'), ('Fight Club', 'Brad Pitt'), ('Fight Club', 'Elena Bonham Carter'), ('The Wolf of Wall Street', 'Leonardo Di Caprio'), ('The Wolf of Wall Street', 'Jonah Hill'), ('The Wolf of Wall Street', 'Margot Robbie'), ('The Irishman', 'Robert De Niro'), ('The Irishman', 'Joe Pesci'), ('The Irishman', 'Al Pacino');
Tell me about a time when you saw a peer struggling and decided to step in and help. What was the situation? Why did you decide to step in? What actions did you take?
Describe a time when you took an unpopular stance in a meeting with peers and your leader. What was it? Why did you feel strongly about it? What did you do? What was the outcome?
Describe a time when you felt really strongly about something on a project but the team decided to go in a different direction. How hard did you press the issue? How did you approach that project afterward?
What is surrogate key in data visualisation?
Difference between where clause and on during join?
related SQL queries and Python Programming.
Tell me about a time when you had to go down several layers to solve a problem.
About internship that I did , the database used in that project and tables and their relationships in that database and some tables and queries were given and should write sql queries for those questions.
Viewing 511 - 520 interview questions