Title: OBIEE/Informatica Developer
Skills: The OBIEE/Informatica Reporting Developer will be responsible for analyzing, designing, building, testing and implementing Analytics reports and dashboards using industry leading packages (i.e. OBIEE)
Description: The OBIEE/Informatica Reporting Developer will be responsible for analyzing, designing, building, testing and implementing Analytics reports and dashboards using industry leading packages (i.e. OBIEE). Candidate will have at least five business intelligence projects implementing analytic reports and dashboards.
This person will have 3 to 5 years experience with OBIEE 7.9.6 (BI Analytics) tool. The experience will include the latest or next-to-latest release of tool with usage through all stages of implementation (design, development, testing and deployment). S/he will have working knowledge of the OBIEE tool and how it interacts with other applications. This person should have expert knowledge in usage of the Administrator tool and in assigning security roles. Additionally, this person MUST have experience with basic data warehousing, DAC, Informatica and business intelligence concepts. This person will have experience on several projects as a developer using specific tools. Also has experience supporting a solution in a production environment.
Duties and Responsibilities:
* Minimum 3 years OBIEE 10.x implementation and support experience and/or previous experience with BI Analytics 7.9.6 as part of a packaged Oracle BI Application configuration
* Minimum 3 years Experience with Oracle OBIEE in an Administrator and Developer role working with OBIEE Answers, Dashboards, Delivers, and BI Publisher
* Expert working knowledge and experience with ETL/Data integration using Informatica and DAC
* Experience with Oracle EBS R12/11.5.10 development and familiar with data structures in most of the ERP modules.
* Experience with Oracle 10g RDBMS
* Expert Oracle SQL, PL/SQL and tuning skills
* Expert data warehouse design & build experience including star schema and data modeling
* Three to five+ years of administration and development competency with Oracle Business
* Intelligence Enterprise Edition (OBIEE) BI analytical applications such as Financial Analysis, Human Resources, Supply Chain, etc.
* Experience with OBIEE modeling layers including presentation, logical, and physical
* Building the Reporting Metadata layer and the Reports
* Expert technical knowledge of OBIEE server architecture.
* Expert knowledge of Security set-up for the entities of the application (on both Repository file and
Web catalog file)
* Web Catalog development and administration.
* Analysis, Design, development and customization of Reports and Dashboards in BI Analytics/OBIEE
* Customize the Vanilla application to suit the look and feel of the business. (includes working with XML, Java Script, and ATR files)
* Installation and configuration of BI Analytics/OBIEE tools and components on UNIX/Windows environment.
* Thorough understanding of system administrator activities like upgrade from Siebel Analytics to OBIEE, Environment and Server details.
Skills and Qualifications:
* Bachelor of Science degree in Computer Science or a related field.
* Knowledge of Oracle Databases 10g/11g
* Strong ability to develop and maintain data mappings in DAC and Informatica.
* Ability to develop reports and dashboards in at least two industry leading OLAP/Analytics (ie: OBIEE) packages
* Proven experience in development of reports and dashboards in at least two industry leading database management systems
* Experience in troubleshooting and debugging
* Expertise in problem solving at the highest level
Additional Qualifications:
* Communication skills that can energize multi-disciplined work teams to respond to business needs.
* Must be able to work independently and as a member of a team.
* Strong organizational and customer service skills.
* Ability to identify solutions, recognizes the impact of alternatives, and determines a solution which results in the optimum outcome for the business unit.
* Must be able to manage resources, timelines, deliverables and expectations for related projects.
* Must be comfortable and good at interacting and communicating with all levels inside and outside of the IT department
* Ability to work well with multiple teams and individuals to complete assigned task.
* Must have strong organization skills and have the ability to manage multiple projects concurrently.
* Must have the ability to articulate ideas, written and verbal, to technical and non- technical internal and external professionals.
* Must be comfortable and good at interacting and communicating with all levels inside and outside of the IT department.
* Must have practical experience with a Software Development Lifecycle methodology.
* Must be familiar with software control and software release management strategies
