HowToGetSoftwareJob

HowToGetSoftwareJob
HowToGetSoftwareJob Google Hangout

Wednesday, 25 April 2012

Data Warehouse Architect Job Interview Questions 2

This position is a more senior database developer role and is required to lead projects.  Tell us about the most challenging project you have successfully lead data warehousing implementations? What were some of the challenges?
Have you been responsible for establishing the long-term strategy and technical architecture as well as the short-term scope for a multi-phased data warehouse effort? Please describe?
Database developers often work in development teams.  Give us an example of some challenges you have had working in or being part of a database development team? What were some of the challenges and how did you resolve them?
We are looking for a database developer  with a deep knowledge in data architecture.  What is your knowledge of the various data architectures and methodologies including all of the many nuances like meta data, performance management, data quality, schema development, mart vs. data warehouse issues etc.? Give us some examples of how you have used these in the past?
How do you keep track of the direction of the data warehouse architectural program?  How do you ensure program compliance and flexibility for exceptions and change?
Do you have work experience with the following? please describe?:
-Enterprise Data Warehouse Architecture
-Dimensional Data Modeling
-Data Profiling and Master Data Management
-Informatica – ETL tool
-Oracle, SQL and DB2 are
-ERWin modeling
-Database Hierarchy Management
-Star Schema
-C-MDM

How Did We Create These Questions and How Should You Answer?
The interview questions you see above, are created using the same methods we used as corporate HR professionals. For more information on how we create these questions and how to answer them see the post, “Soft Skills Sells In Interviews”

No comments:

Post a Comment