Need:- SQL BI Developer ( CA , 6+ Months ).

Location: Irvine, CA (FACE TO FACE REQUIRED)
Duration: 6+Months 

They must have experience with eCommerce and Web Analytics

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.
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 target 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 EDW ETL resource with expertise in dimensional modeling concepts and methodologies.

·     Extensive experience with backend SQL Server - SSIS, SQL queries and stored procedures development required. Informatica experience a plus.

·     Experience with business intelligence or reporting tools (preferably

·     Cognos)

·     Experience with database design & modeling. Experience with data modeling tool (ER/Studio) . 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 .

Education: BS degree or higher in MIS or engineering fields.

 

Thanks & Regards,

 

Prateek Bhardwaj
(Technical Resource Specialist)

Ramy Infotech

--consulting redefined

39120 # 157 Argonaut Way, Fremont CA 94538

Phone : 408-317-9256 Ext-328

Fax : 408-273-6834

Email : prateek.bhardwaj@ramyinfotech.com

URL : www.ramyinfotech.com

Yahoo ID:  prateek_ramy

G Talk ID: prateekbhardwaj.ramy

In My Absence, Please Contact Viveka Pandita | Phone: 408-317-9256|Ext: 326|E-mail: - viveka.pandita@ramyinfotech.com 

Disclaimer: The information in this email is confidential and may be legally privileged.  Access to this email by anyone other than the intended addressee is unauthorized.  If you are not the intended recipient of this message, any review, disclosure, copying, distribution, retention, or any action taken or omitted to be taken in reliance on it is prohibited and may be unlawful.  If you are not interested in receiving mails from us then please forward this mail with "remove" in the subject to remove@ramyinfotech.com. Sorry for any inconvenience