ETL Developer/cobal

Location: Albany, NY
Date Posted: 07-26-2018
ETL Developer/cobal
  Albany, NY
 24 Months
Job Description:
NYSED Office of Adult Career and Continuing Education Services - Vocational Rehabilitation (ACCES-VR) is initiating a data analysis and ETL (Extract, Transform, Load) preparation activities as the Case Management System (CaMS) needs to be modernized, and data quality and integrity issues resolved. ACCES-VR legacy solution also involves Unisys Mainframe, PowerBuilder and multiple SQL reports to meet federal compliance, and IT operational support of the application is critical. SED currently lacks staff with the skills to support this legacy system.
The programmer hired will be expected to
1) Analyze the existing legacy applications that support ACCES-VR services and document ‘as is’ system analysis artifacts
2) Document data models and legacy system data flows
3) Provide ETL (Extract, Transform, Load) mapping expertise and lead ETL tasks related to modernization of CaMS system
4) Assist with ACCES-VR federal reporting and data mart activities
5) Contribute to routine production data processes, running of SQL queries, and reporting administration
6) Assist with mainframe payment processing COBOL programs’ support
7) Manage mainframe routine data processes (daily, weekly, quarterly, annual)
8) Assist with the support of a small Java application which works with the rest of legacy ACCES-VR applications
9) Create test plans and contribute to unit, system integration and regression testing
10) Support data migration, data quality assurance testing and debugging activities
11) Lead technical analysis and design discussions and document technical artifacts related to a group of applications (PowerBuilder, Unisys Mainframe, PL SQL, Java, Oracle) that support ACCES-VR

Skill Matrix
1. 84 months of experience leading ETL (Extract, Transform, Load) mapping and data conversion. #of months 15
2. 84 months of experience writing complex SQL statements and executing SQL queries and reports that meet New York State Agencies’ or Federal compliance requirements or United States Governmental business needs.  #of months 15
3. 84 months of experience application coding, unit testing, system integration testing, regression testing, data migration testing, production implementation and operational support. #of months 10
4. 36 months of experience using an industry-leader ETL tool (IBM InfoSphere DataStage or Informatica or equivalent).  #of months 15
5. 84 months of experience in Mainframe COBOL.  #of months 10
6. 12 months working with United States Government or New York State Agencies on complex legacy data conversion projects that involved a large environment of integrated legacy applications written in PowerBuilder or Mainframe COBOL. #of months 5
7. Bachelor’s Degree in Computer Science from an accredited institution. #of months 10
this job portal is powered by CATS