ODI SUPPORT & DATA INTEGRATION DEVELOPER (HYBRID / REMOTE)

iTRTech Group • São Paulo, SP, BR

Há +30 dias

Descrição da vaga

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), Native portuguese

🕓 Seniority: Senior (6+ years)

💰 Compensation: Please inform your salary expectations when applying.

⚠️ Instructions: Please send your CV in English and make sure to include all skills and experience that match the requirements of the opportunity. This will significantly increase your chances of success.

_______________________________________________________________________

Build Enterprise Data Integration Solutions

We are looking for an experienced ODI Support & Data Integration Developer to design, develop, and optimize enterprise ETL solutions supporting large-scale Data Warehouse initiatives.

In this role, you will develop robust ETL processes, ensure data quality, optimize performance, and transform business requirements into scalable technical solutions while contributing to the digital transformation of major Financial Services organizations.

If you are passionate about Oracle technologies, ETL development, and enterprise data integration, this opportunity is for you.

The Professional We Are Looking For

We are seeking a highly skilled ETL and Data Integration professional with extensive experience in Oracle Data Integrator (ODI) and enterprise Data Warehouse implementations.

The ideal candidate is capable of working independently while collaborating effectively with multidisciplinary and international teams. You should combine strong Oracle expertise with analytical thinking, problem-solving skills, and the ability to deliver high-performance, scalable data integration solutions.

Key Responsibilities

You will be responsible for:

Developing and maintaining enterprise ETL processes using Oracle Data Integrator (ODI).
Participating in complete Data Warehouse implementation projects.
Designing scalable, reusable, and parameterized ETL/ELT workflows.
Ensuring data quality through auditing, logging, error handling, and validation processes.
Optimizing Oracle SQL and ETL performance for enterprise environments.
Developing and maintaining Oracle PL/SQL packages, procedures, triggers, and views.
Translating business requirements into technical specifications and solution designs.
Troubleshooting and debugging ODI workflows and automation scripts.
Documenting technical solutions, ETL architectures, and engineering best practices.
Collaborating with business stakeholders and technical teams to deliver robust data integration solutions.

Mandatory Requirements (Eliminatory)

⚠️ All requirements below are mandatory and eliminatory. Candidates who cannot clearly demonstrate these qualifications in their CV are unlikely to proceed in the recruitment process.

Education

✔ Bachelor's Degree in:

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 participating in complete Data Warehouse implementations.
Strong expertise in Oracle PL/SQL.
Advanced SQL and SQL Performance Tuning.
Experience with: Oracle Data Integrator (ODI) Oracle Database ETL/ELT Frameworks ODI Script Automation and Debugging
Oracle Data Integrator (ODI)
Oracle Database
ETL/ELT Frameworks
ODI Script Automation and Debugging
Experience developing ETL processes, table control, workflow design, parameterization, reusable components, auditing, error logging, and error handling.
Knowledge of Data Modeling.
ETL Architecture and Design.
Performance tuning and SQL optimization.
Development of PL/SQL Packages, Triggers, and Views.
Exception Handling.
Data Migration.
Ability to translate business requirements into technical specifications and design documentation.
Excellent written and spoken English.
Strong analytical thinking, interpersonal, and problem-solving skills.

Nice-to-Have Skills

The following qualifications will be considered a strong advantage:

Experience within Financial Services.
Experience with Wealth Management.
Experience with Asset Management.

What You'll Find in This Opportunity

Participation in strategic enterprise Data Warehouse initiatives.
Complex Oracle-based ETL and Data Integration projects.
Opportunities to work with modern enterprise data platforms.
Collaboration with international technical teams.
High-impact role supporting digital transformation initiatives.
Innovation-focused and collaborative engineering culture.

Before Applying, Ask Yourself These 5 Questions

✅ Do I have strong 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, Oracle Database, ETL architecture, and workflow development?

✅ Am I experienced in developing reusable ETL processes with auditing, logging, parameterization, automation, debugging, 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 opportunity is intended for a Senior ODI Support & Data Integration Developer with extensive experience delivering enterprise ETL solutions using Oracle Data Integrator (ODI).

Candidates whose experience is primarily focused on Database Administration, Reporting, Business Intelligence, or Software Development, without substantial hands-on expertise in Oracle Data Integrator (ODI), Data Warehouse implementations, Oracle PL/SQL, and enterprise ETL development, are unlikely to match the expectations for this role.

Keywords That Should Appear in Your CV

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

#EY BR