ETL Developers

Job Responsibilities

Test migrated ETL jobs, including data validation and data integrity testing

Fix issues found during migration or testing

Create new ETL jobs and update existing ETL jobs

Migrate ETL jobs from DataStage V8.5 server to DataStage V11.7 server

Document processes and details as directed by team lead

Assist with implementation of ETL jobs into the production batch process as needed

Performance tune ETL jobs as needed

Provide knowledge transfer to State staff as needed

Perform other related duties as assigned

Minimum Qualifications

Three (3) years experience in DataStage ETL developer role(s)

Two (2) years experience with Oracle PL/SQL development

Desired Qualifications

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