ODI SUPPORT & DATA INTEGRATION DEVELOPER (HYBRID / REMOTE)

ODI SUPPORT & DATA INTEGRATION DEVELOPER (HYBRID / REMOTE BRAZIL)

Brazilian company hires for hybrid or remote position.

Location: Brazil (any location).

Only candidates already based in Brazil will be considered.

• Work Model: Hybrid for candidates living in state capitals and Remote for candidates living in countryside/cities outside the state capitals.
• Language Requirements: Advanced/Fluent English – Mandatory (there will be direct contact with an international client).
• Seniority: Senior (6+ years).
• Compensation: Please inform your salary expectations when applying.

Build Enterprise Data Integration Solutions

We are looking for an experienced Data Integration Developer to design, develop, and optimize enterprise ETL solutions supporting critical Data Warehouse initiatives.

In this role, you will transform business requirements into scalable technical solutions, ensuring data quality, high performance, and reliable integration processes for large enterprise environments.

If you enjoy solving complex data integration challenges and working on mission-critical analytics platforms, this opportunity is for you.

The Professional We Are Looking For

We are seeking a highly skilled ETL and Data Integration professional with deep expertise in Oracle technologies and enterprise Data Warehouse implementations.

The ideal candidate combines strong technical knowledge with analytical thinking, excellent communication skills, and the ability to work independently while collaborating with multidisciplinary and international teams.

You should be comfortable designing ETL architectures, optimizing Oracle performance, and delivering robust data integration solutions throughout the full project lifecycle.

Key Responsibilities

• Design, develop, and maintain enterprise ETL processes using Oracle Data Integrator (ODI).
• Participate in complete Data Warehouse implementation projects.
• Develop scalable and reusable ETL/ELT workflows.
• Ensure data quality, integrity, auditing, and error logging across integration processes.
• Optimize SQL and ETL performance for high-volume enterprise environments.
• Develop and maintain Oracle PL/SQL packages, procedures, triggers, and views.
• Translate business requirements into technical specifications and solution designs.
• Troubleshoot and debug ODI workflows and data integration processes.
• Document technical solutions, architecture, and best practices.
• Collaborate with business stakeholders and technical teams to deliver high-quality data solutions.

Mandatory Requirements (Eliminatory)

Education

• Computer Science
• Information Technology
• or a related field

(Equivalent professional experience will also be considered.)

Mandatory Experience

• Proven experience in ETL Development.
• Strong hands-on experience with Oracle Data Integrator (ODI).
• Experience leading or participating in complete Data Warehouse implementations.
• Advanced Oracle PL/SQL development.
• Advanced SQL.
• SQL performance tuning.
• Oracle Database administration and development.
• Experience with ETL/ELT frameworks.
• ODI automation and script debugging.
• Development of ETL workflows.
• Control tables, auditing, logging, and error handling.
• Reusable and parameterized ETL process design.
• Workflow design.
• Data modeling.
• ETL architecture and design.
• Performance optimization.
• Development of PL/SQL packages.
• Triggers.
• Views.
• Exception handling.
• Data migration.
• Ability to translate business requirements into technical specifications and design documentation.
• Strong analytical and problem-solving skills.
• Excellent written and spoken English.

Nice-to-Have Skills

• Financial Services industry experience.
• Wealth Management.
• Asset Management.
• Enterprise-scale Data Warehouse modernization.
• Large-volume enterprise data integration projects.

What You’ll Find in This Opportunity

• Participation in strategic enterprise Data Warehouse initiatives.
• Complex Oracle-based data integration projects.
• Opportunity to work with modern ETL architectures and enterprise data platforms.
• Collaboration with international technical teams.
• High-impact role supporting business-critical analytics environments.
• Innovation-focused and collaborative engineering culture.

Before Applying, Ask Yourself These 5 Questions

• Do I have solid hands-on experience with Oracle Data Integrator (ODI) and enterprise ETL development?
• Have I participated in complete Data Warehouse implementation projects, from design through deployment?
• Does my CV clearly demonstrate advanced experience with Oracle PL/SQL, SQL tuning, ETL architecture, and Oracle Database?
• Am I experienced in developing reusable ETL workflows, implementing auditing, logging, parameterization, and performance optimization?
• Am I fluent in English and comfortable translating business requirements into technical specifications while collaborating with international teams?

If you answered "No" to one or more of these questions, we recommend carefully reviewing your fit before applying.

Important

This position is intended for a Senior ODI & Data Integration Specialist with strong expertise in Oracle-based ETL solutions and enterprise Data Warehouse implementations.

Candidates whose experience is primarily focused on database administration, reporting, or software development, without substantial hands-on experience in Oracle Data Integrator (ODI) and enterprise ETL projects, are unlikely to meet the expectations for this role.

Keywords That Should Appear in Your CV: ODI Developer, Oracle Data Integrator, Data Integration Developer, ETL Developer, ETL Lead, Data Warehouse, Data Warehouse Implementation, Oracle Database, Oracle PL/SQL, PL/SQL, SQL, SQL Tuning, Performance Tuning, ETL, ELT, ETL Frameworks, Oracle ODI, Workflow Design, Data Modeling, Data Migration, Oracle Packages, Stored Procedures, Triggers, Views, Exception Handling, Data Quality, Data Auditing, Logging, Parameterization, Script Automation, ODI Debugging, Technical Design, Solution Design, Enterprise Data Integration, Enterprise Analytics, Financial Services, Wealth Management, Asset Management

#EY BR