Overview
Skills
Job Details
Datawarehouse Developer
Duration: 30 months
Location: Albany, NY (2-3 days remote every week)
Client: State of New York
Note: Candidates must share 3 references and a copy of their Visa & Passport for submission
Job Description:
1. | 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. |
2. | 84 months experience architecting, designing, documenting, and implementing data warehousing, COTS and Custom business application integrations, and master data management. |
3. | 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 |
4. | 84 months experience developing data integrations for heterogeneous systems and business intelligence using SQL (Structured Query Language). |
5. | 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. |
6. | 60 months experience in analytical reasoning, computation, interpretation, and presentation of data to solve business problems. |
7. | 48 months experience implementing systematic Data Error/Recovery and Cleanup procedures |
8. | 24 months experience integrating with Kafka. |