Job Description :
ETL DATA STAGE DEVELOPER
Albany, NY
24 Months
Job Description:
The agency has a series of funded, modernization initiatives aimed at modernizing the Department of Motor Vehicles systems.
The consultant selected for this position will take on a leadership role of the team on these projects and manage other consulting staff.
Expert level skills are required for the daily task of Data Quality Analysis and design of ETL, Data Integration, and BI/Analytic applications, tools, and techniques for Data Profiling. Creation of database schemas, data transformations, loads, orchestrations, and data pipelines.
Requirements Gathering, Cobol analysis, Specifications Creation, Design Creation, Programming, Testing, Preparation of System Documentation, Use of ETL and Data Quality tools; Collaboration with Database, Infrastructure, Business Solutions and Operations units.
SKILL MATRIX:
1. 48 Data Quality analysis experience (IBM Quality Stage or comparable) #OF MONTHS 15
2. 48 months IBM Data Stage or IBM Data Replicator experience #OF MONTHS 12
3. 48 months Data Profiling experience #OF MONTHS 9
4. 24 months IBM Data Studio experience #OF MONTHS 12
5. 24 months IBM Developer for Z systems experience #OF MONTHS 10
6. 48 months Cobol experience #OF MONTHS 8
7. 24 months SQL coding experience #OF MONTHS 5
8. 24 months Data Modeling experience #OF MONTHS 3
9. 24 months Building large scale data extraction, transformation, and load experience #OF MONTHS 3
10. 24 months Database Administration and data replication experience #OF MONTHS 3