Job ID: MD-R00B0600006 (912591203)5P
(Cancelled) Education Informatica Architect with ETL/DWH, Data Modeler, Oracle DBA, Erwin, PL/SQL, ERD, Data Integration/design/tuning, COGNOS, SAS and K-12/higher education experience
Location: Baltimore MD (Maryland State Department of Education (MSDE))
Duration: 60 months (5 years)
Positions: 1 (1/1)
2. skill matrix (must be detailed as the evaluation is based on this document)
3. Working Samples
Senior Information Technology Architect DWH Data Modeler:
a) Five (5) years of data warehousing design and development knowledge
b) Five (5) years of Informatica 9.1 or higher ETL development and administration
c) Five (5) years of working with Oracle 11g or higher
d) Five (5) years of creating and updating data models using Erwin modeling tool
e) Five (5) years or higher of programming in SQL,PL/SQL, and HTML
f) Five (5) years of creating Entity Relationship Diagram (ERD) and dimensional data modeling
g) At least one (1) year of documented experience in each of:
i. Informatica Data Integration
ii. ETLs process design, development, and performance tuning
iii. Data modeling using ERD and dimensional models for highly conformed data marts, relational operational data stores, and star-schemas
iv. Oracle DBA skills with and ability to define indexes, create and edit tables, monitor Oracle performance
v. Informatica 9.1 or higher system administrator skills and training
vi. Data Warehousing design and development
h) Specialized experience: At least 2 years of K-12 or Higher Education industry data warehousing experience
i) Good oral and written communication skills. This will be evaluated during the oral presentations. Candidates will be required to submit samples of past written communications for review. Examples include memos, status updates, etc. Sensitive information can be redacted. Oral communication skills can and will be validated during the oral presentation.
The Education Data Warehouse (EDW) is a distributed, multi-tier data warehouse. The
databases are hosted in a multi-server Dell environment. Education data is loaded to Oracle and SQL Server databases via Informatica. Reporting and data analysis are performed using COGNOS 11 and SAS.
A. Erwin Data Modeler
B. Informatica 9.1
D. PL/SQL E. Toad
F. SQL Developer
2.2.4 Existing Reporting
A. COGNOS 11.3
B. SAS 10
Responsibilities and Tasks
The Information Technology, Architect (Senior) will primarily serve as the MSDE Education Data Warehouse Data Modeler and be responsible for the 24/7 support and maintenance of the EDW in the Operations & Maintenance Phase of the System Development Life Cycle (SDLC).
Critical responsibilities include, but are not limited to:
• Data Modeling
• Knowledge of Federal and State Academic Accountability reporting requirements
• Data Programming
• Database Management
2.10.16 Architect, Information Technology (Senior)
Duties: Provides expertise in the most current principles and practices of architecture data management
systems and experience in large system designs, and with data modeling in the information management
arena. Provides expertise in modeling and organizing information to facilitate support of projects or
information architectures. Provides guidance on how and what to data and process model. Primarily deals
with transition planning from legacy to modern systems by concentrating on information flows, data
exchange, and data translation standardization services.
Education: Bachelor’s Degree from an accredited college or university with a major in Engineering,
Computer Science, Mathematics or a related field. Master’s degree preferred.
General Experience: At least ten (10) years of experience planning, designing, building, and implementing
Specialized Experience: At least five (5) years of the required ten (10) years of experience must be in the
direct supervision and management of major projects that involve providing professional support services
and/or the integration, implementation and transition of large complex system and subsystem architectures.
Must have led or been chief architect in major IT implementation efforts. Must demonstrate a broad
understanding of client IT environmental issues and solutions and be a recognized expert within the IT
industry. Must demonstrate advanced abilities to team and mentor and possess demonstrated excellence in
written and verbal communication skills.