OBIEE Data Warehouse Developer With ETL || NYC, NY || 6+ Months Contract || Phone + F2F - MUST BE LOCAL

Job Title	OBIEE Data Warehouse Developer With ETL
Project Location	NYC, NY
Duration	6+ Months Contract

Interview Mode: Phone + F2F

Visa: Any

NOTE: MUST BE LOCAL

Job Description:

 

Skills:

• Informatica PowerCenter
• DAC - Oracle DAC
• DWH - Data Warehouse Administration Control
• Oracle BI applications: 7.9.6.3 and 7.9.6.4 experience

 

Responsibilities:

• Work on a team that is implementing a BI Solution.
• Analyze, Design & Develop Informatica ETL workflows and mappings that extend BI Apps 7.9.6.3+
• Analyze, Design & Develop Oracle DAC workflows
• Work with the Data Architect and BI Developers to:
• Design & Develop BI Physical Data Model
• Determine whether calculations and processing should be done in BI application or the ETL process
• Determine requirements for aggregate tables, hierarchies, level based measures, etc.
• Move data into the data warehouse for report unit testing

 

Required Skills:

• Experience with business requirement gathering and analysis
• Experience with Data Warehousing Modeling concepts
• Experience with creating / maintaining Informatica ETL workflows and mappings
• Design and development of ETL programs for creating all data warehouse tables, to support initial load, refresh and on-going update strategies
• Experience with maintaining and troubleshooting Oracle DAC workflows.
• Understanding of Oracle E-Business Suite/Hyperion source system data models
• Work with the project manager, architects, and other team members to define metrics and performance goals for the application
• Participate in transitioning the requirements and use cases to the designers, and ensure a clear and complete understanding of the requirements
• Assist in translating requirements and use cases into test conditions and expected results for product, performance, and user acceptance testing
• Provide guidance on RDBMS system configuration and performance tuning including tuning on detailed, base aggregate and additional aggregate fact and dimension tables
• Suggest index strategies and other adjustments to optimize performance
• Years of Experience with Informatica: 3years

 

Preferred Skills:

• Knowledge of Oracle Business Intelligence Applications 7.9.6.3 and 7.9.6.4 a plus

 

 

Note: We are Working with tier-1 Vendor.

 

Thanks & Regards,

Udbhav Mathur

Talent Acquisition Specialist

Email:- umathur@tekshapers.com

Gtalk: udbhav.intime

Tekshapers Inc. – WMBE Firm

1441 E. Maple Rd, Suite # 301, Troy, MI 48083 

http://www.tekshapers.com

Certification: WMBE Certified | E-Verified Company | ISO 9001:2008

--
You received this message because you are subscribed to the Google Groups "US Jobs: Requirements, Clients and Consultants" group.
To unsubscribe from this group and stop receiving emails from it, send an email to recruiters-r-us+unsubscribe@googlegroups.com.
To post to this group, send email to recruiters-r-us@googlegroups.com.
Visit this group at https://groups.google.com/group/recruiters-r-us.
For more options, visit https://groups.google.com/d/optout.