*Position : Senior Business Intelligence Consultant* *Location : NY*
*Duration : 12 months* *Interview : local candidates only/f2f interview* Job Title: ERP / Vendor Product Development Lead a team of developers implementing a BI Solution. This role entails the following: 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 •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 • Knowledge of Oracle Business Intelligence Applications 7.9.6.3 and 7.9.6.4 a plus The following are not required for this position but would be considered as a valuable asset in a potential candidate. -- Best Regards, Samarth Mishra [email protected] 201 620 9700x125 -- You received this message because you are subscribed to the Google Groups "Vendors" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/vendors. For more options, visit https://groups.google.com/d/optout.
