Sign in

Data Analyst

Toronto, ON, Canada
September 03, 2019

Contact this candidate


Caio Corrêa

BI Developer



Professional with 8+ years of experience on IT. 6 years background in Data Integration, Business Intelligence and Data Quality projects;

6 years of experience with the Informatica PowerCenter Suite (9.0.1 to 10.2);

Data Integration specialist with excellent problem solving skills.

Post-graduation and longtime experience on BI/DW. Dimensional and relational modeling, ETL and dashboard development. Knowledge about Business Intelligence concepts, from its goals to its implementation through Data Warehousing, semantic layer and Dashboard creation;

Mastery on mapping development, mapplets, workflows and worklets on Informatica PowerCenter and Control-M flow development and runs;

Data visualization tool skill and experience (Microstrategy).

Strong SQL Scripting skills (MS SQL Server, Oracle, MySQL);

Experience on Informatica Data Quality projects, profiling and rule development and managing reference tables on Informatica Analyst tool;

Proven skills managing Informatica environments, troubleshooting and security through Informatica Administrator console;

Data Warehouse (BI DW) semantic layer development, BI and data discovery dashboard development (Microstrategy);

Background with Informatica Test Data Management creating data subsets of large database models;

Ability to work with Unix, Linux and Windows environments.

Ability to work in a collaborative team with oral and written communication skills;

Legally eligible to work in Canada - Permanent Resident


ETL Analyst 2018 - 2019

First Decision, Brasília, Brazil

History: First Decision hired me to join a team of professionals responsible for resolving defects in some production environment systems, from workflow run errors to incorrect data present on the Data Warehouses. This position was in one of the most important Banks in Brazil, CAIXA Econômica Federal.

-ETL processes documentation analysis and working with business groups to understand the system requirements in order to identify what are the possible failures the implemented ETL process.

-ETL support with mapping debugging, troubleshooting and tuning in a daily basis.

-SQL scripting to identify process issues and solutions.

-Multi-dimensional data flows development and maintenance.

-Informatica PowerCenter Workflow and Mapping development with Shell Scripting.

-I taught Informatica Power Center in a in-house course to the First Decision's analysts to increase their knowledge about the tool and Data Warehousing concepts, address doubts and improve their troubleshooting.

-ETL flows development and maintenance, connecting different sources and exploring many transformations such as cleanse and standardization transformations.

System Analyst – Data Integration and Quality 2017 - 2018

Atra Informatica, São Paulo, Brazil

History: Atra Informatica hired me to act on a Data Integration project at the second largest Educational Company in Brazil, SER Educacional, enabling it to incorporate data from university acquisitions.

-Work with business groups to understand data integration needs and prioritize them, gather requirements and to translate them into technology requirements.

-Informatica PowerCenter Development and Consulting.

-Management of reference tables through Informatica Analyst tool to help users identify and specify changes on specific table IDs.

-Table profiling with rule definitions on main tables in order to identify data quality issues.

-Data cleansing mapplets development on IDQ.

-SQL scripting and workflow runs management.

-Work with MS SQL Server, queries and ETL tuning for Optimization.

System Analyst – ETL 2016 - 2017

TGV Tecnologia, Brasília, Brazil

History: TGV Tecnologia hired me to work on a Business Intelligence project at one of the largest banks in Brazil, CAIXA Economica Federal. I was responsible for the ETL flows of a BI project developed to help identify the possible fraud sources on habitational financing.

-Working with business groups to identify needs, gather requirements and to translate them into documents and PowerCenter mappings.

-Informatica PowerCenter ETL Development and Consulting. Dimension and Fact load flows development.

-SQL scripting and workflow runs management.

-Work with MS SQL Server, queries and ETL tuning for Optimization.

-Collecting information from customer and creating Functional and Technical specification.

Business Intelligence Analyst 2015 - 2016

Workforce/ DWL Tecnologia/ SEA, Brasília, Brazil

History: I was hired to join on a Business Intelligence team at ANVISA, the National Sanitary Surveillance Agency. The team was responsible for Data Warehouse built, dashboard development and the Microstrategy environment maintenance.

-Working with business groups to identify needs and gather requirements to the development of new dashboards.

-Survey dashboard development to inquire certain statistics about innumerous laboratories over the country using Microstrategy transaction services.

-Relational database design to receive data provided by surveys.

-Microstrategy and Informatica environment maintenance and user support.

-ETL process development using Informatica PowerCenter.

-Semantic Layer development on Microstrategy.

-Providing assistance on ETL, Dashboard and semantic layer development on BI projects using Informatica PowerCenter and Microstrategy.

-Oracle procedure development and scheduling with PLSQL.

-I taught a workshop showing how to use Microstrategy Visual Insight, importing metadata and creating dashboards to extract information.

System Analyst – Data Integration and Quality 2013 - 2015

TGV Tecnologia, Brasília, Brazil

History: I was hired to act as a consultant in various projects on government agencies involving the usage of the Informatica suite tools. Often focused on learning and developing data integration processes with Informatica PowerCenter, I also learned and developed many other skills while studying and working with data quality and test dataset creation tools.

-Informatica products consulting.

-Data Integration mapping development on government agencies.

-Development and deploy of quality indicators to help companies identify and perform actions to improve database integrity.

-Development of data quality mappings and mapplets on Informatica Developer.

-Work with documentation doing Technical, Logical and Physical documentation, also "how to" documents regarding Informatica PowerCenter, Data Quality and Test Data Management.

-Troubleshooting the workflow runs and environment managing with Informatica Administrator console.

-ETL flows development and maintenance, connecting different sources and exploring many transformations such as cleanse and standardization transformations.

-Perform Software Presentation, Workshops and guidance classes.

-Data profiling and rule development on Informatica Data Quality. Identification of flaws in corporative data and creation of scorecards to help improve it.

-SQL Databases querying and scripting (Oracle, MS SQL Server, MySQL).

-Development and deploy of data subsets with the Informatica Persistent Data Masking and Data Subset Tool. (TDM - Test Data Management).


Post-Graduation in Business Intelligence and Database 2015

Faculdade Senac, Brasilia, Brazil

Bachelor's degree in Computer Engineering 2013

UniCEUB, Brasilia, Brazil

English Language - IELTS Overall Band Score 8 2018

Listening 8 Reading 8 Writing 8 Speaking 7.5

Contact this candidate