Data Engineer, Oracle – AI Database / Integração

This is a fully remote position, open to applicants in Brazil.

📋 Description

• Engage in the modeling, creation, and configuration of Oracle databases, including tables, sequences, primary keys, and other structural objects, as well as initial data loading and data cleansing processes;

• Develop and maintain integration APIs for the updating and insertion of master data, ensuring consistency and synchronization across systems;

• Build APIs for data exposure, facilitating queries and positioning of information for consumption by both internal and external systems;

• Implement and enhance data auditing processes, including traceability (data lineage) and change history;

• Support the implementation of data synchronization mechanisms, which may involve the use of triggers and Oracle GoldenGate (OGG), depending on the environment's requirements;

⛳️ Requirements

• Oracle AI Database 26ai;

• Database creation (tables, sequences, PK... database configuration) - initial loading/cleansing;

• API for master data updating/insertion (synchronization);

• API for data exposure positioning;

• Creation of the auditing process update (data lineage) and history;

• Trigger/OGG (synchronization);

🏝️ Benefits

• Remote work