Senior Data Warehouse ETL Developer
Partnership HealthPlan of California · Fairfield, California, US
Overview Responsible for the development of all processes necessary to complete all phases of theEnterprise Data Warehouse (EDW).
Job description
Overview Responsible for the development of all processes necessary to complete all phases of theEnterprise Data Warehouse (EDW). This includes source identification, data collection, datatransformation, normalization, rule administration, error detection and correction, dataconsolidation, data storage, data distribution, schema mapping, data enrichment, and datagovernance. Responsibilities: - Essential Duties and 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 thedevelopment 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 allprocedures in the EDW. - Responsible for coordination with other departments regarding consistency and accuracyof data....