Overview
Skills
Job Details
Title: Database Architect
Location: Albany, NY
Length: 30 Months
LOCALS ONLY
Determines database structural requirements by analyzing client operations, applications, and programming; reviews objectives with clients; evaluates current systems; provides database support by coding utilities, responding to user questions, and resolving
problems.
84+ months: Candidate is able to provide guidance to large teams
and/or has extensive industry experience and is considered at the top of his/her field.
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