Flag job

Report

Data Integration Developer

Min Experience

5 years

Location

boston, ma

JobType

full-time

About the job

Info This job is sourced from a job board

About the role

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.

Skills

sql
db2
oracle
datastage
etl
soa
esb