Job Description :
o Contracted resource will to assist BCBSMA in developing project specific deliverables from the enterprise data warehouse environment. Depending on the requirements of the individual project, the resource will be required to perform one, some or all of the activities identified below.
o Create/Enhance ETL jobs as needed to load external feeds into warehouse tables/data mart tables.
o Modify existing ETL jobs in Oracle Data Integrator (ODI
o Develop data extracts from the data warehouse environment using ODI.
o Provide technical support to User Acceptance and Integration testing environments by researching suspected anomalies and periodically refreshing the environments.
o Performance tuning ETL process and user queries.
o Develop the production process to automate the ETL and create documentation to transition the process to the Production team.
o Resource may also be utilized as backfill for permanent staff on other data warehouse activities as the need materializes.

Client : Highdata Software