Apply Now

Avance Consulting
Waldwick, NJ
Post Resume to
View Contact Details &
Apply for Job
Job Description :
Position : ETL Developer
Location : New York City,NY
Duration : 12 Months Contract
Interview-Type : In-Person


Scope Of Services :
(1) Senior DataStage ETL Developer to work with the Information Technology (IT) Division for a period up to 36 months. NYCERS reserves the right to hire the candidate(s) as an employee, at no additional cost, after a period of six (6) months. The Developer will primarily be responsible for creating and maintaining ETL applications using IBM DataStage v11.5.

Job Description :
Minimum of five (5) years of recent experience developing applications using IBM DataStage ETL.
Extensive experience with IBM DataStage Designer and Director.
Experience migrating mainframe VSAM data to relational and/or multidimensional SQL databases.
Experience with Legacy and Unstructured data.
Experience working in multiple development environments/systems: IBM Mainframe, Windows Server, UNIX and SQL Server.
Strong SQL knowledge working with complex queries and stored procedures.
Proficiency in mainframe applications encompassing JCL, COBOL, VSAM and DB2.
Excellent interpersonal, communication, presentation, writing, analytical, problem solving, and information gathering skills along with fundamental technique troubleshooting abilities.
Strong analytical skills demonstrated by the ability to receive and analyze requirements and propose a suitable solution that adheres to the team’s methodology.

Desirable Skill/Expertise :
Experience extracting business rules from the existing legacy code.
Experience with MS Visual Studio and .NET.
Experience developing applications in IBM VSE mainframe environment

Client : State of NYC