IS Data Integration Developer

Overview

This job supports, develops, and maintains Extract, Transform and Load (ETL) solutions in a data warehouse environment that includes ancillary data stores. Develops extracts, dashboards, reports, and data solutions, and uses tools like Informatica. Creates workflows, sessions, and mappings in accordance with standards and best practices. Analyzes data, validates data quality, gathers requirements, conducts data modeling and data warehouse design and contributes to the creation of supporting documentation.

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable qualified individuals with disabilities to perform the essential duties.

This job description is a summary of the primary duties and responsibilities of the job and position. It is not intended to be a comprehensive or all-inclusive listing of duties and responsibilities. Contents are subject to change at the company’s discretion.

Education

Required - High school diploma or equivalent.

Preferred - Master’s degree in computer science or related field.

Work Experience

Required - 4 years of experience with development, data extraction, ETL using an Enterprise tool, SQL programming language, data analysis, data profiling or related,

OR

1 year of experience with SQL programming language, data analysis and data profiling, 2 years of experience with data extraction or ETL using an Enterprise tool, and 1 year of experience in development with a bachelor's degree in computer science or related field.

Preferred - 1 year of experience with a formal development methodology like Scrum Agile developing on a Massively Parallel Processing (MPP) database working with a project or task tracking tool and ETL tool like Informatica PowerCenter 9.x,10.x, DataStage, or SQL Server Integration Services (SSIS).

Knowledge Skills and Abilities (KSAs)

• Proficiency in using computers, software, and web-based applications, and willingness to learn new technologies.
• Proficient in PL/SQL database/programming languages for creating and maintaining Data Definition Language (DDL) and Data Manipulation Language (DML) code.
• Strong knowledge of ETL and ETL tools and ability to create, maintain and execute test plans for ETL streams.
• Analytical, design, and development skills and ability to modify or expand information systems.
• Effective verbal and written communication, interpersonal, and customer service skills and the ability to collaborate with the team, internal business and technology departments as well as external vendors.
• Problem solving skills and ability to be self-motivated, work independently, and pay close attention to detail, accuracy of facts and documentation.
• Excellent organizational and time management skills and ability to follow through on tasks in a timely manner and effectively manage multiple priorities.

Job Duties

• Contributes to the development of data architecture and data modeling, including developing extracts, dashboards, reports, and data solutions, and uses tools like Informatica.
• Creates workflows and sessions and develops ETL mapping solutions within the data warehouse environment following current processes.
• Maintains and develops documentation to identify and define processes, monitors production systems for issues and escalates or resolves issues.
• Analyzes data, validates data quality, gathers requirements, conducts data modeling and data warehouse design; and contributes to the creation of supporting documentation in accordance with best practices.
• Supports and monitors ETL systems and data integration server.
• Manages and completes projects as needed.
• Performs other related duties as required.

The above statements describe the general nature and level of work only. They are not an exhaustive list of all required responsibilities, duties, and skills. Other duties may be added, or this description amended at any time.

Remains knowledgeable on current federal, state and local laws, accreditation standards or regulatory agency requirements that apply to the assigned area of responsibility and ensures compliance with all such laws, regulations and standards.

Physical and Environmental Demands

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Sedentary Work - Exerting up to 10 pounds of force occasionally and/or a negligible amount of force frequently to lift, carry, push, pull, or otherwise move objects. Sedentary work involves sitting most of the time but may involve walking or standing for brief periods of time. Jobs are sedentary if walking and standing are required only occasionally and all other sedentary criteria are met.

Normal routine involves no exposure to blood, body fluid or tissue and as part of their employment, incumbents are not called upon to perform or assist in emergency care or first aid.

The incumbent has no occupational risk for exposure to communicable diseases.

Because the incumbent works within a healthcare setting, there may be occupational risk for exposure to hazardous medications or hazardous waste within the environment through receipt, transport, storage, preparation, dispensing, administration, cleaning and/or disposal of contaminated waste. The risk level of exposure may increase depending on the essential job duties of the role.

Are you ready to make a difference? Apply Today!

Ochsner Health does not consider an individual an applicant until they have formally applied to the open position on this careers website.

Individuals who reside in and will work from the following areas are not eligible for remote work position: Colorado, California, Hawaii, Maryland, New York, Washington, and Washington D.C.