ETL Data Integration Developer III

$105,267 - $173,689/Yr

L.A. Care Health Plan - Los Angeles, CA

Full-time - Mid Level

Los Angeles, CA

Administration of Human Resource Programs

About the position

The ETL Data Integration Developer III is responsible for the operational support of the Informatica environment, focusing on automation, job scheduling, monitoring, and maintenance of ETL processes. This role involves developing complex ETL processes to support the Enterprise Data Warehouse and Business Intelligence projects, while also providing mentorship and support to the Data Warehouse team.

Responsibilities

• Responsible for the operational support of the Informatica environment, including automation, job scheduling, and monitoring.
• Administers systems performance, including optimization and tuning of the Informatica environment.
• Develops new, complex ETL processes to support the Enterprise Data Warehouse and Data Marts.
• Assists the Data Warehouse team in completing current initiative projects.
• Analyzes and evaluates data sources for ETL mapping.
• Designs and implements complex ETL processes.
• Acts as a Subject Matter Expert and mentors junior staff.
• Provides training and recommends process improvements.

Requirements

• Bachelor's Degree in Statistics or a related field (Master's preferred).
• 5 years of experience in Informatica ETL Developer role in Data Warehouse projects.
• 3 years of proven development experience in ETL/Data Integration and Informatica Power Center Suite.
• Experience with Erwin data modeling toolset.
• Experience working in a PL-SQL environment.
• Expert in database concepts and logical/physical design.
• Strong experience with Informatica in an Oracle Data Warehouse/BI environment.
• Experience in documenting requirements and negotiating commitments.

Nice-to-haves

• Master's Degree in Statistics.
• Experience in the healthcare domain.

Benefits

• Dental insurance
• Health insurance
• Paid time off
• Retirement plan
• Tuition reimbursement
• Vision insurance
• Volunteer time off