472,952 Members | 2,150 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,952 software developers and data experts.

Position open to fill - embarking on Data Warehouse project

Maines Paper & Food Service is a $2 billion/yr food distribution
company with 9 distribution centers in the US. We are currently
interviewing for the position detailed below. Relocation to
Binghamton, NY will be necessary. If interested, please forward a
resume to Bi*********@maines.net

================================================== ========
Job Title: Database Architect
Reports to: VP Decision Support
Department: Information Technology

Minimum Requirements:
a) Bachelor of Computer Science or comparable degree.
b) Expertise with IBM DB2 UDB for either iSeries, Linux or both.
c) Knowledge of data modeling theory and practiced skillset with
Computer Associates AllFusion ERwin Data Modeler.
d) Experience in the design and implementation of a Data

General Job Description:
Key player in a corporate-wide Data Warehouse project to integrate
various systems through solid ETL methods, providing a consistent,
accurate and complete view of essential corporate data. Through the
use of Business Intelligence products, the Data Warehouse will provide
many levels of essential information to all departments within the
organization. With DB2 as the database system of choice, an
experienced DBA works with key members of the company to determine
data gathering needs, develop and evolve the Data Warehouse based on
these needs, be responsible for ensuring the data integrity contained
within the Data Warehouse, and maintains the database(s) to ensure
optimal performance.

Essential Job Functions
1. Reverse-engineer data models of current data sources from the
ERP and other supporting systems using ERWin
2. Work with key members of various departments to determine the
definitions of essential data elements
3. Document the mapping of all data sources to the Data
4. Design Data Warehouse table structures using ERWin.
5. Understands:
a. Data Warehousing techniques as espoused by W.H. Inmon and
Ralph Kimball
b. ETL techniques, including the development of staging areas,
recoveries, data cleansing, fact and dimension tables, slowly
changing dimensions, conformations, and the use of surrogate
vs. natural keys.
c. Advanced SQL
d. The end user is the primary reason for the technology, and
therefore strives for full customer satisfaction.
6. DB2 administration including installation, configuration,
journaling, query optimization, backup and recovery strategies,
and utilization of various support tools such as the Explain
Tool, Visual Explain and DB2 Optimizer.
7. Integrate corporate security policies into any developed Data
Warehouse with the assistance of network administrators

Additional, but not required experience
1. Cognos or IBM Business Intelligence tools.
2. Microsoft Access development
3. IBM Websphere or other J2EE application servers
4. Foodservice distribution or related industry
5. Experience with IDS Power Enterprise or Power Warehouse systems
6. Experience with IBM Universe
7. Java development
8. RPG development

Nov 12 '05 #1
0 1374

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

by: Will | last post by:
On the subject of Data Warehouses, Data Cubes & OLAP…. I would like to speak frankly about Data Warehouses, Data Cubes and OLAP (on-line analytical processing). Has it dawned on anyone else...
by: Will | last post by:
On the subject of Data Warehouses, Data Cubes & OLAP…. I would like to speak frankly about Data Warehouses, Data Cubes and OLAP (on-line analytical processing). Has it dawned on anyone else...
by: Aashish | last post by:
Hi, I am currently working on building a real-time data mart. Am using DTS as the ETL tool and MS SQL 2000 as the database. The current infrastructure includes 2 4 Proc (1GHz) Xeon based servers,...
by: sagars76 | last post by:
I am using the page_load event to load a user control within a place holder control and display it on a page. Then I use response.write statements to loop through the rows of a data table and...
by: phantom | last post by:
Hi all. We have a production data source running postgres for reporting/DSS we are thinking on building a warehouse, wherein data would be transferred from postgres to the warehouse. The...
by: dennist685 | last post by:
Can't open Northwind I remembered doing walkthrough using Northwind. However it wasn't an http project but a file project using the development server. Northwind allowed me to add, edit and...
by: David Harris | last post by:
Ok, so I'm semi-new to .NET, having done everything manually with SQL code back in VB6. So before I program this up completely manually again, I thought I'd ask for better ways to think through...
by: russzee | last post by:
Hello, Can I import an OLTP (Reltional DB) as a Data Source into SQL Server Analysis Services 2005 and then use the Cube Wizard and the new Data Source View feature to create the OLAP model ? ...
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...
by: Aliciasmith | last post by:
In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...
by: tracyyun | last post by:
Hello everyone, I have a question and would like some advice on network connectivity. I have one computer connected to my router via WiFi, but I have two other computers that I want to be able to...
by: giovanniandrean | last post by:
The energy model is structured as follows and uses excel sheets to give input data: 1-Utility.py contains all the functions needed to calculate the variables and other minor things (mentions...
by: NeoPa | last post by:
Hello everyone. I find myself stuck trying to find the VBA way to get Access to create a PDF of the currently-selected (and open) object (Form or Report). I know it can be done by selecting :...
by: NeoPa | last post by:
Introduction For this article I'll be using a very simple database which has Form (clsForm) & Report (clsReport) classes that simply handle making the calling Form invisible until the Form, or all...
by: nia12 | last post by:
Hi there, I am very new to Access so apologies if any of this is obvious/not clear. I am creating a data collection tool for health care employees to complete. It consists of a number of...
by: NeoPa | last post by:
Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.