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 Informatica ETL 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.
Behavior Characteristics:
Works well as a team and independently.
Skills:
Skill
Required / Desired
Amount
of Experience
Expertise Rating
Oracle Database Management Experience
Required
8
Years
3 - Expert
SQL Server Database Management Experience
Required
5
Years
3 - Expert
Informatica ETL Experience
Required
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 performance and regression testing
Required
5
Years
3 - Expert
Experience with Records Management System data migrations
Highly desired
3
Years
2 - Proficient