Job Description :
Direct End Client: City of New York
Job Title: Senior DataStage ETL Developer
Duration: 36 Months
Start Date: ASAP
Location: New York, NY
Position Type: Contract
Interview Type: In Person or Telephonic or Webcam
Requirement ID: NYC_ETL018_AM
Required Skills:
Minimum of five (5) years of recent experience developing applications using IBM DataStage ETL.
Deep knowledge of DataStage Engine administration.
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.
Preferred Skills:
Experience with IBM Information Analyzer and IBM WebSphere.
Experience extracting business rules from the existing legacy code.
Experience with IBM Rational Asset Analyzer.
Experience with MS Visual Studio and .NET.
Experience developing applications in IBM VSE mainframe environment
Department: New York City Employees’ Retirement System
Description: NYCERS seeks one (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.
Responsibilities:
The ETL Developer shall provide NYCERS’ Data Management with technical expertise for the completion of Data Quality, Profiling, Cleansing and Migration efforts as well as NYCERS’ ongoing process improvement programs. The following deliverables shall apply:
Analyze business requirements and design applications.
Work with data SME’s to modify applications improving the existing business processes.
Actively participate in optimization and performance tuning of existing ETL and SQL processes.
Transform technical specifications into ETL processes to load the data for cleansing prior to the migration.
Provide business units with ad-hoc deep-dive analytical reports in support of business rules parsing effort.
Collaborate with technical leads in identifying and addressing production issues and data quality gaps.
Support processes that proactively detect, correct, and prevent invalid data values.
V Group Inc. is an IT Services company which supplies IT staffing, project management, and delivery services in software, network, help desk and all IT areas. Our primary focus is the public sector including state and federal contracts. We have multiple awards/contracts with the following states: AR, CA, DE, FL, GA, IL, KY, MD, ME, MI, NC, NJ, NY, OH, OR, PA, SC, TX, VA, and WA. If you are considering applying for a position with V Group, or in partnering with us on a position, please feel free to contact me for any questions you may have regarding our services and the advantages we can offer you as a consultant.
Please share my contact information with others working in Information Technology.
Website:
Twitter: VGroupITServices@VGroupITService
Facebook: