Tech Specialist - OBIA - AJG

Looking for a resource with advanced skills in Oracle BI Development and Data Warehousing with necessary development skills in OBIEE, OBIA, ETL (Informatica), designing and building presentation layers, repository creation.The resource will work on Data integration using Informatica PowerCenter and need a solid understanding of Dimensional Modeling. Requirements To design, develop, document, and support ETL integrations within an Oracle Business Intelligence Applications (OBIA) environment, utilizing Informatica and DAC to load data from multiple data sources, including multiple PeopleSoft environments. Strong understanding of data analysis, data and process modeling and relational database concepts. Ability to extend the out-of-the-box data model to accommodate custom data requirements from multiple sourcesTranslate the business requirements and source system understanding into a dimensional data model and physical database design Map the requirements to the source systems and applicable data marts Develop the source to target mapping documents and ETL code to load data from source to target warehouse Create technical documentation for all new or modified objects Unit test data loads and write scripts for data validation Performance tuning of ETL jobs to meet SLA Qualifications 5+ years of experience developing solutions in an OBIA(7.x) environment including Informatica PowerCenter (8.x/9.x), DAC, OBIEE(11g) 5+ years of experience developing ETL solutions using Informatica in a data warehousing and business intelligence environment. 3+ years of experience developing solutions in an OBIA(7.x) environment including Informatica PowerCenter (8.x/9.x), DAC, OBIEE(11g) Knowledge of Financial, Supply Chain and/or HR modules in OBIA Strong knowledge of Dimensional ModelingExcellent Troubleshooting and root cause analysisExcellent communication and ability to document requirements and create functional and technical specificationsBe able to work on multiple projects simultaneously and be able to work under tight deadlines Oracle Data Integrator (ODI) experience is a plus Technical and functional knowledge in PeopleSoft is preferred