Want to hire this engineer?
Check if Rodrigo is availableExpertise
Years of commercial development experience
5 years of experience
Core technologies
Other technologies
Project Highlights
Calix
Jul `22 - Aug `22
Red Pill Analytics
Replicated all data from required sources into Google Big Query with Stitch. ● Used DBT to transform required data from the replication layer stage datasets into the data warehouse EDW dataset in Google Big Query. ● Built automated and regression testing using DBT to validate foreign key relationships, unique keys, not null tests. ● Utilized dbt hooks to remove deleted records from the EDW dataset. ● Utilized dbt utils package to add more functionalities in the project ● Utilized dbt snapshots to track data changes with snapshots using SCD (Slowly Change Dimensions)
Responsibilities & achievements
Migrating SEO data from Google Analytics to Big Query and transform data for a final view for the Google data Studio consume
Facet Wealth
Aug `19 - Nov `19
3 months
Red Pill Analytics
● Designed a Star Schema data model for a multitude of sources (advisor suite, zoom, quickbooks, stripe, etc). ● Replicated all data from required sources into BigQuery Stage DataSet ● Used DBT to transform required data from the replication layer stage datasets into the data warehouse EDW dataset in Google BigQuery. ● Built automated and regression testing using DBT to validate foreign key relationships, unique keys, not null, and several custom tests. ● Utilized DBT hooks to remove deleted records from the EDW dataset
Responsibilities & achievements
Migrating Financial Data into Google Big Query using SQL Scripts and DBT to create new Data Visualization for the client. Gathering information and new requirements during the Standup meeting
Education
Higher education in Computer Science
Agency
400+
GMT-3
Sao Paulo, Brazil
Core Expertise
Industries
Architecture & Design, Banking & Finance, Blockchain & Cryptocurrency, Big Data, Branding, design, web development
Want to hire this engineer?
Check if Rodrigo is available