Description

Lead the migration and optimization of ETL jobs during a large-scale DataStage software upgrade.

This role is on-site.

Responsibilities

• Migrate approximately 1,700 server jobs from DataStage V8.5 to V11.7.
• Test migrated ETL jobs, ensuring data validation and integrity.
• Fix issues identified during migration or testing phases.
• Performance tune upgraded jobs to meet or exceed previous load time benchmarks.
• Create new ETL jobs and update existing ones as required.

Required Skills

• 3+ years of experience as a DataStage ETL developer.
• 2+ years of experience with Oracle PL/SQL development.
• Experience with DataStage V8.5 and V11.7 environments.
• Experience working with Oracle 19C metadata databases and Oracle 12C Data Warehouses.
• Ability to perform data validation and integrity testing.
• Experience managing data transfers from PeopleSoft source systems (FMS, HCM, ELM).

Preferred Skills

• Experience with DataStage Server and Parallel jobs, Routines, hash files, and sequences.
• Experience with batch scheduling tools such as Automic or Control-M.
• Experience developing Oracle Business Intelligence Enterprise Edition (OBIEE) reports.

Key Skills

Education

Any Graduate