ETL Data Integration Developer III

1 month ago

Los Angeles, California, United States L.A. Care Health Plan Full time

Salary Range: $105, Min.) - $139, Mid.) - $173, 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 III is responsible for the operational support of Informatica environment including but not limited to automation, job scheduling, dependencies, monitoring and maintenance of Extract, Transform, and Load (ETL) mappings, mapplets, and documentation. This position manages, administers and works with ETL administration in addressing systems performance including on-going optimization and tuning of Informatica environment. This position develops reliable and complex ETL processes to support new development of the Enterprise Data Warehouse, Data Marts and other Business Intelligence projects. This position also assists the Data Warehouse team in completing current Data Warehouse initiative projects. This position also performs the duties to analyze and evaluate the data source and data targets required for the ETL mapping. Design, develop and implement complex ETL processes. This position also supports and participates in source data analysis, specifically as it relates to domain definitions. Acts as a Subject Matter Expert, serves as a resource and mentor for other staff.

Duties

Responsible for the operational support of Informatica environment including but not limited to automation, job scheduling, dependencies, monitoring, maintenance, patches, upgrades, security, and administration.

Administers systems performance including on-going optimization and tuning of Informatica environment.

Supports and enhances existing Informatica environment and develops new, complex ETL processes to support additional design, development and deployment of the Enterprise Data Warehouse, and Data Marts.

Assists data warehouse team in completing current data warehouse initiative projects.

Analyzes and evaluates data sources.

Designs and implements complex ETL processes.

Applies subject expertise in evaluating business operations and processes. Identifies areas where technical solutions would improve business performance. Consults across business operations, providing mentorship, and contributing specialized knowledge. Ensures that the facts and details are correct so that the project's/program's deliverable meets the needs of the department, organization and legislation's policies, standards, and best practices. Provides training, recommends process improvements, and mentors junior level staff, department interns, etc. as needed

Performs other duties as assigned.

Duties Continued
Education Required
Bachelor's Degree in Statistics or Related FieldIn lieu of degree, equivalent education and/or experience may be considered.Education Preferred
Master's Degree in StatisticsExperience

Required:

5 years of experience in Informatica ETL Developer role in Data Warehouse projects, Enterprise Data Warehouse, Online Analytical Processing (OLAP) and dimensional data modeling.

At least 3 years of proven development experience in design and development of 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, logical/physical design and development.

Strong experience and comprehensive proficiency with Informatica in an Oracle Data Warehouse/BI environment

Experience in documenting requirements and negotiating commitments

Strong project life cycle experience.

Skills

Required:

Strong database development skills including the ability to analyze, create and optimize complex SQL queries and stored procedures, working on relational databases especially Oracle & MS SQL Server.

Proficient in data analysis and problem solving.

Possess excellent communication skills, both written and verbal.

Thorough knowledge of Systems Development Life Cycle (SDLC).

Must develop, foster and maintain an open, professional relationship with IT staff, management and business customers.

Excellent verbal and written communication skills.

Strong organizational and documentation skills.

Strong Understanding of DW/BI concepts.

Good knowledge of Software Development Lifecycle.

Understanding of development lifecycle methodology and ability to successfully deliver Informatica assignments.

Healthcare domain.

Proven ability to perform technology needs assessment and evaluate solution options.

The capability of performing interface analysis at the detail level.

