Enterprise Data Warehouse - ETL Architect

TITLE: ETL ArchitechtDEPARTMENT: Enterprise Data WarehouseSTATUS: ExemptJOB CODE: 4510GENERAL DESCRIPTION: The ETL Architect provides technical leadership and hands on expertise with respect to the analysis, design, development and support of Golden One''s Informatica ETL implementation. This is a lead position responsible for the ETL architecture and implementation methodologies including standards, design patterns and best practices for enterprise data warehouse development. The ETL Architect will lead and mentor other ETL developers. This includes both leading and participating in ETL development activities to ensure an efficient, high-performance implementation which fully supports the business'' data needs. TASKS, DUTIES, FUNCTIONS: Creates standards, design patterns and best practices for ETL development in an enterprise data warehouse environment. Informatica Web Services Hub experience also desired. Responsible for workflow and mapping analysis, design, development, testing, and configuration. Functions as both an expert and lead technical resource on ETL projects throughout the project lifecycle. Provides support for enterprise data warehouse ETL jobs and processes. Diagnoses and remedies technical problems to ensure platform up-time and application service levels are met. Supports, maintains and monitors the health of the platform and associated processes. Writes high quality processes utilizing structured development techniques to support process components and development. Utilizes agile-based approach to implementing data services and solutions. Recommends improvements to ETL processes to improve on data delivery, data quality and overall processing efficiency. Partners with quality assurance testing teams to identify errors and confirm business specifications have been achieved. Able to organize and lead code releases using native Informatica PowerCenter capabilities. Develops support guides and run books for operational support purposes. Collects information to analyze and evaluate existing or proposed application designs. Maintains system and programming guidelines by adhering to the software development lifecycle; develops and maintains artifacts related to standards and architecture. Assists with the definition and implementation of processes, policies, standards and procedures to assure compliance with corporate and regulatory policies. Effective oral and written communication skills required to train, direct, and evaluate staff, diagnose, correct and resolve system problems. ORGANIZATIONAL CONTACTS & RELATIONSHIPS: INTERNAL: All levels of staff and management EXTERNAL: Vendors QUALIFICATIONS:EDUCATION: Bachelor''s degree in Computer Science, Management Information Systems or comparable discipline or equivalent work experience. EXPERIENCE:Minimum of five years'' experience, designing, developing and supporting enterprise data warehouse ETL implementations.Highly experienced working with Kimball based data warehouse implementations.Must have prior experience designing loads for daily and monthly snapshot facts, accumulating snapshot facts, factless facts, type 1, 2, 3 and other hybrid dimension types as well as 3NF and other modeling techniques.Strong understanding of enterprise architectures, security, management and monitoring.Strong understanding of data management best practices and concepts including data quality, reference data, metadata, and data lineage.Strong SQL skills expected.Data Integration experience necessary.Experience with ERWin, BI visualization tools and enterprise schedulers desired.This is a master developer role.PHYSICAL REQUIREMENTS: Prolonged sitting throughout the workday to accomplish tasks. Availability for emergency and on call duty 24 hours a day, 7 days a week, as needed. Occasional travel may be required. Lift and carry communications equipment and computer hardware weighing up to fifty pounds. Corrected vision in the normal range required to configure, test, and troubleshoot network server hardware and data. Hearing within normal range. Must possess sufficient manual dexterity to skillfully operate applicable computer hardware, a variety of hand tools and standard office equipment. May work additional work hours to accomplish tasks. LICENSES/CERTIFICATIONS: Possession of a valid California Driver''s License is required.

Created: 2021-11-29