Data Integration Developer

Review current state activities to include the review of the goals and objectives of the Information Management group within State Fund, the oversight responsibilities, and strategic involvement recommendations. Assist in the creation of an enterprise operational data store and analytical data warehouse. Review of existing reporting and analytics tools for potential reduction in technology footprint. Build Datastage ETL interfaces to aggregate, cleanse and migrate data across enterprise-wide MDM, Big Data, and Data Warehousing systems using staged data processing techniques, patterns and best practices. Implement full lifecycle management to capture and migrate various Datastage ETL metadata including data mapping and other data integration artifacts (such as schedulers, scripts, etc.) across environments including the establishment of standards, guidelines and best practices. Recommend and write advanced SQL and stored procedures (in DB2 and/or Oracle Database Platforms) to include designing solutions for optimal performance and handling other non-functional aspects of availability, reliability and security of Datastage ETL Platform. Recommend normalized and dimensional data models and other data integration techniques such as database replication, change data capture (CDC) etc. and familiarity of SOA and ESB technologies and patterns. Work with various application development teams to provide data integration architecture services and data modeling services. May require temporary travel to client sites and/or relocate throughout the U.S.