Operational Warehouse Operation Manager Interview Preparation Guide

Download PDF

Summary Information is the area in data warehouse where the predefined aggregations are kept.

The dimensions are the entities with respect to which an enterprise keeps the records.

Metadata is simply defined as data about data. In other words, we can say that metadata is the summarized data that leads us to the detailed data.

Data mart contains the subset of organization-wide data. This subset of data is valuable to specific groups of an organization. In other words, we can say that a data mart contains data specific to a particular group.

A data Warehouse can implement star schema, snowflake schema, and fact constellation schema.

There is only one fact table in a star Schema.

The view over an operational data warehouse is known as virtual warehouse.

Some applications include financial services, banking services, customer goods, retail sectors, controlled manufacturing.

Metadata respiratory contains definition of data warehouse, business metadata, operational metadata, data for mapping from operational environment to data warehouse, and the algorithms for stigmatization.

Normalization splits up the data into additional tables.

Subject oriented signifies that the data warehouse stores the information around a particular subject such as product, customer, sales, etc.

Snowflake schema uses the concept of normalization.

Multidimensional OLAP is faster than Relational OLAP.

A data warehouse contains historical information that is made available for analysis of the business whereas an operational database contains current information that is required to run the business.

Mostly Operations head would like to have is a team that is like minded. But you could indicate what kind of people you would like to work with. You could say that you intend to work with result driven people and surround yourself with self-motivated people who work in a team towards a common goal. Most of all you like to be surrounded by positive thinking people. You could cite examples where how one of your best projects went well with the team members details.

Data Marting involves hardware & software cost, network access cost, and time cost.

Only one dimension is selected for the slice operation.

Head of Operations carries out tasks bearing in mind the budget restraints. He/she will be involved in budgeting for all the departments and also review to see how much is utilised and how much is remaining. From that they will decide for making the purchase based on the restraint. Their aim is to know where to cut costs and where it is needed. Future resource planning is also in their job scope. Hence, you will need to revive all the work executed with examples to show case your skill in managing within budget. Sometimes Operations Manager are involved in procuring loans for the company. In case you had been involved make it clear about the type of loan depicting the examples.

Data Mining Query Language (DMQL) is used for Schema Definition.

A load manager extracts data from the source system. Fast load the extracted data into temporary data store. Perform simple transformations into structure similar to the one in the data warehouse.

From this question it is obvious, that it is posed to know whether you are familiar with the technical aspects required for your job. Sometimes you might not have complete knowledge about it as you would have some expert handling it. In such cases you could indicate how you handled them. But you could show your eagerness to harness that field as well. On the other side, if you had opportunity to explore that section do indicate the details.

Yes. I am familiar with bar-coding procedures, protocols and tools. I am also knowledgeable in labeling boxes according to their lot and item numbers.

Operations Managers are always working with teams. Team members are to be motivated and appraised on the situations around them. Here the operations head handles his /her team with ease using their management skill. You could explain the details of team that you had handled wherein how you moved within the team by walking the talk showing them the details. Also you could tell what the most difficult situation was where you had to take the call and smoothen out. Here you display your method of planning, leadership skills, communications skill, ability to address a group, know how to resolve problems. Take care when you answer this particular section of the interview question.

The stages are IT strategy, Education, Business Case Analysis, technical Blueprint, Build the version, History Load, Ad hoc query, Requirement Evolution, Automation, and Extending Scope.

Speak about specific matters that are relevant to the position you are applying for. If you do not have any specific experience, get them as close as you can.

If you are being asked this question from your employer, you can explain about your experience. Tell the employer what responsibilities you were performing in your previous job. You can tell about the programs you have developed and modules you have worked on. You can also tell about your achievements in different programs.