Job Description :
Title: Datastage ETL Developer
Location: Atlanta, GA, United States
Length and Terms: Long term - W2 or C2C

Job description
* Government Agency - Candidate must be willing to sign a background check consent form at the time of submission *

Key Responsibilities:
* Analyze reporting requirements to determine development methods, development templates, and to determine job scheduling.
* Work in an Enterprise Data Warehouse (EDW) environment tasked to build a data warehouse using complex transformations that come from many of systems.
* Develop ETL jobs primarily in IBM Data Stage, that satisfy identified business process and data models.
* Troubleshoot and help improve existing ETL jobs.
* Follow set standards and best practices in ETL development. Refactor existing jobs that do not follow set standards.
* Provide guidance in some Data Stage administration tasks such as scheduling jobs, troubleshooting job errors, identifying issues in unusually long running jobs, etc.
* Work with other development units in improving best practices in ETL development
* Monitor nightly loads and troubleshoot any issues that may arise.
* Maintain technical support documentation.
* Other related duties as assigned.

Education, Specialized Knowledge And Experience:
Degrees required for this job: Bachelor’s degree in related field, or equivalent combination of experience and education.

Years of experience required for this job:
6- 8 years of job related experience. At least 6 years in ETL development on any tool and at least 4 years in IBM Data Stage ETL tool. These may overlap for a total of 6 years work experience.

Specialized Skills:
Specialized skills required for this job:
Technical Skills Required:
* Full life-cycle experience on large/complex enterprise software development projects.
* Hands on experience in IBM DataStage ETL Design, Development & Build.
* Experience in project life cycle activities on DW/BI (Data warehouse and Business Intelligence) development and maintenance projects.
* Experience in developing best practices, unit testing and developer code reviews.
* Understanding of Unix/Linux system, files systems, shell scripting.
* Understanding of databases/ data marts/data warehouses and complex SQL and Oracle PL/SQL. Experience with databases including Oracle (11gR2), Microsoft SQL Server, MySQL.

Other Skills Required:
Strong written and verbal communication skills including the ability to express ideas concisely and clearly to both technical and non-technical audiences.
Good problem solving and analytical skills used to resolve technical problems. Must possess a good understanding of business requirements and IT strategies. Ability to work independently, but is also a team player. Ability to lead a team of ETL developers.

Specialized skills preferred:
Experience in a Higher Education environment.
Experience with PeopleSoft HCM and/or PeopleSoft Financials
Experience with Banner.