Overview
Skills
Job Details
-
84 months experience working with Agency/business subject matter experts to understand business needs/requirements, Vendors of Commercial Off the Shelf (COTS) Business products, and technology teams to determine and design data warehouse, application and system requirements.
-
84 months experience architecting, designing, documenting, and implementing data warehousing, COTS and Custom business application integrations, and master data management.
-
84 months experience data modeling and designing normalized Data Warehouse environments for enterprise level applications; and, implementing those designs using Oracle Data Integrator (ODI) and Extract, Transform, Load technologies
-
84 months experience developing data integrations for heterogeneous systems and business intelligence using SQL (Structured Query Language).
-
72 months experience performing database comparative analysis for designing new transactional databases and data warehouses, as well as improvements in existing transactional databases and data warehouses.
-
60 months experience in analytical reasoning, computation, interpretation, and presentation of data to solve business problems.
-
48 months experience implementing systematic Data Error/Recovery and Cleanup procedures
-
24 months experience integrating with Kafka.
_________________________________________________________
Agency: NYS Department of Transportation
Detailed Job Description: Act as Expert Database Architect and L2 Technical Operational Support working for NYS Information Technology Services on behalf of the NYS Department of Transportation to fulfill the duties as described below