09/27/2025 updated

**** ******** ****
100 % available

Cloud Data Engineer specializing in ETL/ELT pipelines and AWS services

Pontevedra, Spain Civil Engineer
Pontevedra, Spain Civil Engineer

Profile attachments

Diego_Llanos_Fajardo_-_Data_Engineer_English_2025-3.pdf

About me

Data Engineer specialized in AWS (Glue, Redshift, Lambda, Step Functions, S3) with Spark & Python. Expert in data lakehouse design for fintech & banking, ETL/ELT automation, IaC with Terraform/CloudFormation, and BI (Power BI, QuickSight). Trilingual (EN/FR/ES).

Amazon Web ServicesAmazon S3AutomationFinancial InstitutionBusiness IntelligenceCloud ComputingDatabasesData CleansingExtract Transform Load (ETL)Data ModelingData SystemData WarehousingInfrastructure ManagementPython (Programming Language)PostgreSQLMySQLPower BIReproducibilityApache SparkCloudformationAmazon Relational Database ServiceTerraformData PipelineDatabase AdministrationAmazon Redshift
AWS Cloud Infrastructure
Expertise in AWS services including Glue, Lambda, Step Functions, S3, Redshift, RDS, Athena, and EMR for building scalable data solutions and infrastructure as code with Terraform and CloudFormation.

Data Pipeline Development
Specialized in building scalable ETL/ELT pipelines with technologies like Spark and Python, enabling both batch and near real-time processing for financial institutions.

Data Warehouse Architecture
Experience designing data lakehouse architectures with bronze, silver, and gold layers, optimizing Redshift workloads, and implementing star-schema data warehouses for analytics.

Business Intelligence
Implementation of Power BI and QuickSight dashboards for advanced analytics and data-driven decision-making across various business domains.

Python Development
Creation of Python-based automation scripts for data cleansing, ETL processes, and executable applications for on-demand control.

Infrastructure Automation
Deployment of infrastructure through modularized Terraform and AWS CloudFormation, ensuring scalable, reproducible, and version-controlled environments.

Database Management
Experience with multiple database systems including PostgreSQL, MySQL, and designing optimized data models for various applications.

Languages

EnglishFluentFrenchGoodSpanishNative speaker

Project history

Cloud Data Engineer (freelance)

Banking Client
Deployed AWS DMS services to replicate data from PostgreSQL into S3, designed governance with AWS Lake Formation to manage Glue Data Catalogs across bronze, silver, and gold layers. Engineered Glue Jobs with Spark for large-scale transformations and automated infrastructure provisioning through Terraform.

Cloud Data Engineer (freelance)

Fintech Client
Designed and implemented scalable ETL/ELT pipelines in AWS using Glue, Lambda, and Step Functions. Built a data lakehouse architecture with Aurora, DMS, S3, Glue, and Redshift. Optimized Redshift workloads and automated infrastructure deployments with AWS CloudFormation.

Data Engineer and Chief Data Officer

Skalo Tek
Automated financial reporting with end-to-end ETL pipelines using Bloomberg API, Python, AWS services, and Power BI. Developed an AI-powered proposal generator with Azure Bot and created real-time financial analytics solutions with Python-driven ETL into MySQL.

Portfolio

item-0

Banking solution

This is a Data Lake a design for one of my baking clients in Paraguay, this a data lake that uses apache Iceberg and its also attached to a redshift cluster to analyze data from quicksight.
item-1

Batch and streaming ETL Pipeline

This is a batch and streaming data pipeline I design for a fintech client that wanted to analyze data for his clients where some of them had access to real time analysis depending on their client tier.

Contact form

Log in to get in touch

You need to be logged in to use the contact form.

Sign upLog in