Send resume to [email protected]
Job Title: ETL / BI Developer Duration: 6 months Location: Irvine, CA Must have atleast 10 + yrs of Experience 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. -- You received this message because you are subscribed to the Google Groups "Exact Match" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/exact-match?hl=en.
