OBIEE Architect

Sonsoft Inc; Hanover (MD); On-site; USD 90,000 - 120,000; Full time

Job summary

A growing IT consultancy is looking for a skilled professional in Informatica and OBIEE to design mappings, customize existing artifacts, and gather business requirements. Candidates should have 6-8 years of relevant experience, especially in BI APPS environments. This full-time role is open to U.S. citizens and specific visa holders only, as sponsorship is not available. The role emphasizes technical design and deployment of mappings.

Qualifications

• 6-8 years hands-on experience in Informatica and OBIEE.
• Knowledge of DAC is a plus.

Responsibilities

• Design and create fact, dimension, and aggregate mappings.
• Customize existing mappings and deploy Informatica mappings.
• Gather requirements and perform impact analysis.

Skills

Informatica expertise

OBIEE knowledge

DAC familiarity

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.

Job Description

• 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

Qualifications

• The resource should have 6-8 years hands on exp. in Informatica/OBIEE.
• Knowledge of DAC is good.

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:-

• 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.