Database jobs

Data Warehousing jobs cover the storage of data storage elements of a company and include technologies such as DB2, Oracle and SQL Service amongst others.

Data Warehousing  is an important function within any business and the interviewers will be looking for experience and knowledge to help decide if you are the right candidate for the role.
 
To help you below are some sample questions which may come up during your interview:
 

Can you give 3 to 5 advantages Data Mining can have compared to normal systems?

Could you explain the usage of Degenerated dimension and where is it appropriate to deploy it?

Could you explain how SCD can be useful in real time?

Could you explain why a Data Warehouse can or cannot be used for Transaction Database?

Could you explain the role and liabilities of an ETL developer or head of ETL development?

In AB Initio, could you briefly explain the function XFR?

In AB Initio, how is it possible to calculate the whole memory requirement of a graph?

Could you explain the major advantages of Business Performance Management?

Under Cognos, could you explain what Cubes and Sub Cubes mean?

In regards to ETL, Could you explain the importance on cleaning data before loading it into the warehouse?
 

Search and apply for database jobs now