A solid understanding of software development life cycle; and broad-based knowledge of application systems technologies.

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

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

  • Lead ETL Data Integration Developer

    1 month ago

    Los Angeles, California, United States L.A. Care Health Plan Full time

    Salary Range: $121, Min.) - $160, Mid.) - $199, 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...

  • Lead ETL Data Integration Developer

    2 months ago

    Los Angeles, California, United States L.A. Care Health Plan Full time

    Salary Range: $121, Min.) - $160, Mid.) - $199, 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...

  • ETL Developer

    5 months ago

    Los Angeles, California, United States Matal Full time

    Responsibilities Analyze requirements from clients and work with development team to provide meaningful analysis on data to satisfy client s business needs. Design maintain and develop efficient SQL & PL/SQL languages to maintain ETL code. Design build and configure applications to meet business process and application requirements. Works with analyst and...

  • Etl Developer

    5 months ago

    Los Angeles, California, United States Matal Full time

    Responsibilities Maintain and Manage the existing Client's Enterprise Data Warehouse and ODS builds. Model extensions to the existing Data Warehouse. Builds ETL components according to ETL specifications. Code must address performance dependency auditing error handling and data quality issues. Support post deployment by debugging fixing and participating in...

  • Business Intelligence Developer III

    2 months ago

    Los Angeles, California, United States L.A. Care Health Plan Full time

    Salary Range: $91, Min.) - $121, Mid.) - $151, 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...

  • Data Engineer

    5 months ago

    Los Angeles, California, United States Apollose Full time

    Responsibilities Standardize data and reporting across businesses and teams to enhance the consistency and quality of data. Design develop test and document data integrations and assist with deployment validation and hyper care processes. Maintain and support existing ETL/ELT integrations leveraging technical documentation. Develop and maintain existing...

  • Lead ETL Business Intelligence Administrator

    1 month ago

    Los Angeles, California, United States L.A. Care Health Plan Full time

    Salary Range: $121, Min.) - $160, Mid.) - $199, 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...

  • MS SQL Database Developer with Informatica Expertise

    1 week ago

    Los Angeles, California, United States Tetrahed INC Full time

    Job OverviewThe role of an MS SQL Database Developer with Informatica expertise is crucial in ensuring the efficient design, development, and maintenance of MS SQL databases and Informatica ETL processes. This role plays a pivotal part in the organization's data management and integration efforts, contributing to the overall success of data-driven...

  • MS SQL Database Developer with Informatica Expertise

    1 week ago

    Los Angeles, California, United States Tetrahed INC Full time

    Job OverviewThe role of an MS SQL Database Developer with Informatica expertise is crucial in ensuring the efficient design, development, and maintenance of MS SQL databases and Informatica ETL processes. This role plays a pivotal part in the organization's data management and integration efforts, contributing to the overall success of data-driven...

  • Clinical Data Analyst III

    3 weeks ago

    Los Angeles, California, United States L.A. Care Health Plan Full time

    Salary Range: $88, Min.) - $115, Mid.) - $142, 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...

  • Payment Integrity Analyst III

    2 months ago

    Los Angeles, California, United States L.A. Care Health Plan Full time

    Salary Range: $77,265.00 (Min.) - $100,445.00 (Mid.) - $123,625.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...

  • Sr Data Engineer

    5 months ago

    Los Angeles, California, United States codesbright Full time

    Responsibtlies Produce ad-hoc data extracts to answer business questions quickly and thoroughly. Collaborate with Project Managers IT Architecture Business Analysts and Report Developers to achieve business objectives. Develop technology documentation to support production deployments as well as ongoing maintenance of reporting and data solutions....

  • Sr Data Analyst

    5 months ago

    Los Angeles, California, United States wipros Full time

    Responsibilities Create and maintain documentation related to data solutions for supply chain operations. Analyze data to identify trends and insights that inform decision-making for supply chain operations. Develop and maintain dashboards scorecards and other visualizations to monitor and analyze supply chain performance. Stay up-to-date with the latest...

  • Data Architect

    5 days ago

    Los Angeles, California, United States Centerfield Full time

    About the OpportunityCenterfield, a leading digital marketing solutions company, is seeking a highly motivated and experienced Senior Data Engineer to join our team. As a key member of our data science team, you will be responsible for designing and implementing innovative data solutions to support our Generative AI initiatives.Key ResponsibilitiesDesign and...

  • Senior Data Engineer

    5 days ago

    Los Angeles, California, United States Centerfield Full time

    About the OpportunityCenterfield, a leading digital marketing solutions company, is seeking a highly motivated and experienced Senior Data Engineer to join our team. As a key member of our data science team, you will be responsible for designing and implementing innovative data solutions to support our Generative AI initiatives.Key ResponsibilitiesDesign and...

  • Integration Solutions Architect

    2 weeks ago

    Los Angeles, California, United States Satwic Inc Full time

    Position Overview:As a key member of the Satwic Inc team, the Integration Solutions Architect will play a pivotal role in shaping our integration strategies and solutions. This position requires a seasoned professional with extensive experience in designing and implementing integration frameworks that enhance our operational efficiency.Key...

  • Senior Data Engineer

    3 days ago

    Los Angeles, California, United States AEG Worldwide Full time

    About the RoleWe are seeking a highly skilled Senior Data Engineer to join our global data engineering team at AEG Worldwide. As a key member of our team, you will be responsible for designing, implementing, and maintaining modern and efficient ETL/ELT pipelines, as well as supporting existing processes and frameworks.Key ResponsibilitiesDesign and Implement...

  • Net Developer III

    1 month ago

    Los Angeles, California, United States L.A. Care Health Plan Full time

    Salary Range: $105, Min.) - $139, Mid.) - $173, 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...

  • Clinical Research Data Spec III

    3 months ago

    Los Angeles, California, United States Cedars-Sinai Full time

    Job DescriptionGrow your career at Cedars-Sinai The Smidt Heart Institute reflects Cedars-Sinai's steadfast dedication to heart disease and research innovation giving patients access to the highest level of care. Year after year, thousands of people trust their hearts to Smidt Heart Institute at Cedars-Sinai. Our cardiologists, cardiac surgeons and...

  • Sr SSRS PBI Developer

    3 weeks ago

    Los Angeles, California, United States iLink Digital Full time

    Job DescriptionAbout The Company:iLink is a Global Software Solution Provider and Systems Integrator, delivers next-generation technology solutions to help clients solve complex business challenges, improve organizational effectiveness, increase business productivity, realize sustainable enterprise value and transform your business inside-out. iLink...