IS Developer
Ochsner Health · New Orleans, LA
Start free. No credit card.
About the Job
We've made a lot of progress since opening the doors in 1942, but one thing has never changed - our commitment to serve, heal, lead, educate, and innovate. We believe that every award earned, every record broken and every patient helped is because of the dedicated employees who fill our hallways.
At Ochsner, whether you work with patients every day or support those who do, you are making a difference and that matters. Come make a difference at Ochsner Health and discover your future today!
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.
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 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.
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.
Sedentary Work - Exerting up to 10 pounds of force occasionally (Occasionally: activity or condition exists up to 1/3 of the time) and/or a negligible amount of force frequently (Frequently: activity or condition exists from 1/3 to 2/3 of the time) 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.