Years of experience: 6-10+ years’ experience.Interviews: In-person only.
JOB DESCRIPTION:
Provides high-level architectural expertise to managers and technical staff.
MPD - Position Title: Data Warehouse (DWH) Architect
Designs and builds databases, data warehouses, or networks including data acquisition, conversion, and interfaces. Optimizes organizational goals through enterprise standards. The candidate must have experience using Informatica ETL and SQL Server SSIS tools to build data warehouses. He/she must also have extensive Oracle and SQL database management experience. Candidate will work with MPD, other agency partners and other contractors to supplement the Department's existing Legacy and Operational Data Warehouses.
Requested Skill/Experience
Required Amount of Experience
Expertise Rating
Experience designing and implementing load, performance, and regression testing
Required
5 Years
3 - Expert
Experience designing risk management plans Required 5 Years 3 - Expert
Experience with building and maintaining data warehouses Required 5 Years 3 - Expert
Oracle Database Management Experience Required 5 Years 3 - Expert
SQL Server Database Management Experience Required 8 Years 3 - Expert
SQL Server SSIS Required 8 Years 3 - Expert
Experience with Records Management System data migrations Highly desired 3 Years 2 - Proficient
Informatica ETL Experience Highly desired 5 Years 3 - Expert
---------------------------------------------
CONTRACT TEMPLATE:
Responsibilities:
1. Provides high-level architectural expertise to managers and technical staff.
2. Develops architectural products and deliverables for the enterprise and operational business lines.
3. Develops strategy of system and the design infrastructure necessary to support that strategy.
4. Advises on selection of technological purchases with regards to processing, data storage, data access, and applications development. Sets standards for the client/server relational database structure for the organization (Structured Query Language (SQL), Oracle, Sybase).
5. Advises of feasibility of potential future projects to management.
Minimum Education/Certification Requirements:
Bachelor’s degree in Information Technology or related field or equivalent experience.