Dimensional Modeling, DAC, ETL, OBIEE, Informatica
Software Development Lifecycle processes
Experience in enhancing and developing application(s) deployed to production
environment
Experience working with business users to gather requirements and translate to
technical designs.
Strong knowledge of Oracle database is required.
Experience with Oracle SQL and PL/SQL programming is required
3+years in building metadata, Reports and Dashboards in OBIEE
Excellent interpersonal, verbal and written communication skills
Client focused approach to work
A flexible attitude with respect to work assignments
Ability to prioritize workload with attention to detail
Willingness to work in a matrix environment and to value the importance of
teamwork.
Advanced knowledge of data warehouse development and maintenance lifecycle and
methodology.
Advanced knowledge of all application components (Oracle, Informatica, Data
warehouse Console (DAC), WebLogic, BI Administration, OBI Reports and
Dashboards).
Experience configuring one or more modules within OBIA, preferably, HR
Analytics or other modules.
Expert level experience in repository (.RPD) development (Physical, Logical and
Presentation layer) using OBIEE Admin tool.
Experience in configuring OBIEE 11g / OBIA security (Authentication and
Authorization - Object level and Data level security).
Experience in Informatica 9.x to extract data from transaction system,
transform and load into data warehouse.
Familiarity with customizing the pre-built OBIA applications based on business
requirements.
Nice to have: Knowledge in Oracle E-Business Applications
Essential Function
Design and develop metadata and reports using OBIEE 11g
Implement data security in reports and dashboards.
Customize OBIEE application to accommodate reporting needs by business units.
Coordinates with the Quality Assurance team to perform testing of reports.
Follow change control process to migrate code to controlled environment.
Participate in daily Scrum meetings for assigned projects.
Provide status updates to business units and senior management on assigned
tasks.
Perform and document unit testing of all reports and code which are managed in
a source code controlled environment.
Develop complex applications design and code according to business requirements
by following an Agile Methodology and the CLIENT Software Development
Lifecycle.
Document the design and code leading to production of very high quality
deliverables (code and documentation), ready for functional testing by Software
Quality
Assurance, and later Process Validation by representatives of the business.
Working with the Enterprise Architecture and Enterprise Data Warehouse teams to
create detai led system designs and technical specifications.