Overview
On Site
Depends on Experience
Accepts corp to corp applications
Contract - Independent
Contract - 30 Month(s)
Skills
Business Intelligence
COTS
Data Lake
Data Marts
Data Modeling
Data Warehouse
Database
ERwin
Enterprise Application Integration
Extract
Transform
Load
Information Technology
Master Data Management
Oracle Data Integrator
Presentations
Recovery
SQL
System Requirements
Albany
NY
USA
Job Details
Job Title: Database Architect
Job Id: HBITS-06-14010
Location: Albany NY 12233
Duration: Long-term
Job Description:
- 84 months experience working with Agency/business subject matter experts to understand business needs/requirements, Vendors of Commercial Off the Shelf (COTS) products, and ITS teams to determine and design data warehouse, application and system requirements.
- 84 months experience architecting, designing, documenting, and implementing data warehousing, enterprise application integration, 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 computation and presentation of data to solve business problems.
- 48 months experience implementing systematic Data Error/Recovery and Cleanup procedures.
- 48 months experience working in building DataLake, Data Mart, Data Model using ERWIN or any other tool for Self Service BI Reports.
_________________________________________________________
Agency: Department of Transportation
Detailed Job Description: Expert Data Modeler working for NYS Information Technology Services on behalf of the NYS Department of Transportation to fulfill the duties as described below.
Max: SEVEN 32.800.2838
Kirtan:- SEVEN 32.800.2373
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.