Creating, updating and maintenance of complex ETL jobs using Informatica Powercenter for Health Insurance Data Warehouse project. Analyzing and Improving Performance Tuning of ETL jobs, optimization, and troubleshooting. Technical requirements research for creating new Data Marts. • Building semantics layers on SAP - BO. • Dimensional Data Modeling.

Teradata database administration, Teradata Active System Management (Workload Manager) configuration, backup job configuration, Datalabs administration, QueryGrid definition for SQL Server access from Teradata database.Creation of Stored Procedures for Teradata statistics collection automatically based on DBQL database logs.• Support in multidimensional data modeling and physical table modeling in Teradata database. • Tuning ETL processes using Informatica Powercenter and supporting the ETL development team• Primary Index analysis and suggestion, query enhancement (SQL), and support for full and incremental load strategy definition.• Workshop presentation on TPT loading utilities (TPT LOAD, UPDATE, STREAM), Teradata architecture and ETL best practicesDeveloping procedures and scripts for data migration.• Index analysis and suggestion, query enhancement(SQL) , and support for full and incremental load strategy definition.

Participation in the Data Warehouse Project of the Environmental Sanitation Company of the Federal District - CAESB, which aimed to combat fraud in irregular water connections and better management of the water meters park installed and in stock. Activities performed: creation of load scripts (ETL) using BTEQ and TPT.Participation in the Federal Highway Police Project - PRF. I worked as a Teradata DBA and as an ETL developer using Informatica PowerCenter. I was responsible for administering the Teradata environment, which included creating the basic work structure, creating and maintaining user and permissions. Physical modeling. ETL process tuning using Powercenter API, TPT, FastLoad, Multload, TPump(Stream).Participation in the BACEN project, acting as a DBA in an environment with more or less 50 TB of data. Also working with query tuning and project support with powercenter (ETL). Also responsible for the backup using the Teradata Backup and Restore solution - BAR with Netbackup.And yet, acting in the administration of the data replication environment called Teradata Unity configured with two active/active sites.

Caixa Econômica Federal CRM project. Database: Oracle. ETL tool: Powercenter. Performed activities: Oracle database tuning, data modeling adjustments, table partitioning adjustments, query review, creation of stored procedures, functions, map adjustments, sessions and workflows. All of this aimed at improving performance in the loading process.

Creation of stored procedures to load in DW. Creation of reports using Oracle Business Intelligence - OBIEE.

Creation of mapping for data integration using the OWB - Oracle tool.

Database administrator (SQL Server)

Creation of PL/SQL codes for the disconnected module of the Fomento project at Banco da Amazônia