Open to opportunities

Esteban Castro

@estebancastro

Message

Data engineer specialized in ETL and big data pipelines using PySpark and DBT.

Chile

Message

What I'm looking for

I seek roles building and optimizing ETL and data warehouse systems within collaborative, growth-oriented teams where I can apply PySpark/DBT expertise and drive measurable performance improvements.

I am a proactive and curious programmer with a strong background in data engineering, ETL development, and business intelligence. I have led projects and contributed as a senior developer on global teams, delivering high-quality results focused on customer needs.

Currently I maintain and develop features for a data warehouse using PySpark and DBT on AWS Databricks, and I continuously optimize table performance. Previously, I designed and supported Big Data ETL workflows on Cloudera using Pentaho, gaining hands-on experience with large-scale data platforms.

I have also led a small development team building web applications in C# (Entity Framework, MVC4) and PHP (CakePHP), designed databases for analysis, and implemented reporting with the Pentaho suite. I communicate in Spanish and English and hold practical expertise across multiple databases and orchestration tools.

Experience

Work history, roles, and key accomplishments

Current

Data Engineer

Current

Modernizing Medicine, Inc.

Feb 2022 - Present (4 years 4 months)

Maintain and develop features for the data warehouse using PySpark and dbt on AWS Databricks, and improve performance of existing tables to support analytics and reporting.

Pyspark DBT Databricks AWS Data Warehousing Performance Tuning SQL ETL Scrum

Senior ETL Developer

Experian

Jul 2017 - Feb 2022 (4 years 7 months)

Designed, developed and supported Big Data ETL workflows on a Cloudera cluster using Pentaho Data Integration, collaborating with a global team to deliver reliable data pipelines.

Pentaho Cloudera Big Data ETL Hive SparkSQL SQL Data Pipelines Scrum

Project Leader

Zen

Aug 2010 - Jul 2017 (6 years 11 months)

Led a team of developers to deliver BI and web applications using C#, CakePHP and Pentaho; designed ETL workflows, databases for analysis, and reporting/embedded analytics solutions.

Entity Framework PHP CakePHP Pentaho Database Design Reporting C#