Job Seekers, Please send resumes to resumes@hireitpeople.com
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 |