Job Overview

The IT Data Integration (ETL/Data Warehouse) is a centralized area which collects, massages, and summarizes information from diverse business data sources and prepares it for easy analysis and interpretation. PowerCenter is the main tool we use to support the entire data integration lifecycle, from jumpstarting the first project to ensuring successful mission-critical enterprise deployments.

The ETL System Administrator is responsible for administering software, and monitoring and maintaining performance of overall system environments.

Essential Responsibilities:

• Administer software
• Monitor performance of overall system on all environments (prod, stage, dev, test)
• Carry out deployment, migrations, installations, upgrades, hot fixes, etc.
• Develop disaster recovery and failover strategies for the data integration environment
• Monitor & troubleshoot job failures of nightly loads and throughout the day
• Review and optimize performance bottlenecks
• Monitor disk space and load balance
• Maintain and implement Data Quality applications, and DW/ETL standards & conventions
• Metadata Manager, make sure all mappings are included and data dictionary is populated
• Deal with support to resolve issues

Additional Responsibilities:

• General knowledge and background of information technology including Microsoft Windows, and Solaris
• Proficient in UNIX OS and scripting
• Understanding of basic data analysis and management concepts
• Willingness to support after hours as business needs dictate
• Strong communication and documentation skills

Preferred Education, Experience and Licenses:

• Administrator Certification desired but not required
• Strong knowledge of Data Warehousing (data integration & data modeling) and ETL concepts, standards and best practices
• Experience in developing complex queries and statements
• Experience in IT or in role that requires regular use of Information Technology and Data Management
• Experience with BI tools, data mining, data visualization, or machine learning is a plus