Job Title: ETL / Business Intelligence Developer - 10 yrs exp
Start Date: 01/10/2011 # of Openings: 1 Duration: 6 months Location: Irvine, CA Job Description: Data Warehouse ETL / BI developer is responsible for ETL development in Microsoft SQL Server environment, Informatica, and all aspects of data warehouse BI reporting. The prospect is also required to have extensive BI skills using Cognos or MicroStrategy. . Work as part of a team to deliver federated dimensional model for growing online consumer subscription service. . Play key role in adding data to the Data Warehouse through development of source to targets maps and transformation rules. . Participate in requirement definition, solution development and implementation phases of data warehouse and reporting projects. . ETL, FM, cube, and report development. . Create and maintain ETL specifications and process documentation to produce the required data deliverables (data profiling, source to Client maps, ETL flows). . Assist in definition of logical and physical data models B2C ecommerce business. . Configure and tune ETL infrastructure to optimize the data warehousing architecture . Troubleshoot and resolve data, system issues and performance issues. . Champion and manage new initiatives to completion to improve and streamline operations processes and maximize systems efficiency. Skills Required: . Senior ETL resource with expertise in dimensional modeling. . Experience with business intelligence or reporting tools (preferably MicroStrategy or Cognos BI tools: Framework Manager, Power Play, ReportNet, Metric Studio). . SQL Server - SSIS, SQL queries and stored procedures. . Informatica 8.6x . Extensive experience with data warehouse concepts and methodologies. . Experience with database design & modeling. . Must have working experience in ecommerce industry and web analytics . Good written and oral communication skills; excellent technical skills. . Highly motivated self-starter, detail and quality oriented and able to work independently . Experience with data modeling tool (ER/Studio) . Education: BS degree or higher in MIS or engineering fields. Skills Preferred but Not Required: Informatica Min Years of Relevant Experience: 10 yrs Sam SRICOM, INC. | A Certified Minority Business Enterprise Off: 609 606 2436 Fax: 215.638.8767 2075 Byberry Rd, Ste#105A, Bensalem, PA 19020 This email is not intended to be an unsolicited mail or 'SPAM'. If this email has reached you in error or you do not wish to receive similar messages, please reply with 'REMOVE' in the subject line. -- You received this message because you are subscribed to the Google Groups "Business_Intelligence" group. To post to this group, send email to business_intellige...@googlegroups.com. To unsubscribe from this group, send email to business_intelligence+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/business_intelligence?hl=en.
