IBM Datastage Developer with Netezza and AWS
Ohio State University
Contract Columbus, Ohio, United States Posted 4 years ago
About Position
IBM Datastage Developer with Netezza and AWS (Contract)
$70.00 / Hourly
Columbus, Ohio, United States
IBM Datastage Developer with Netezza and AWS
Contract Columbus, Ohio, United States Posted 4 years ago
Description
Our client is currently working on building a new data analytics platform utilizing the Amazon Web Services platform. As with any project, the effort will involve multiple phases. An initial phase of the project will require the migration of backend data storage from an onpremise database to a cloud database. For this phase of the project, our client needs to incrementally expand their DataStage resources in order to repoint the current data flows to the new database. The IBM DataStage consultant(s) will focus primarily on reviewing & understanding the current DataStage code that loads the current onpremise data warehouse environment and working to update that code to load the same datasets to the new database environment within AWS. The consultant will be responsible for modifying, testing, and validating DataStage jobs to accommodate for changes in database technologies, including potential differences in data types, database organization, load sequence, and performance. May also involve recoding SQL within jobs that were optimized for the onpremise database. The consultant will be responsible for executing and documenting the system tests to validate the conversion effort. Responsibilities also include managing to an assigned queue of work within JIRA and creating documentation highlighting the updates to the DataStage jobs that were put in place as a part of the conversion.
Required 7+ years of IBM DataStage Development experience (designing, coding, testing, optimizing)
3+ years of IBM DataStage administration and performance tuning
7+ years of knowledge of & experience with databases, systems, and SQL concepts
3+ years of experience with Netezza
Must possess excellent interpersonal and relationship building skills
Must possess excellent communication skills and have deep experience working with many varied user groups simultaneously Experience working with AWS database services (Redshift, RDS)
Desired
Experience working in a Higher Education environment
Experience in a previous system migration project
By applying to a job using PingJob.com you are agreeing to comply with and be subject to the PingJob.com Terms and Conditions for use of our website. To use our website, you must agree with the Terms and Conditions and both meet and comply with their provisions.