*Please send replies/profiles to mohan.ga...@somasoftsol.com <mohan.ga...@somasoftsol.com>*
*-All our requirements are Direct client Requirements.* *-Please Do submit only qualified profiles.* *-Please share the resumes only after you discuss with your consultant. * Sr. ETL Developer /Lead . Portland, OR 6+ months contract to hire (need GC/Citizens) 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 Minimum 7 years IT professional experience Minimum 3 years of experience developing and implementing enterprise scale ETL architectures, preferably using Informatica within an OBIEE and/or Siebel Analytics environment. Hands-on experience using Data Warehouse Application Console (*DAC*) Minimum 3 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. Informatica Certified Developer or Informatica Certified Administrator Experience with PeopleSoft Financials and Supply Chain a plus. Experience/Exposure to DataStage. Experience with OBIEE 11g a major plus Experience with OBIA (Procurement & Spend, Supply Chain & Order Management, Financials) a strong plus Experience with WebLogic a plus Utility industry experience a plus Experience coordinating with various project and support teams Please let me know if you need any more information. Thanks & Regards, *Mohan Ganti* Mail: mohan.ga...@somasoftsol.com <recruite...@metmox.com> *Disclaimer: We respect your Online Privacy. This is not an unsolicited mail. Under Bill 1618 Title III passed by the 105th U.S. Congress this mail cannot be considered Spam as long as we include Contact Information and a method to be removed from our mailing list. If you are not interested in receiving our emails then please reply with a "REMOVE" in the subject line and mention all the email addresses to be removed with any email addresses.* -- You received this message because you are subscribed to the Google Groups "SAP ABAP" group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-abap+unsubscr...@googlegroups.com. To post to this group, send email to sap-abap@googlegroups.com. Visit this group at http://groups.google.com/group/sap-abap. For more options, visit https://groups.google.com/d/optout.