Personal details

Guilherme P. - Remote data engineer

Guilherme P.

Based in: 🇧🇷 Brazil
Timezone: Brasilia (UTC-3)

Summary

Data Engineer & AWS Certified Solution Architect. Holds a BSc degree in Electrical and Computer Engineering from UFMG. Interested in cloud computing, big data technologies and helping companies to get business value from their data.

Work Experience

Senior Data Engineer
Blue Orange Digital | Oct 2022 - Present
PostgreSQL
Amazon S3
Paperclip
Dbi
Terraform
AWS Lambda
Snowflake
Aws Fargate
GitHub Actions
AWS (Amazon Web Services)

∙ Design and implement data architectures on AWS to efficiently process and store large volumes of data from US residential IoT devices including thermostats and door locks.
∙ Design, construct, and oversee a data pipeline responsible for capturing data changes (CDC) from numerous Postgres databases and transferring them to Snowflake through AWS DMS and S3, while ensuring ongoing maintenance.
∙ Utilize technologies such as dbt, Snowflake, Terraform, AWS Lambdas, DMS, Glue, GitHub actiosn and AWS ECS Fargate to build scalable and fault-tolerant data pipelines.

Data Engineer
Iti Itaú Unibanco | Jan 2021 - Sep 2022
Python
Amazon S3
Apache Spark
Terraform
AWS Lambda
AWS Kinesis
AWS EMR
Aws athena
Aws glue

∙ Maintained and improved the Iti Itaú data platform on AWS.
∙ Built data pipelines to process, enhance, and store real-time JSON events generated by multiple microservices.
∙ Created data pipelines for real-time credit analysis.
∙ Utilized Python, PySpark, Terraform, AWS S3, AWS EMR, AWS Lambda, AWS Athena, AWS Kinesis, and AWS Glue in this role.

Education

Federal University of Minas Gerais
Bachelor's degree・Electrical and Computer Engineering
Jun 2012 - Dec 2018
Eastern Washington University
Bachelor's degree・Electrical and Computer Engineering
Mar 2014 - May 2015

Personal Projects

Joining and Enriching Multiple Sets of Streaming Data With Amazon Kinesis Data Analytics (KDA)IconOpenNewWindows
2022
AWS Lambda
AWS Kinesis
A demo data pipeline to showcase how Amazon Kinesis Data Analytics service is powerful for real-time data processing
dbt deployment — Deploying dbt on ECS Fargate through Github Actions: A comprehensive GuideIconOpenNewWindows
2023
GitHub Actions
DBT
AWS (Amazon Web Services)
A demo CI/CD pipeline designed to showcase the deployment process of a dbt project on AWS ECS Fargate through GitHub Actions

Certifications & Awards

AWS Certified Solutions Architect – Associate
AWS | Jul 2020