Short Description:
The Government of the District of Columbia, Office of the Chief Technology Officer (OCTO) is seeking a contractor to provide PeopleSoft Data Warehouse (DWH), ETL Developer services for the District of Columbia Government’s PeopleSoft HCM.
Complete Description:
The PeopleSoft DWH ETL Developer will perform the following functions:
- Install and implement PeopleSoft HCM Data Warehouse.
- Develop the HCM DWH technical roadmap.
- Working with project stakeholders, develop the database/environment scope definition document
- Develop the HCM DWH technical/database requirements document
- Design and develop activities including creation of data dictionaries, data and performance models.
- Building new database infrastructure and environments for the PeopleSoft HCM Data Warehouse project.
- Develop ETL (Extract Transform and Load) programs and processes to load the HCM DWH.
- Execute the HCM DWH technical deployment management plan and ensure successful deployment of the project.
- Provide periodic and ad-hoc reporting to stakeholders as necessary.
- Develop the project dry-run and cut-over plan.
- Execute deployment tasks.
Skills:
Skill
Required / Desired
Amount
of Experience
Expertise Rating
Knowledge of data warehouse applications
Required
8
Years
3 - Expert
Experience with enterprise architectures, data modeling and ETL architecture
Required
8
Years
3 - Expert
ETL Design and support experience using Oracle ODI or Informatica
Required
4
Years
3 - Expert
Experience with Oracle Database Administration version 11g or higher
Required
6
Years
3 - Expert
Experience with Oracle Clustering, replication and disaster recovery
Required
8
Years
3 - Expert
Experience with Oracle Database build on UNIX/Linux
Required
10
Years
3 - Expert
Experience with advanced SQL and SQL tuning
Required
15
Years
3 - Expert
Regular database performance analysis and tuning
Required
8
Years
3 - Expert
Experience with Linux system administration
Required
5
Years
3 - Expert
PeopleSoft HCM data model experience
Required
15
Years
3 - Expert
PeopleSoft database and PIA administration experience
Required
10
Years
3 - Expert
Overall MIS/IT Work experience
Required
15
Years
3 - Expert
B.S. in related field
Required
Experience with Oracle Grid console management
Required
8
Years
3 - Expert
Experience with Oracle RAC Configuration and management
Required
8
Years
3 - Expert