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
- 6+ years hands-on Informatica experience, ideally in BI Apps environment
- 5-6 years OBIEE experience with independent involvement in RPD and semantic layer design
- Design/creation/customization of Fact, Dimension, and Aggregate mappings in Informatica
- Familiarity with deployment of Informatica mappings
- Create physical and logical stars, dimensional hierarchies, calculation metrics, initialization blocks, RPD variables, time-based functions (MTD/YTD), and level-based measures in OBIEE
- Creation of OBIEE reports and dashboards, use of presentation variables, RPD and web catalog migration
- DAC familiarity including creation/modification of Subject Areas and Execution Plans
- Translate business requirements into technical design, perform impact analysis and estimate timelines
- Authorization to work in the U.S. (US Citizen, Green Card Holder, GC-EAD, H4-EAD, L2-EAD, TN visa holders); employer cannot sponsor visas
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.
