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.
The resource should have 6-8 years hands on exp. in Informatica/OBIEE. Knowledge of DAC is good.
This position is a confirmed one.
· 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
Qualifications
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
Additional Information** 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:-
- 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.
Skills Required
- 6-8 years hands-on experience with Informatica and OBIEE
- 6+ years Informatica experience in BI Apps environment
- Design/creation/customization of Fact, Dimension, and Aggregate mappings in Informatica
- Familiarity with deployment of Informatica mappings
- 5-6 years OBIEE experience, including defining physical and logical stars
- Creation of dimensional hierarchies, calculation metrics, initialization blocks, and RPD variables
- Experience with time-based functions (MTD, YTD) and level-based measures
- Creation of reports and dashboards and use of presentation variables
- Familiarity with deployment of RPD and web catalog migration
- Familiarity with DAC including creation/modification of subject areas and execution plans
- Ability to translate business requirements into technical designs, perform impact analysis and estimate timelines
What We Do
SonSoft Inc. is a global consulting and IT services firm specializing in software development, software consultancy, and Information Technology Enabled Services (ITES). The company provides a range of expertise including business consulting, systems integration, application development, and product engineering, helping clients re-engineer and re-invent their businesses to compete in a changing marketplace.
