Oracle Obiee Consultant - Informatica

Swift Tecnosol
  • Hyderabad
  • 10-15 lakh
  • 4-9 years
  • 15 Sep 2015

  • IT/ Information Technology

  • IT/ Technology - Software/ Services
Job Description

- He needs have the knowledge in OBIEE

- Should have knowledge on BIAPPS architecture ( Informatica, OBIEE and DAC ).

- Create mappings using different transformations like Source Qualifier, Filter, Aggregator, Lookup, Expression, Sequence Generator and Update Strategy to store the data in target table.

- Create Custom mappings to update Facts and Dimensions.

- Customize OOTB mappings to achieve the business requirements.

- Create Sessions and workflows using the Workflow Manager.

- Perform unit testing for the Developed Mappings.

- Configure Data warehouse Admin Console (DAC) and created Execution Plans for the multiple sources

- Deploy Informatica workflows to the DAC, created dependency and dependent hierarchical tasks and streamlined the Execution Plans with their respective tasks in DAC.

- Work on creating DAC tables, task definitions, Subject areas and indexes for tables and worked on change capture mechanism during incremental load for tables.

- Build the new DAC subject areas & execution plans.

- Monitor the daily Incremental Load in Production environment and fix any issues during the Load.

- Troubleshoot and resolving if any issues raised in Reporting / ETL level.

- Take necessary backups of rpd, webcat folder, Informatica repository and DAC repository.

- Migrate the Informatica Repository, DAC Repository, OBIEE rpd & Webcat from DEV-QA-PROD.

- Handle Production Support tickets.

Note: Looking for immediate or 7-15 days notice period

Competencies/Skill sets for this job

ETL Obiee Oracle.

Job Posted By

About Organisation

Swift Tecnosol