Job Overview:
- 7yr 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.
- 7yr experience architecting, designing, documenting, and implementing data warehousing, enterprise application integration, and master data management.
- 7yr 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
- 7yr experience developing data integrations for heterogeneous systems and business intelligence using SQL (Structured Query Language).
- 6yr experience performing database comparative analysis for designing new transactional databases and data warehouses, as well as improvements in existing transactional databases and data warehouses.
- 5yr experience in analytical reasoning, computation, interpretation, and presentation of data to solve business problems.
- 4yr experience implementing systematic Data Error/Recovery and Cleanup procedures
2yr experience integrating with Kafka.