ETL Data Integration Developer II

Job Category : Information Technology

Check you match the skill requirements for this role, as well as associated experience, then apply with your CV below.

Location : Los Angeles, CA, US, 90017

Position Type : Full Time

Requisition ID : 11576

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.

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.

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 data is accurately and efficiently moved and transformed to meet business requirements.

Duties

• Integrate 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.
• Participate in unit testing and document the test results.
• Maintain documentation of ETL processes, data flows, and mappings.
• Provide support for ETL processes in production environments.
• Assist in resolving production issues and performing root cause analysis.
• Perform other duties as assigned.

Education Required

Bachelor's Degree in Computer Science or Related Field. In 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 PowerCenter / 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.

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 RequiredLicenses / Certifications PreferredRequired TrainingPhysical 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 :

J-18808-Ljbffr