Hi, Hope you are doing good!!!!
Please find the below requirement and let me know if you have any suitable resources.. *Role: ETL Informatica Developer with OBIEE and OBIA Experience* *Location: Portland, OR* *Duration: 6+ months* *Interview process: Phone & Skype with a Government ID* *Visa: Only GC and USC.* Notes from the hiring manager: I am looking for an Informatica / ETL Developer with experience with OBIEE and OBIA. The manager will do a phone interview and Skype interview, but we will need a copy of the Government ID prior to the Skype interview. Someone coming out of the utility industry would be IDEAL. *Job Description:* Summary The Sr. ETL Developer will participate in all phases of project implementation and continued support of Oracle Business Intelligence Enterprise Edition (OBIEE) for the enterprise. Demonstrated core competency using Informatica and DAC with proficiency having used it in an OBIEE / OBIA preferred. This role will interface directly with clients as well as IT staff in order to gather requirements to support the creation and maintenance of OBIEE artifacts. Candidate must have strong report and Informatica mapping development, Informatica workflow run capabilities and experience with OBIEE/Informatica design and implementation. *Responsibilities *: Design and develop complex Informatica ETL processes that integrate large data sets from multiple sources. Monitor, troubleshoot, track and document day-to-day production issues. Load data warehouse objects including dimensions, hierarchies, fact tables and aggregates into data warehouse environment. Create the metadata layers including physical, semantic and presentation layers. Demonstrate in-depth understanding of Data Warehousing (DWH) and ETL concepts, ETL loading strategy, Data archiving, Data reconciliation, ETL Error Handling, Error logging mechanism, standards and best practices. Develop and maintain Informatica PowerCenter solutions Version 9.0 and 9.1. Perform systems and data analysis to implement and optimize Informatica mappings and ETL workflows, data flows, shell scripts and stored procedure. Work with customers and business analysts to understand and develop reporting and BI requirements. Actively participate in design and analysis sessions to ensure sound team decision-making Support system and user acceptance testing activities, including issue resolution. Mentor and train IT staff by sharing best practices and lessons learned from past implementation efforts Very strong SQL and data analysis capabilities. *Qualifications Required* : Minimum 7 years IT professional experience. Minimum 4 years of experience developing, implementing and operationalizing enterprise-scale ETL architectures, using Informatica within an OBIEE / OBIA environment. Minimum 6 years use of SQL and RDBMS systems experience (Oracle and SQL Server), with a focus on development and\or data analysis. Proven ability to gather and translate end user requirements into technical solutions. Advanced knowledge of logical and physical data modeling concepts, with an emphasis in dimensional data modeling designs and techniques Advanced knowledge of the system and data security mechanisms required for external presentation of client-segregated reports and analytics via the Internet Advanced knowledge of DW\BI project lifecycle, tools, technologies and best practices. Proactively monitor and identify and resolve performance bottlenecks before they become client impacting. Excellent interpersonal, verbal and written communication skills. *Qualifications Preferred* : Informatica Certified Developer or Informatica Certified Administrator. Experience with PeopleSoft Financials and Supply Chain a plus. Experience with OBIEE 11g a major plus. Experience with OBIA (Procurement & Spend, Supply Chain & Order Management, Financials, Project Analytics, Enterprise Asset Management Analytics) a major plus. Experience with WebLogic a plus. Utility industry experience a plus. Experience coordinating with various project and support teams *Thanks and regards.* * suresh Kotturu* *O : 281-823-9222 X 528|F : 281-823-9225 | **E :suresh.kott...@3sbc.com <suresh.kott...@3sbc.com>* *Gtalk / Yahoo: sureshkotturu3...@gmail.com <sureshkotturu3...@gamil.com> .* -- 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 oracled2k+unsubscr...@googlegroups.com. To post to this group, send email to oracled2k@googlegroups.com. Visit this group at http://groups.google.com/group/oracled2k. For more options, visit https://groups.google.com/d/optout.
