*Dear Candidate,*
*We have an urgent opening for ETL/BI Architect needed for major And I have sent you a job description ,Please go through it and let me know if you are comfortable with it and also send me your consultant's updated* *Title: ETL/BI Architect Location: New York, NY Type: Contract * *Duration: 6+ months * *Mode of Interview: First it would be a phone interview, and if it went well they would be required to attend a face to face. * *Job Description Summary * · *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: · *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 * *Rohit Bhasin |* Module lead Recruiter | Apetan Consulting LLC Tel: 201-620-9700* |121| Fax:2015266869 | *Mail *: 72 van reipen ave pmb#255, Jersey City, NJ 07306| *Corp. Office:* 15 Union Avenue, office # 6, Rutherford, New Jersey 07070| [email protected]| www.apetan.com | *“Forget all the reasons why it won’t work and believe the one reason it will work**"* <http://www.facebook.com/Apetanconsulting> <http://www.linkedin.com/company/apetan-consulting-llc?trk=top_nav_home> <http://twitter.com/ApetanLLC> *Disclaimer:* We respect your Online Privacy. This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. If you are not interested in receiving our e-mails then please reply with a "REMOVE" in the subject line at [email protected] and mention all the e-mail addresses to be removed with any e-mail addresses, which might be diverting the e mails to you. We are sorry for the inconvenience. -- 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/oracled2k. For more options, visit https://groups.google.com/d/optout.
