Search Jobs | Dice.com

Job Details

Skills

IT Management
Business Data
Design Patterns
IDQ
Informatica
Web Services
Workflow
Mapping
Systems Analysis/design
Development Testing
Project Lifecycle Management
Agile
Quality Assurance
Informatica PowerCenter
Software Development
Communication
Regulatory Compliance
Computer Hardware
Management
Computer Science
Management Information Systems
Cloud Computing
Data Warehouse
Dimensional Modeling
Extract
Transform
Load
AS3
Modeling
Enterprise Architecture
Security Management
Data Management
Data Quality
Reference Data
Meta-data Management
SQL
Data Integration
Workday
Network
Server Hardware
Oracle Linux

IT Management
Business Data
Design Patterns
IDQ
Informatica
Web Services
Workflow
Mapping
Systems Analysis/design
Development Testing
Project Lifecycle Management
Agile
Quality Assurance
Informatica PowerCenter
Software Development
Communication
Regulatory Compliance
Computer Hardware
Management
Computer Science
Management Information Systems
Cloud Computing
Data Warehouse
Dimensional Modeling
Extract
Transform
Load
AS3
Modeling
Enterprise Architecture
Security Management
Data Management
Data Quality
Reference Data
Meta-data Management
SQL
Data Integration
Workday
Network
Server Hardware
Oracle Linux

Summary

JOB TITLE: Senior ETL Developer

DEPARTMENT: IT- System

STATUS: EXEMPT

JOB CODE: 10049

PAY SCALE: $125,000.00 - $160,000.00 Annually

LOCATION: Remote in California

GENERAL DESCRIPTION

The Sr. ETL Developer provides technical leadership and hands on expertise with respect to the analysis, design, development and support of Golden 1's Informatica ETL implementation. This is a senior position responsible for assisting the ETL Architect with implementation methodologies including standards, design patterns and best practices for enterprise data warehouse development. The Sr. ETL Developer will assist in leading 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

Helps creates standards, design patterns and best practices for ETL development in an enterprise data warehouse environment.
Installs, configures and administrates Informatica PowerCenter and IDQ. 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.
Maintain a thorough understanding of state and federal laws and regulations related to credit union compliance including bank secrecy and anti-money laundering laws appropriate to the position.

PHYSICAL SKILLS, ABILITIES, AND EXERTION UTILIZED IN THE PERFORMANCE OF THESE 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.
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.

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.
KNOWLEDGE/SKILLS:
- Experience with Cloud implementations is essential.
- Highly experienced working with Kimball based data warehouse implementations.
- Strong understanding of all aspects of dimensional modeling as it pertains to ETL design and development. 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 architecture, 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.
- This is a master developer role.

PHYSICAL REQUIREMENTS

Prolonged sitting throughout the workday with occasional mobility required.
Corrected vision in the normal range required to configure, test, and troubleshoot network server hardware and data.
Hearing within normal range. A device to enhance hearing will be provided if needed.

LICENSES/CERTIFICATIONS

Possession of a valid California Driver's License is required.

REV. 3.22.2023

#LI-Remote

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

Dice Id: RTX1da1fe
Position Id: d0dc318b17e2dded29ea148f222ee41f
Posted 16 hours ago

Junior ETL Developer

Vacaville, California

•

Today

Job Title: Junior ETL Developer Location: Vacaville, CA (5 Days Onsite) Duration: Long-Term Contract Job Description We are looking for a Junior ETL Developer with 12 years of experience in designing, developing, and supporting ETL pipelines and data ingestion processes. Responsibilities Develop and maintain ETL/data ingestion pipelines. Extract, transform, and load data from various sources. Write and optimize SQL queries. Monitor ETL jobs and troubleshoot issues. Validate data quality and ac

Easy Apply

Contract, Third Party

Depends on Experience

Filter Results

Job post features

Posted date

Work settings

Employment type

Distance

Employer type

Work authorization

Sr ETL Developer

Skills

Summary

Dice Job Match Score™

Similar Jobs

Sr ETL Developer

Job Details

Skills

Summary

Dice Job Match Score™

Similar Jobs