Jhonathan Dos Santos Gomes
Campo Mourão
Summary
Senior Data Engineer with +10 years of experience working with ETL tools and analytical data, strong knowledge in SQL and multidimensional modeling, as well as Extract, Transform, and Load (ETL) techniques and Business Intelligence.
Overview
17
17
years of professional experience
Work History
Senior Data Engineer
Artycs.ai
09.2023 - Current
- Development of ETLs (Extract, Transform, and Load) using ODI (Oracle Data Integrator), Oracle PL/SQL and Azure Data Factory (ADF)
- Creation and monitoring/management of schedules and jobs within ODI (Oracle Data Integrator), Data Factory, and Databricks Pipelines
- Creation and monitoring of tables and rules for Oracle and SQL Server databases
- I was able to actively participate in the creation of the new purchasing solution for Lojas Americanas, one of the largest e-commerce and retail companies in Brazil.
- With this project developed in PL/SQL, Data Factory, and ODI, we were able to speed up and improve the entire forecasting process of purchasing the company's products, which was previously done entirely in Excel.
Senior Data Engineer
Stefanini Brasil
09.2021 - 09.2023
- Development of ETLs (Extract, Transform, and Load) using ODI (Oracle Data Integrator), Oracle PL/SQL, Azure Data Factory (ADF)
- Creation and monitoring/management of schedules and jobs within ODI (Oracle Data Integrator), Data Factory, and Databricks Pipelines
- Creation and monitoring of tables and rules for Oracle and SQL Server databases
- I successfully enhanced numerous ETL processes within the company by implementing best practices in data loading
- Given the abundance of older projects and processes, I had the opportunity to modernize and optimize the ETL workflows by updating tools as necessary and applying performance tuning techniques.
Business Intelligence Analyst
COAMO AGROINDUSTRIAL COOPERATIVA
07.2014 - 02.2021
- Development of ETL (Extract, Transform, and Load) processes using ODI (Oracle Data Integrator)
- Creation and monitoring/management of ODI (Oracle Data Integrator) schedules
- Creation and monitoring of tables and rules in ORACLE databases
- In this Business Intelligence (BI) implementation project at the company, I had the opportunity to work not only with data loading (ETL) but also with requirements gathering and multidimensional modeling of tables in the database, as well as creating dashboards in OBIEE
- I worked on all processes and best practices in a BI project, such as: Data source mapping, Data modeling (multidimensional modeling), ETL (Extract, Transform, and Load) of data in different layers: Staging Area, Data Warehouse (DW), Data Mart (DM), Data calculations and analysis, Dashboard creation.
Administrative Assistant
Fundo de Proteção à Saúde - FUPS
02.2007 - 06.2014
Education
Postgraduate in Oracle Database Administration -
Faculdade Integrado
Campo Mourão - Paraná - Brazil06.2016
Technology in Analysis And Systems Development -
Faculdade Integrado
Campo Mourão - Paraná - Brazil12.2014
Skills
- Database Management (MySQL, SQL Server, Oracle, PL/SQL, OLTP and OLAP Modeling)
- Business Intelligence - Data Analysis, Requirements Gathering, and Multidimensional Modeling
- ETL - Data Loading (ODI, Data Factory, DataBricks, PySpark)
- Azure Data Factory, Azure Blob Storage, Azure Databricks
Personal Information
Title: Senior Data Engineer | Oracle Data Integrator Specialist (ODI) | Business Intelligence Analyst
Timeline
Senior Data Engineer
Artycs.ai
09.2023 - Current
Senior Data Engineer
Stefanini Brasil
09.2021 - 09.2023
Business Intelligence Analyst
COAMO AGROINDUSTRIAL COOPERATIVA
07.2014 - 02.2021
Administrative Assistant
Fundo de Proteção à Saúde - FUPS
02.2007 - 06.2014
Postgraduate in Oracle Database Administration -
Faculdade Integrado
Technology in Analysis And Systems Development -
Faculdade Integrado
Similar Profiles
Aranza VilledaAranza Villeda
Document Management Specialist at The First State BankDocument Management Specialist at The First State Bank
Alanna TiesoAlanna Tieso
Deli Manager at Mary's DonutsDeli Manager at Mary's Donuts
Tatiani Souza Sandim MartinTatiani Souza Sandim Martin
Auxiliar administrativo at Hospital Adventista do Pênfigo HAP Centro de Vida Saudável SPA CVSAuxiliar administrativo at Hospital Adventista do Pênfigo HAP Centro de Vida Saudável SPA CVS