Trustmark

Returning Candidate?

Data Integration Specialist II – Data Warehouse

Data Integration Specialist II – Data Warehouse

Job ID 
2017-10234
Location 
US-MS-Jackson
Posted Date 
11/27/2017
Category 
Information Technology
Type 
Regular Full-Time
Job Grade 
13
FLSA Status 
Exempt
Working Hours 
8:00a.m. - 5:00p.m.
Job Location: Company 
IT Enterprise Info Systems

More information about this job

Overview

The purpose of this position is to design and support the architecture and processes required to build and maintain the use of Trustmark’s Enterprise Data Warehouse. This position will be responsible for implementing the database design and defining processes for loading and extracting data from the Data Warehouse.

Responsibilities

  • Assist with Enterprise Data Warehouse architecture design.    Design and implement ETL processes to facilitate the warehouse data load processes. Design and implement solutions for data extraction processes to support business integration requirements.
  • Communicate with users in relation to data integration projects
  • User problem resolutions
  • Facilitate ETL processes for data elements that have been identified for ingestion into the Data Warehouse
  • Understand and maintain the implemented data warehouse model

Qualifications

  • Knowledge of IBM Data Stage
  • Knowledge of enterprise reporting tools, including Cognos, OBIEE, and Oracle Essbase.
  • Experience with change management tools and application programming tools
  • Understanding of data warehouse platform design and implementation
  • Understanding of ETL techniques for data warehousing
  • Understanding of banking and financial applications
  • Project management, analytical and problem resolution skills.
  • Experience with programming languages and use of databases and data files
  • Experience with and/or good understanding of platform architecture development tools, reporting tools, and ETL techniques
  • Bachelor’s degree in Computer Science or related field
  • Minimum 3 years’ experience working with databases in a production environment
  • Experience working with ETL processes, DataStage preferred
  • Experience with Data Warehouse design preferred