ETL Developer
Fully Remote
18 Months+
Overview
Our client has an imminent need for ETL Developers.
Seeking a full-time staff augmentation resource to migrate, test, and implement Data Warehouse ETLs from IBM DataStage V 8.5 on Windows 2008 Server to IBM DataStage V 11.7 on Red Hat Linux 8.
MMB's DataStage ETL tool supports the transfer of data from the PeopleSoft source system (Financial Management Solutions (FMS), Human Capital Management (HCM), Enterprise Learning Management (ELM)) to the EPM Data Warehouse which customer users for the client use for reporting. The current DataStage software operates on Windows 2008 physical machines which are no longer supported; therefore the client has undertaken an upgrade of the DataStage software, which includes moving the servers to supported server operating systems.
The upgrade project is underway and requires the migration of approximately 1,700 server jobs to bring it to completion. With the exception of a relatively small number of jobs that still need to be migrated to the DataStage V11 Test instance, the server jobs have generally already been migrated to the DataStage V11 Test instance, and now need to be tested/fixed and migrated to the DataStage V11 Production instance. The contractor resources under this engagement will perform these migration tasks. The contractor resources will work closely with the client's Data Warehouse Team lead along with other project team members.
The metadata database is Oracle 19C and the Data Warehouse is Oracle 12C. DataStage Version 11.7 on Red Hat is up and running and has already been configured.
During the production batch process, data is moved from the source Oracle databases into a staging layer in the Warehouse database and then moved to a multi-dimensional layer used for reporting using Oracle Business Intelligence Enterprise Edition (OBIEE). The Warehouse nightly batch takes about 10 hours to complete each night. Each upgraded job will need to be performance tuned so that it takes the same or less time to load when compared to DataStage V 8.5.
Work will be performed off-site/remotely.
Qualifications
18 Months+
Overview
Our client has an imminent need for ETL Developers.
Seeking a full-time staff augmentation resource to migrate, test, and implement Data Warehouse ETLs from IBM DataStage V 8.5 on Windows 2008 Server to IBM DataStage V 11.7 on Red Hat Linux 8.
MMB's DataStage ETL tool supports the transfer of data from the PeopleSoft source system (Financial Management Solutions (FMS), Human Capital Management (HCM), Enterprise Learning Management (ELM)) to the EPM Data Warehouse which customer users for the client use for reporting. The current DataStage software operates on Windows 2008 physical machines which are no longer supported; therefore the client has undertaken an upgrade of the DataStage software, which includes moving the servers to supported server operating systems.
The upgrade project is underway and requires the migration of approximately 1,700 server jobs to bring it to completion. With the exception of a relatively small number of jobs that still need to be migrated to the DataStage V11 Test instance, the server jobs have generally already been migrated to the DataStage V11 Test instance, and now need to be tested/fixed and migrated to the DataStage V11 Production instance. The contractor resources under this engagement will perform these migration tasks. The contractor resources will work closely with the client's Data Warehouse Team lead along with other project team members.
The metadata database is Oracle 19C and the Data Warehouse is Oracle 12C. DataStage Version 11.7 on Red Hat is up and running and has already been configured.
During the production batch process, data is moved from the source Oracle databases into a staging layer in the Warehouse database and then moved to a multi-dimensional layer used for reporting using Oracle Business Intelligence Enterprise Edition (OBIEE). The Warehouse nightly batch takes about 10 hours to complete each night. Each upgraded job will need to be performance tuned so that it takes the same or less time to load when compared to DataStage V 8.5.
Work will be performed off-site/remotely.
Qualifications
- Three (3) years' experience in DataStage ETL developer role(s)
- Two (2) years' experience with Oracle PL/SQL development
- Experience with DataStage Server and Parallel jobs, Routines, hash files, and/or sequences
- Experience testing and/or performance tuning ETL jobs
- Experience with batch scheduling tools, e.g., Automic, Control-M, etc.
- Experience with Activity Diagrams and/or Process Modeling
- Experience with DataStage migration projects
- Experience developing Oracle Business Intelligence reports
- Experience with PeopleSoft Human Resources and/or Finance modules/data
-
Seniority level
Mid-Senior level -
Employment type
Full-time -
Job function
Other -
Industries
IT Services and IT Consulting
Referrals increase your chances of interviewing at Niyama Global LLC by 2x
See who you knowGet notified about new ETL Developer jobs in St Louis Park, MN.
Sign in to create job alertSimilar jobs
People also viewed
-
Software Engineer – Full Stack
Software Engineer – Full Stack
-
Software Developer 1
Software Developer 1
-
Software Developer 1
Software Developer 1
-
Software Engineer
Software Engineer
-
Software Engineer
Software Engineer
-
Software Engineer
Software Engineer
-
Full-Stack Web Developer
Full-Stack Web Developer
-
Data Engineer (L5)
Data Engineer (L5)
-
Software Engineer, Product (Early Career)
Software Engineer, Product (Early Career)
-
Software Engineer - L4 - Lifecycle Messaging
Software Engineer - L4 - Lifecycle Messaging
Looking for a job?
Visit the Career Advice Hub to see tips on interviewing and resume writing.
View Career Advice Hub