Position Description: The ETL developer will be responsible for development and maintenance of the ELT/ETL processes in support of the Oracle Data Warehouse., including
- Development, validation, and support of the ELT/ETL procedures using ODI
- Implementation of data integration and data loading tasks
- Monitor and troubleshoot production data loads
- Data analysis
- Documentation of technical and system specifications documents for ETL processes
Major Responsibilities:
- Development, validation, and support of the ELT/ETL procedures with ODI
- Implementation of data integration and data loading tasks
- Migration of Legacy Jobs into ODI
- Monitor and troubleshoot production data loads
- Documentation of technical and system specifications documents for ETL processes
Required Skills / Knowledge:
- Strong written and oral communication skills
- Strong customer service orientation
- Knowledge of Data Warehouse architectures, including star- and snowflake- schema
- Strong analytical skills; Solid interpersonal skills
- Must be highly organized and work quickly; easily handle and adapt to numerous and shifting priorities
- Ability to successfully engage in multiple initiatives simultaneously
- Expertise in the Oracle ODI toolset and Oracle PL/SQL
- Strong knowledge of ELT/ETL concepts, design and coding
- SQL Performance tuning
- Proven experience in developing functional applications and systems of medium to high technical complexity
Experience Needed:
- 3 to 5 years hands-on experience with ELT/ETL development in a Data Warehouse environment
- 5+ years of relevant experience in a Data Warehouse Environment.
- 3 to 5 years developing with an ETL tool.
- Experience with Oracle Data Integrator is a plus
- Has experience with Oracle, SQL queries, stored procedures, for interfacing with the database and database designs.
- Experience in publishing, digital media is a plus.
- Some experience with Jython, Python or Groove is a plus
- Some experience working with Json file format and APIs.
- Experience with ‘Big Data’ is a plus
Educational Background Required:
- Bachelor degree in Computer Science, M.I.S., Business, Math/Stats or related field
To apply for this job email your details to ja@devonshireit.com