OBIEE Architect
SonsoftInc
Posted: July 19, 2016
Interested in this position?
Create a free account to apply with AI-powered matching
Quick Summary
Design and create new dimension table mappings for Informatica BI APPS environment, with expertise in Informatica and ETL development.
Required Skills
Job Description
Sonsoft , Inc. is a USA based corporation duly organized under the laws of the Commonwealth of Georgia. Sonsoft Inc. is growing at a steady pace specializing in the fields of Software Development, Software Consultancy and Information Technology Enabled Services.
• Informatica - Ideally 6+ Years of experience .
• Good hands on Informatica especially in BI APPS environment.
• Understanding of BI APPS standards of ETL development with involvement in design/creation of new Fact table Mappings.
• Design/Creation of new Dimension table Mappings.
• Design/Creation of Aggregate table Mappings.
• Customization of existing Facts ,Dimensions and Aggregate mappings.
• Familiarity with Deployment of Informatica Mappings.
• OBIEE - Ideally 5-6 Years of experience .With Independent involvement in
• Defining of new Physical and Logical Stars
• Creation of Dimensional Hierarchies , Calculation Metrices,Definition of Initialization Blocks, RPD Variables .Experience with Time based functions -MTD ,YTD etc .Understand Level Based measures
• Creation of reports/Dashboards use of presentation variables .
• Familiarity with Deployment of RPD and Web catalog migration
• DAC - Familiarity with tool with involvement in Creation/Modification of Subject Areas ,Execution Plan.
• Requirement Gathering - Should be able to translate Business Requirement into Technical Design .Do an impact Analysis on existing artifacts and estimate impact and time lines
• The resource should have 6-8 years hands on exp. in Informatica/OBIEE.
• Knowledge of DAC is good.
** U.S. citizens and those authorized to work in the U.S. are encouraged to apply. We are unable to sponsor at this time.
Note:-
• This is a Full-time job opportunity for you.
• Only US Citizen, Green Card Holder, GC-EAD, H4-EAD, L2-EAD, TN Visa can apply.
• No OPT-EAD & H1-B for this position.
• Please mention your Visa Status in your email or resume.