Hello,
*Need ETL Lead with Oracle Business E-Suite EBS Hyperion Expert* *New York, NY* Aux Systems searching for an ERP/ Developer with Oracle e-Business Suite EBS, HYPERION for a contract assignment with one of our premier clients in New York, NY. *Responsibilities:* • Lead a team of developers implementing a BI Solution. • Lead a team of developers through design and development of the Informatica ETL workflows and mappings, and analyzing DAC execution plans for performance and optimization for an OBIA upgrade. • Work with the Data Architect and BI Developers to: ◦ Work on a team that is implementing a BI Solution. This role entails the following: ◦ 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 leading a team of developers (1 to 7 resources) through the business requirements and analysis process, as well as the full SDLC implementation. • Ability to manage and mentor junior developers, including delegating work, performing design reviews, and code reviews. • Version controlling code, handling both production branches as well as enhancement branches effectively. • Understanding of Business Analysis for dimensional data model. • 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: 7 to 10 years. Preferred Skills: • Knowledge of Oracle Business Intelligence Applications 7.9.6.3 and 7.9.6.4 a plus. -- SUSAN Aux Systems Inc 5155 Route 9w | Newburgh | NY 12550 Contact no: 408-459-3818; Fax: 781.253.0478, Email: su...@auxsystems.com, I www. auxsystems.com -- You received this message because you are subscribed to the Google Groups "Citrix and Sap problems" group. To unsubscribe from this group and stop receiving emails from it, send an email to citrix-and-sap-problems+unsubscr...@googlegroups.com. To post to this group, send email to citrix-and-sap-problems@googlegroups.com. Visit this group at https://groups.google.com/group/citrix-and-sap-problems. For more options, visit https://groups.google.com/d/optout.