Description
The ODI Developer is responsible for the overall maintenance and development of the ETL tool used
Job Duties:
- Spearhead development of ETL code, metadata definitions and models, queries and reports, schedules, work processes and maintenance procedures.
- Design the detailed ETL architecture, including agents, scenarios, packages, data mappings, data extractions, transformations and validations. This ETL design and implementation will include standalone and Java EE agents, ODI data services, ODI Console, ODI studio, and other appropriate development tools.
- Implement ODI interfaces and scenarios for extracting and loading data from a variety of data sources/targets including Hyperion Planning, Essbase, Relational Database Management Servers (including Oracle RDBMS, SQL Server, and IBM DB2), flat files (including CSV, Excel, & XML file formats), and web services (SOAP, WS-I Security).
- Available as defects/Issues arise
- Perform the unit testing, system integration testing and assist with user acceptance testing
- Document the ETL detailed design and test results.
- Create and maintain integration process using ODI and load rules
- Liaison with Oracle support for Service Requests (SRs) and resolution of any issues
- Document new requirements, recommended and implement solutions
- Coordinate testing and changes to the application
- Ensure data quality throughout entire ETL process.
- Develops technical understanding of the application, as well as, an understanding of how the business uses this information and the data flows from system to system in order to define and execute cross-functional data movements for business intelligence
- Assist with software upgrades
- Develop system/integration test plans and scenarios for data loads and extracts.
- Mentor and train team personnel on ODI processes and procedures.
Job Qualifications:
- Experience: Minimum of 3-5 years experience with ODI version 11.1+ (experience with 12C preferred).
- Experience integrating different types of data sources including relational and multi dimensional databases (Essbase), web services, XML, CSV, and other file formats.
- Experience with Essbase and Hyperion Planning preferred.