Job Description :
We have urgent requirement of 16-00479 - OBIEE-Informatica Developer @ Philadelphia, PA 12+ Months contract

Job # : 16-00479
Job Title : OBIEE-Informatica Developer
Job Location : , Philadelphia, PA
Travel Required : No
Overtime Required : No
Position Type : Contract
Remote: No

Job Description :

All these skills need to be clearly stated on resume to be submitted.

Strong experience in developing OBIEE/Siebel Analytics Repository rpd) at three layers (Physical Layer, Business Model & Presentation Layer), Time Series Objects, Interactive Dashboards with drill-down capabilities using global & local Filters, OBIEE/Siebel Security Setup (users/groups, access / query privileges), configured OBIEE/Analytics Metadata objects (Subject Area, Table, Column), Presentation Services/Web Catalog Objects (Dashboard, Pages, Folders, Reports), scheduling iBots.
Expertise in Oracle BI Server, Oracle BI Answers, BI Interactive Dashboards and Oracle BI Publisher.
Expertise in developing all 3 layers of the Analytics Repository (Physical Layer, Business Model & Presentation Layer
Experience in OBIEE/BI Apps (OBIA) with Sales Analytics, Financial Analytics, Supply Chain Analytics, Procure and Spend Analytics and HR Analytics.
Experience with Data Warehouse (Star Schema, Snow Flake and Extended Star Schema, ETL, DW, DM
Sound knowledge of database architecture for OLTP and OLAP applications, Data Analysis , ETL processes.
Extensively used Informatica Power Center 8.1/7.1.2/6.2/5.1 for creating various mappings.
Expertise in Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse and creating Workflows with Worklets & various Tasks and scheduling them using both Workflow Manager and Unix Shell scripts.
Experience in Installing, Configuring and setting up OBIEE/OBIA Environment with Different ETL Tools Like Informatica and ODI 11g.
The incumbent will be the Extract-Transform-Load (ETL) master architect of scalable, well performing, cohesive, and integrated ETL processes for the data warehouse, intermediate data stores, and data marts for source data acquisition, data hygiene, staging, transformations, loading, error handling, updating, change control, integration, and data transmission to partner organizations.
End to End System Data Warehouse and ETL Architecture - Expert in data warehousing methodologies and best practices required.
Development of End to End ETL architecture using Informatica, Oracle, OBIEE
Ability to design data solution components, including data analysis and design, stream ingestion, data transforms and integration, data quality checks, adhere/enforce Enterprise Data Warehouse Release management process, configuration management, automated testing, maintenance, troubleshooting and analytic support.
Design, plan, and develop solutions to perform automated extract, transform and load data between data sources when working with large data sets.
Understand relational and non-relational database design principles, including normalization, de-normalization, and ability to read and interpret source and target systems.
Provide documentation of requirements in the form of architecture diagrams, data models, source to target mappings, data dictionaries and detailed design documents.
Understanding the Oracle Financial Data Source tables and have experience in the R12 version.
Have a good understanding of setting up Global Currencies in the OBIEE infrastructure and knowledge of setting it up and testing it in the ETL informatica mappings and obiee reports.

Thanks & Regards
Keylent INC.
Phone: 4 0 7 5 4 5 5 1 8 0
E-Mail: andy AT keylent DOT com