Report this job

---

What is the problem? *

Incorrect company
Incorrect location
Job is expired
Job may be a scam
Other

Senior Data Warehouse ETL Developer Job LocationsUS-CA-Fairfield Responsible for the development of all processes necessary to complete all phases of the Enterprise Data Warehouse (EDW).

This includes source identification, data collection, data transformation, normalization, rule administration, error detection and correction, data consolidation, data storage, data distribution, schema mapping, data enrichment, and data governance.

Responsibilities:

Lead ETL resource on new ETL development for the Data Warehouse. ? Responsible for the entire flow of the data into the Data Warehouse. Develops and maintains in-depth understanding of SQL Server, Oracle, BusinessObjects, Access databases, and Analysis Services. ? Responsible for developing SSIS packages used in the Extract, Transform, and Load (ETL) processes for EDW. Provides guidance for all Master Data Management (MDM) aspects involved in the development of the EDW. ? Responsible for understanding all development in the area of MDM and ETL. Responsible for the transition of documentation, security, development, and testing of all procedures in the EDW. Responsible for coordination with other departments regarding consistency and accuracy of data. Works with Web Team on development and coordination of ETL and other processes. Uses sound technical judgment and makes appropriate systems decisions in absence of the Associate Director, Data Warehouse and Architecture. Responsible to train new staff on ETL architecture, ETL standards, and ETL documentation. Responsible for the coordination of the production, development, and sandbox environments.

SECONDARY DUTIES AND RESPONSIBILITIES:

Performs other tasks necessary to ensure integrity of eCommerce / AMYSIS databases and the accuracy of reporting data. Leads and participates in special projects as needed and assigned.