This role will serve as an Application Developer for the Data Warehouse / ETL COE in Global Corporate Platforms / Corporate Insights group.
The Applications Developer will participate in all aspects of the SDLC lifecycle including design, development, deployment, support, enhancements and new project development.
The selected candidate will work on support and maintenance of Oracle Business Intelligence Applications such as Procurement and Spend Analytics, Finance Analytics, Project Analytics.
This hand on technical role requires Oracle and PL / SQL experience and experience working with ETL, preferably Oracle Data Integrator, or other ETL tools, packaged application support and maintenance and preferably ETL development, design skills, Data Warehouse architecture, Database SQL and UNIX skills.
Requirements Gathering and Analysis
ETL design, development, testing, production deployment
ETL debugging and analyzing data issues
Database - SQL & PL / SQL development
Unix Shell Scripting
Keeping system documentation updated
Establishing back up procedures for scripts and programs
Refresh of Dev / Test environments periodically
Coordinating with UNIX Engineers and DBAs
Monitoring data loads
Provide technical guidance to development teams
Preferred Skills :
Experience with Oracle Business Intelligence Applications such as Procurement and Spend Analytics, Finance Analytics, Project Analytics
Experience in PL / SQL development
Experience in any one ETL tool such as Oracle Data Integrator / Data Stage / Informatica / AbInitio / Pentaho / Microsoft SSIS
ETL and PL / SQL Performance Tuning
Strong analytical and problem solving skills
Strong written and verbal communication skills to interact with team members, IT teams, internal customers and management
The candidate, at minimum, must have :
Bachelor of Science in Computer Science, Engineering, or a math-related field
Excellent communication skills and proficient in English
At least 4 years of combined software development experience, or equivalent
At least 2 years of experience with Unix, Oracle SQL and PL / SQL development
At least 1 years of experience with ETL tools such as Oracle Data Integrator or Data Stage v8 or other best in class tools such as Informatica / Pentaho / SSIS
Primary Location : CRI-Heredia
Function - IT Development and Client Services
Schedule : Full time