ETL Admin / Business Intelligence Developer #3569 Job in Salt Lake City 84104, Utah US
The ETL Admin is responsible for developing and maintaining the ETL components of the Enterprise Data Warehouse (EDW) utilizing Informatica 8.6. The ETL Developer will work with business users and members of the BI team to facilitate the design and implementation of ETL processes for the EDW and organization as a whole. The ETL developer will be responsible for working with the project team on the standardization of work processes, all of which will require the use of best practices.
Principal Responsibilities
· Design and Develop Solutions based on:
o Oracle Business Intelligence Enterprise Edition (OBIEE 10g and 11g)
o Informatica 8.6
o Oracle Databases
· Provide off-hours support as needed
· Follow existing organizational and team processes while always looking for improvements
· Implement procedures for maintenance, monitoring, backup, and recovery operations for the ETL environment. Includes regular reporting (daily, weekly, and monthly) on health and performance of the ETL environment and jobs
· Apply fixes, patches and Service Packs as required and provided
· Assist in the building up of a corporate data warehouse including architecture and data source definitions
· Work with end users in troubleshooting issues with BI Reports and Dashboards
Knowledge and Experience
· 3+ years of experience managing installations, upgrade, tuning and maintenance of Informatica, Business Objects Data Services or other top tier ETL tool
· Strong technical and problem solving skills
· Strong background in using SQL
· In-depth experience of data analysis, database design, and database programming
· Relational database schema design
· Experience in BI concepts and design is required