Complete Description:
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 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. Candidates are encouraged to review the project Statement of Work for additional details.
Behavior Characteristics:
Works well as a team and independently.
Skills:
Skill
Required / Desired
Amount
of Experience
Expertise Rating
Oracle Database Management Experience
Required
5
Years
3 - Expert
SQL Server Database Management Experience
Required
8
Years
3 - Expert
Informatica ETL Experience
Highly desired
5
Years
3 - Expert
Experience with building and maintaining data warehouses
Required
5
Years
3 - Expert
Experience designing risk management plans
Required
5
Years
3 - Expert
Experience designing and implementing load, performance, and regression testing
Required
5
Years
3 - Expert
Experience with Records Management System data migrations
Highly desired
3
Years
2 - Proficient
SQL Server SSIS
Required
8
Years
3 - Expert
Consultant will have to bring his own laptop. Client or vendor will not provide them