Job Summary :
Proven ability to lead ETL development projects and development team in developing and maintaining full lifecycle data integration.
Experienced in simple routine maintenance to moderately complex software enhancements / modifications. Responsible to provide support in all aspects of the design specifications, mapping, development, and testing of data movement for an Oracle Cloud environment, with emphasis on integrations and the Extract-Transform-Load (ETL) process.
Understands computer file transmission protocols and has significant experience in extracting, programming / transforming data for integration.
Can interpret and clarify specifications for interface development using transformation engines.
Education and Work Experience :
- Associate's / Technical Degree or equivalent combination of education / related experience : Required
- Bachelor's Degree : Preferred
- Five years' application / technical experience : Preferred
- SQL experience : Required
- Experience directing and / or leading development projects / teams : Preferred
- Certification or three years' experience with Informatica or other integration tools : Required
- Experience with Oracle BI Publisher, OTBI, FRS and / or HCM Extracts : Required Experience with Java : Preferred
- Refer to Job Analysis 05A for details regarding additional ability requirements.
Essential Functions :
- Participates or leads in data conversions, system integrations, report creation and maintenance : for cloud-based Enterprise Resource Planning applications, including Oracle HCM Cloud, Oracle ERP Cloud, Oracle Procurement Cloud, Oracle Service Cloud, Kronos Workforce Timekeeper, and / or Taleo.
- Analyzes, develops and oversees software to meet requests / specifications. Develops software in a product team environment and assists other developers as required.
- Utilizes and ensures established standards for systems design, coding, documentation and distribution. Oversees software testing per release checklist guidelines.
Develops and coordinates general installation work plans.
Develops and reviews training materials. Maintains operation level agreements with various end-user departments and enterprise business units.
Assumes responsibility for problem assessment and resolution.
- Identifies potential areas where policies / procedures require development or change. Utilizes help desk computer software in conjunction with other regional facility and enterprise staff.
- Performs other job-related duties as assigned.