*Hi * *Please find below details for the position Informatica/ETL Developer send me your updated resume.*
*Position: Informatica/ETL Developer * *Interview: Phone + F2F* *Duration: 12+ Months * *Location: Manhattan, NY* ***USC, GC, EAD preferred* *Assignment Details:* *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 *Skills & Requirements:* · 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: *3 years* · Knowledge of Oracle Business Intelligence Applications 7.9.6.3 and 7.9.6.4 a plus Thanks and have a great day *Ranjeet Kumar* *Technical Recruiter* *Srimatrix Inc.* *Phone No. 469.320.9415* *Email: rku...@srimatrix.com <rku...@srimatrix.com>* -- You received this message because you are subscribed to the Google Groups "Open Source Erp & Crm" group. To unsubscribe from this group and stop receiving emails from it, send an email to open-source-erp-crm+unsubscr...@googlegroups.com. To post to this group, send email to open-source-erp-crm@googlegroups.com. Visit this group at https://groups.google.com/group/open-source-erp-crm. For more options, visit https://groups.google.com/d/optout.