For a Telco company, we’re looking for a ETL Developer – Oracle Data Integrator (ODI).

The position is remote.

ETL Developer responsible for analysis, design, development, maintenance, and support of data pipelines in an Oracle Database (using Oracle Data Integrator and Oracle Database 12c). Able to work in an international environment, with English as primary language of interaction.

Primary Duties & Responsibilities:

Design, develop and test ETL components
Create Interfaces, packages, Load plans in ODI
Perform break fixes for production failure jobs
Perform troubleshooting on ETL components
Perform unit testing of ETL components and document test results
Work with technical leads, architects, subject matter experts, developers, technical support groups and test teams to deliver value to the business
Develop SQL Queries to fetch complex data from different tables, from different databases using database links, insert results into the newly developed tables
Create materialized views and synonyms for developers to hide the complexity and secure the direct access of DB Tables
Develop various Oracle sub functions like Stored Procedures, Functions, and Packages using PL/SQL asper the Design Documents
Analyze business requirements and developed design documents (Class diagrams and Sequence diagrams) and Packages & Stored Procedures
Setup technical design documents, data mapping documents as necessary for all enhancements and change requests
Design ETL mappings, workflows to extract the data from various upstream systems and load them to large Data warehousing and reporting databases based on Reporting Business requirements
Support Application Rollouts in Prod and Non-Prod environments and provide post Go Live support
Create and customize ODI interfaces, mapping, joins, filters lookups to implement business rules
Required Skills:

Written and verbal communication required in both English and Italian
Oracle suite
Oracle Database – e.g. 11, 12c
Oracle Data Integrator
SQL, PL/SQL
Relational databases
Document and review High- and Low-level design documents for ETL solutions
Strong technical and analytical skills
Problem solving and troubleshooting skills, must be attentive to detail, and understand implications for the business
Researching and interpreting data, with a solid understanding of relational database concepts and table design
Experience with Software version control
Required Experience:

1+ year of experience with Oracle Data Integrator
3+ years of experience in Data Warehousing projects – Databases, ETL, Business Intelligence
Bachelor’s degree in Computer Science, Computer Information Systems, Information Technology, a closely related field, or a combination of education and experience

Condividi
Full time
Non richiesta
Da definire
Database Administrator
Non richiesta
(Smart working)

HERZUM

Rende ( CS )

Iscritto su Reteinformaticalavoro dal 16/10/2020

Herzum è una società di consulenza internazionale, uno dei più grandi partner Atlassian nel mondo. Il gruppo è stato creato nel marzo 2000 a Chicago e ha uffici in Italia, India, Svizzera, Ecuador e Regno Unito ed è impegnato ad espandere la sua presenza geografica dal 2016. Fornisce servizi Agile e DevOps di ultima generazione, consulenza avanzata a livello aziendale, così come lo sviluppo... Scopri l'azienda ›

Questo sito o gli strumenti terzi da questo utilizzati usano cookie tecnici proprietari e cookie analitici di terze parti che migliorano la navigazione e il funzionamento del sito. Se volete saperne di più o eliminare i cookie consultate l’Informativa sui cookie nella sezione dedicata. Chiudendo questo banner, scorrendo questa pagina, cliccando su un link o proseguendo la navigazione in altro modo acconsentite all’uso dei cookie.