IT Senior Technical ETL Warehouse Analyst

US-IL-Northbrook
Job ID
2017-7049
# of Openings
1
Job Category
Information Technology

Overview

UL LLC is seeking results focused BI Business Systems Senior Analyst / Architect who will assist in fulfilling project needs around business intelligence, analytics and reporting for our customers. This individual will be responsible for supporting our environment and participating in projects from a technology perspective to ensure goals and objectives are met while adhering to UL’s formal system development lifecycle. The IT Business Systems Senior Analyst/Architect’s job duties include, but are not limited to:

Responsibilities

  • Assist in working with business and technical teams to gather BI/DW and data integration related requirements from business users to create functional and technical requirements documents..
  • Administer and support the OBIA applications platform including system configuration, enhancements, break-fix, and deployments.
  • Assist with architecture build and solution design for the ETL environment.
  • Assist with development of and enhancements to the ETL processes supporting data integrations for OBIEE from multiple source systems.
  • Development and delivery of extensions to the out-of-the-box ETL to accommodate custom data requirements provided by the business.
  • Communicate with business users and project managers at regular project status meetings.
  • Translate business requirements and source system understanding into technical design.
  • Troubleshooting and debugging of defects and production issues in the areas of Informatica, DAC and OBIEE.
  • Develop and maintain Informatica ETL code.
  • Ensure Project deliverables are delivered on time.
  • Help in executing the Business Intelligence Vision and Strategy.
  • Develop technical documentation.

 

 

#CB

Qualifications

  • Bachelor's Degree or equivalency (CS, CE, CIS, IS, MIS, or engineering discipline)
  • 6+ years job experience within the industry or consulting is preferred
  • 4+ years of experience with Informatica Power Center 9.x or higher
  • 2+ years using Oracle Business Intelligence Analytics Applications. Prefer experience with Finance, Supply Chain/Order Management, Project Analytics, Procure/Spend Analytics
  • Experience in performing conceptual, logical and physical data modeling in a highly complex environment.
  • Experience with Data Warehousing, Data Marts, OLAP/OLTP environments.
  • Knowledge of Data Warehousing and master data Management and Governance practices
  • Knowledge of ETL processes and data management practices
  • Experience with Oracle Database Tools/Technologies (prefer Oracle 11/12)
  • Experienced in writing and understanding complex SQL code.
  • Key skill on UNIX based operating system to administer Informatica, DAC and OBIEE.
  • Experience with full lifecycle of Business Intelligence projects
  • Good written & oral communication and presentation skills in English.
  • Strong decision making and problem solving skills based on strong functional and technical knowledge.
  • Ability to work independently as well as being part of a team.
  • Ability to learn quickly.
  • Experience with Oracle’s OBIEE 10 or later (prefer recent, hands-on 11g or 12c experience): Dashboards, Scorecards, BI Publisher, etc.

    Experience with OBIEE installation, configuration and administration

    Experience developing and maintaining the OBIEE repository.

  • Knowledge of Oracle E-business Suite (EBS).

Options

Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed

Connect With Us!