IBM DataStage ETL Developer

About the role

The successful candidate will be responsible for designing, developing, and maintaining ETL processes using IBM DataStage in an Oracle environment. They will also be involved in the design and development of data warehouse solutions, tuning SQL queries, and managing Unix shell scripts.

Responsibilities

• Design and develop ETL processes using IBM DataStage in an Oracle environment.
• Develop and maintain dimensional data models for Cognos data analytics.
• Develop data analysis and metrics queries for operational oversight.
• Tune SQL queries to improve query performance.
• Manage Unix shell scripts for automation tasks.
• Implement and maintain business and technical rules in IBM DataStage environments.
• Automate ETL code migration process and set up standard operating procedures.
• Maintain and troubleshoot production and lower-level environments.
• Perform capacity planning and resolve platform issues.
• Document and assist other developers in code documentation and mentoring.
• Work with PPI and SSA data security requirements, ensuring compliance with state and federal regulations.

Requirements

• 72+ Months ETL development experience in Oracle environment with IBM DataStage.
• 84+ Months ETL design and Data Warehouse development experience using SQL and PL/SQL programming.
• 84+ Months experience tuning SQL within an Oracle environment.
• 60+ Months experience in programming and unit testing.
• 60+ Months experience in program code documentation, mentoring, and assisting other developers.
• 60+ Months experience working with PPI and SSA data security requirements.
• 84+ Months experience developing dimensional data models for Cognos data analytics.
• 84+ Months experience developing data analysis and metrics queries for operational oversight.
• 84+ Months DataStage Administrator experience on AIX environments.
• Experience with PPI and SSA data security requirements (working with data contained in Employee Records in a State Agency, Federal Agency or Private Organization).

Qualifications

• Professional certifications relevant to the field (if applicable).
• Relevant degrees or equivalent experience (if applicable).