ETL Data Integration Developer II

Salary Range:  $91,536.00 (Min.) - $121,286.00 (Mid.) - $151,034.00 (Max.)

Established in 1997, L.A. Care Health Plan is an independent public agency created by the state of California to provide health coverage to low-income Los Angeles County residents. We are the nation’s largest publicly operated health plan. Serving more than 2 million members, we make sure our members get the right care at the right place at the right time.

Mission: L.A. Care’s mission is to provide access to quality health care for Los Angeles County's vulnerable and low-income communities and residents and to support the safety net required to achieve that purpose.

Job Summary

The ETL Data Integration Developer II is responsible for assisting in the design, development, and maintenance of ETL (Extract, Transform, Load) processes and data integration solutions using Informatica PowerCenter/IICS (Informatica Intelligent Cloud Services)/IDMC(Intelligent Data Management Cloud).  This position involves working closely with senior developers, technical analysts, and business stakeholders to ensure that the data accurately and efficiently moved and transformed to meet business requirements.

Duties

Works in integrating data from various source systems into the data warehouse by developing and maintaining workflows, mappings, and sessions using Informatica PowerCenter/IICS (Informatica Intelligent Cloud Services)/IDMC(Intelligent Data Management Cloud)  under the guidance of senior ETL Developers/Lead.

Participates in unit testing and documenting the test results of the codes written at until level.

Maintains documentation of ETL processes, data flows, and mappings.

Provides support for ETL processes in production environments.

Assists in resolving production issues and performing root cause analysis.

Perform other duties as assigned.

Duties Continued

Education Required

Bachelor's Degree in Computer Science or Related FieldIn lieu of degree, equivalent education and/or experience may be considered.

Education Preferred

Master's Degree in Computer Science or Related Field

Experience

Required:

4 years of experience in ETL development using Informatica PowerCenter/IICS (Informatica Intelligent Cloud Services)/IDMC(Intelligent Data Management Cloud)

2 years of experience in Developing and maintaining workflows, mappings, and sessions.

2 years of experience in writing SQL queries.

1 year of experience with JIRA tool

Skills

Required:

Basic knowledge of Informatica Power center/IICS (Informatica Intelligent Cloud Services)/IDMC (Intelligent Data Management Cloud).

Understanding of ETL (Extract, Transform, Load) concepts and methodologies.

Familiarity with SQL (Structured Query Language) and relational databases.

Basic understanding of data integration and data quality principles.

Strong analytical and problem-solving skills.

Good communication and interpersonal skills.

Ability to work collaboratively in a team environment.

Detail-oriented with a focus on quality and accuracy.

Healthcare domain.

Preferred:

Knowledge of AGILE development model.

Knowledge of cloud based data integration platforms such as AWS, Snowflake.

Knowledge of Data Warehouse and Data Modeling Concepts.

Licenses/Certifications Required

Licenses/Certifications Preferred

Required Training

Physical Requirements

Light

Additional Information

Salary Range Disclaimer: The expected pay range is based on many factors such as geography, experience, education, and the market.  The range is subject to change.

L.A. Care offers a wide range of benefits including

• Paid Time Off (PTO)
• Tuition Reimbursement
• Retirement Plans
• Medical, Dental and Vision
• Wellness Program
• Volunteer Time Off (VTO)