Senior Information Technology Architect.

Location: DC and other multiple locations.

Duration: long term

Rate: OPEN

This is NOT a C2C position.

The role of the Senior Information Technology Architect is to support and maintain the EDW throughout the System Development Life Cycle (SDLC) data warehouse lifecycle.

The general description of this role is as follows:

Supplies expertise in modeling and organizing information to facilitate support of projects or information architectures utilizing the most current principles and practices of architecture data management systems.

This position is both a designer and developer position dealing with state-of –the-art technologies, databases, reporting systems, and Extract, Transform and Load (ETL) software.

TO Contractor Minimum Qualifications – Senior Information Technology Architect

The following minimum qualifications are mandatory. The Master Contractor’s Sr. IT Architect must demonstrate expertise in the following:

· Education: BS or MS in computer science or information systems.

· Ten (10) years of data warehousing design and development knowledge

· Six (6) years of Informatica 8.x ETL development and administration

· Four (4) years of working with Oracle 9ig or higher

· Four (4) years of working with Erwin modeling tool

· Four (4) years or higher programming in SQL,PL/SQL, HTML

· Four (4) years of Entity Relationship Diagram and dimensional data modeling

·       Documented experience in:

o       Informatica Data Integration Certification, or documented equivalent

o       ETLs process design, development, and performance tuning

o       Data modeling using ERD and dimensional models for highly conformed data marts, relational operational data stores, and star-schemas. Knowledge of Kimball, Hybrid, and Inmon approaches to data warehouses design

o       Oracle DBA skills with and ability to define indexes, create and edit tables, monitor Oracle performance

o       Informatica 8.x system administrator skills and training

o       Data warehouse design and development

·       General Work Experience: Minimum of ten (10) years experience planning, designing, building, and implementing data warehouses using Informatica creating ETL and data quality programs, and developing data warehouse structures.

·       General Industry Experience: K-12 or Higher Education industry data warehousing experience

·       Communication Skills: Fluent in speaking will be assessed during the interview process. Minimum of five (5) years verifiable experience working with end-users in defining and preparing detail specifications for data warehouses, ETL programs, and quality routines.

 

 

Table 2.3.3-1

Senior IT Architect    
SDLC Phase      Responsibilities       
Requirements

1.4.1.1 Review and document data structures, data sources, ELT processes, quality routines of the EDW  
Requirements

1.4.1.1 Map, gap, and compare the MSDE EDW data structures to national data models to identify areas for modification or improvement   
Requirements

1.4.1.1 Assist in the preparation of the Component Impact Summary for the eleven data domains to modify data structures, data sources, ELT processes, quality routines of the EDW      
Design

1.4.1.2 Participate with the DAADS team to analyze and propose new or changes to  data  structures, ETL programs, transformations, indexes, data staging areas, summary tables, and data quality routine based upon a redesign activities      
Design

1.4.1.2 Assist in the preparation of  the Design Change Component Summary summary for each data domain, for the proposed changes to that domain, for data  structures, ETL programs, transformations, indexes, data staging areas, summary tables, and data quality routine based upon a redesign activities   
Development Planning

1.4.1.3 Assist in the preparation of development and conversion strategies, and documentation, for modifying or creating new data structures, ETL programs, transformations, indexes, data staging areas, summary tables, and data quality routine based upon  redesign activities.  Develop strategies for data acquisitions, archiving, recovery, and implementation of a reporting database on an enterprise level.         
Development

1.4.1.4 Define, prepare, develop, document data  structures, ETL programs, transformations, indexes, data staging areas, summary tables, and data quality routine based upon a redesign activities for each of the data domains as needed for the EDW.         
Conversion

1.4.1.4.3       Define, prepare, develop, and document conversion routines for data  structures, ETL programs, transformations, indexes, data staging areas, summary tables, and data quality routine based upon  redesign activities  
Test Planning

1.4.1.4.4       Create test plan cases and documentation for each data domain, for the proposed changes to that domain, for its data structures, data, ETL programs, and data quality routines.
Testing

1.4.1.4.4       Assist in testing change cases, and preparing test results, for each data domain, for the proposed changes to that domain, for analytics, reports, and data quality routines.  
Implementation

1.4.1.4.5       Assist in preparing conversion schedules, cut-over procedures, and cut-over component checklists       
Implementation

1.4.1.4.5       Assist in conversion and cut-over procedures to implement changes to data structures, data, ETL programs, and data quality routines and document the results.  Assist in the quality assurance activities to verify successful conversion before system goes live.