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.
Skills Required
- 6-8 years hands-on experience with Informatica and OBIEE
- Strong hands-on Informatica experience, preferably in BI Apps environment
- Design and creation of Fact table mappings (ETL)
- Design and creation of Dimension table mappings
- Design and creation of Aggregate table mappings and customization of existing mappings
- Familiarity with deployment of Informatica mappings
- 5-6 years experience with OBIEE; define physical and logical stars and dimensional hierarchies
- Creation of calculation metrics, initialization blocks, RPD variables, and level-based measures
- Experience with time-based functions (MTD, YTD) and presentation variables for reports/dashboards
- Familiarity with deployment/migration of RPD and web catalog
- Familiarity with DAC: create/modify subject areas and execution plans
- Translate business requirements into technical design, 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.
