L.A. Care Health Plan
ETL Data Integration Developer II
L.A. Care Health Plan, Los Angeles, California, United States, 90079
Job Category: Information TechnologyLocation: Los Angeles, CA, US, 90017Position Type: Full TimeRequisition ID: 11576Salary 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 Required
Licenses/Certifications Preferred
Required Training
Physical Requirements
LightAdditional 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
$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 Required
Licenses/Certifications Preferred
Required Training
Physical Requirements
LightAdditional 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