Sign in

Data Integration Consultant

Porto Alegre, RS, Brazil
February 27, 2018

Contact this candidate


Josué Borges

*** **** ***. *** ***, Porto Alegre, RS, Brazil • +55-51-981**-**** •


Over 9 years of experience in ETL processes, working in Data Warehousing and other kinds of data-driven projects;

Expert in Oracle Data Integrator (8 years’ experience), including:

Installation and configuration;

Agents setup;

Repositories and user’s administration;

Topology setup;

Knowledge modules (load strategies) customization;

Java, Jython and PL/SQL development;

Shell scripting;

Interfaces, functions and procedures implementation;

SQL performance tuning;

Change Data Capture implementation (CDC);

Slowly Changing Dimension (SCD) setup for DW projects;

Deployment and Load Plan management;

Installation, utilization and deployment guide documentation.

Demonstrated ability working with Informatica PowerCenter and Oracle Warehouse Builder (OWB);

Enthusiast of best practices and process improvements initiatives.


Senior Data Integration Consultant 2014 – Present

DBServer, Porto Alegre, Brazil. Contractor at Ticket Log.

ODI development team lead, responsible for implementation, maintenance, tuning, troubleshooting and administration of ETL processes, regarding the fields of Data Warehouse, Geoprocessing and others.

Highlighted achievements and performed tasks:

Improvements on Oracle Data Warehouse load processes: reduction of execution time of up to 50%. Techniques utilized: SQL tuning, table partitioning and ODI KMs customization (Java / Jython);

Java programing to integrate SAP Business Objects repository metadata into Oracle monitoring tables through ODI;

ODI repositories management for Disaster Recovery project;

Josué Borges Page 2 of 3

Responsible for providing customized architectural solutions for heterogeneous environments integration (Oracle, Sybase, PostgreSQL, xml, flat files);

Mentorship for less experienced developers.

Senior Data Integration Consultant 2012 – 2013

DBC Company, Porto Alegre, Brazil

Responsible for requirements gathering, modeling, developing and maintenance of Oracle Data Integrator interfaces to integrate ERP and legacy systems for the Rio Grande do Sul industries federation, also utilizing skills in PL/SQL, xml and java.

Software Development Sr. Analyst 2012

Stefanini IT Solutions, Porto Alegre, Brazil

Worked as contractor for Dell Inc. Brazil, responsible for requirements gathering, technical design specifications and data integration solutions development for several projects of Dell Financial Services department, in geographically distributed teams (Brazil / US / Asia). Technical skills utilized:

Processes implementation with Informatica PowerCenter;

Batch scripting;

Control-M jobs scheduling;

Oracle 10g procedures and data manipulation.

ETL/ODI Specialist 2011 - 2012

Getnet, Porto Alegre, Brazil

Responsible for requirements gathering and dimensional modeling for Oracle Data Warehouse specification. Also performed a set of ODI development tasks, including:

ETL processes implementation, extracting data from PostgreSQL, Sybase and Oracle databases;

Data Marts load processes tuning;

CDC and SCD implementation for DW load processes;

SQL execution plans optimization;

ODI load strategies customization for performance improvements;

Data quality processes development.

Josué Borges Page 3 of 3

ETL Consultant 2010 - 2011

Advanced IT, Porto Alegre, Brazil

Worked directly with customers on data-driven initiatives. Most relevant projects were the following:

Dimensional modeling and ETL processes implementation using ODI for Data Warehouse project at Getnet company.

Data integration processes development with Oracle Warehouse Builder for Brazilian energy power company’s Data Warehouse.

Also served as a technical instructor for Advanced IT employees, training them in Oracle Data integrator development.

Business Intelligence Consultant 2009 - 2010

Carpio Solutions, Porto Alegre, Brazil

BI Consultant at a banking sector customer. Worked with ETL processes implementation, troubleshooting and data load validations in an environment which aggregate an Oracle Data Warehouse and Hyperion Essbase applications used by

Corporate Financial Planning department. Technical skills utilized were related to PL/SQL, Hyperion Essbase applications and shell script development.

Systems Analyst 2008

Keyrus, Porto Alegre, Brazil

Worked as a systems analyst on a data integration project for the Brazilian National Council of Justice, to concentrate all the information of judicial processes coming from the national states in a unified Oracle datacenter.

Responsible for requirements gathering, artifacts nomenclature definitions and development of connections topology through ODI to make the integration processes feasible were the activities carried out in the project.


Undergraduate degree in Systems Analysis and Development (3 years) 2017

Universidade do Vale do Rio dos Sinos - UNISINOS


Available Upon Request

Contact this candidate