Data Warehouse ETL Developer position /Costa Mesa, CA

Please send resume to ning@westcoastllc.com only with contact information and location of candidate.

POSITION: Data Warehouse ETL Developer

LOCATION: Costa Mesa, CA

6month+

 

Local or nearby preferred 

DESCRIPTION:

 

Data Warehouse ETL developer is responsible for ETL development using Informatica in Microsoft SQL Server environment and all aspects of data warehouse reporting.  

 

• 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.

• Develop Informatica ETL for Cognos 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

 

REQUIRED SKILLS:

 

• Senior ETL resource with expertise in Informatica and dimensional modeling.

• Experience with business intelligence or reporting tools (preferably Cognos BI tools: Framework Manager, Power Play, ReportNet, Metric Studio).

• SQL Server – SSIS, SQL queries and stored procedures.

• 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.

 

Regards,

Ning

 

West Coast Consulting, LLC
Work – 949 743 0065 x 202 • Direct -949 800 5351

ning@westcoastllc.com

www.westcoastllc.com