Data Warehouse Analyst Interview Preparation Guide
Download PDF

Data Warehouse Analyst guideline for job interview preparation. Explore list of Data Warehouse Analyst frequently asked questions(FAQs) asked in number of Data Warehouse Analyst interviews. Post your comments as your suggestions, questions and answers on any Data Warehouse Analyst Interview Question or answer. Ask Data Warehouse Analyst Question, your question will be answered by our fellow friends.

21 Data Warehouse Analyst Questions and Answers:

1 :: Explain What is a View as it relates to system modeling?

A view organizes diagrams into logical groups to describe a particular aspect of the system. It is the abstraction of the system organized is such a way as to give a perspective of a related set of concerns.

The purpose of using views as a business analyst is to enable the analyst to comprehend very complex systems, and to organize the problem or solution domain around specific areas of expertise. The audience interested in each view may vary based on their roles and experience. A subject matter expert from the business will ask different questions and have different concerns than a developer or system architect. Views help present the information in an easily digestible manner.

2 :: Explain What is analytical or analytic mean?

If someone is analytical then it means the person is always thinking about things - analyzing, pondering, etc. A person who is analytical will have all of the facts about something before doing it.

Analytical is one of the 4 types of people. The other 3 are Promoters, Supporters and Controllers. Most everyone has a portion of every personality trait, but resembles 1-2 for the majority.

3 :: Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?

You should be able to explain how they can compile facts and figures for preliminary analysis, derive relevant facts and information from the study of this data.

4 :: Explain What is Cost Benefit Analysis (CBA)?

Cost Benefit Analysis is a technique used to determine if the financial benefit s of a project outweigh the associated cost of undertaking the project in the first place. For a short term project where the benefit may be an immediate one-time cash windfall this may be as simple as subtracting the total of all the project cost from the total of all of the project benefits. If the total is positive, then the project may be worth completing.

5 :: What is the 4 + 1 View Model as it relates to system modeling?

he 4 + 1 View Model is a predefined set of views for organizing the design and architecture of a system. It was developed in 1995 by Philippe Kruchten, formerly the Director of Process Development at Rational Software.

The 4 + 1 View Model gets its name from the 4 primary views and 1 supporting view that are used to capture and communicate different aspects of the system.

The 4 primary views are:

► Logical View: this view describes the functionality of the system in terms of its static structure and dynamic behavior.
► Development View: this view describes the system from a programmer?s perspective and is concerned with the organization of physical code, its main modules, and their dependencies.
► Process View: this view focuses on the runtime behavior of the system and the elements of the system that relate to process performance. It includes aspects important to scalability, throughput, and process response times to name a few.
► Physical View: this view shows the system from a system engineer's point-of-view. It is concerned with the deployment of software components across the physical architecture including computers and devices , as well as communication between these components.

The 1 supporting view is:

► Use Case View: this view describes the functionality of the system from the perspective of external actors.

6 :: Explain Have you ever been in a real dilemma at work? What did you do to get out of it?

You should hear answers that show the job seeker has sound analytical skills to solve any problem analyzes problems in great detail to come up with a solution.

7 :: What is your spectra photometer working principles?

explain your spectra photometer working principles

8 :: Explain What is the difference between a Primary and Secondary Actor in Use Case Modeling?

Use Case modeling is used to diagrammatically depict a system and those people or processes that interact with it. This system can be a business system (a process) or an application system (computer or web based). To understand the scope of the system under consideration a system boundary is used. Anything depicted within the system boundary is part of the system under consideration, while anything outside of it is not. Use cases are then used to define a group of user-system interactions that together deliver value to the user of the system. These users are called actors.

9 :: Explain about a task that really tested your analytical abilities?

You should mention a time where he/she had to use reason and logic to resolve a problem. Job seeker may have analyzed all the relevant information and created a good, effective solution.

10 :: Explain Is it the job of a business analyst or systems analyst to draw the class diagram?

It depends, it depends, and it depends!

As for most questions in business analysis, there isn?t only one answer. Whose job is to create a class diagram depends on the purpose of the class diagram.

First of all, the question implies that there is only one class diagram for a given project: ?The Class Diagram?. For the most part, this is not the case. On some projects there may be a multitude of class diagrams while in others there may be none.