What are the responsibilities and job description for the DataStage developer position at Innosoul inc?
Job Description
Job ID: MN-MNSITE-2840
Remote/Local DataStage developer with ETL, Oracle PL/SQL, Parallel jobs/Routines/hash files/sequences, tuning, Automic, Control-M, Modeling/Diagrams, migration, OBI reports, and PeopleSoft HR/Finance experience
Location: Saint Paul, MN (MMB)
Duration: 19 Months
Position: 1
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
Tasks
• 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