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.
