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