*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:- umat...@tekshapers.com <tar...@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 "OracleD2K" group. To unsubscribe from this group and stop receiving emails from it, send an email to oracled2k+unsubscr...@googlegroups.com. To post to this group, send email to oracled2k@googlegroups.com. Visit this group at https://groups.google.com/group/oracled2k. For more options, visit https://groups.google.com/d/optout.