Diego López Espinoza

Guadalajara

Summary

Data engineer 3 + years of experience, I overseen a small team of three people, I have experience in ETL, data analysis with international clients. Modernization, maintenance, update, and fixing of the processes used to ensure the delivery of required information on time and meeting client's expectations.

Professional with strong expertise in integrating complex systems and optimizing workflows. Proven ability to streamline processes, enhance system performance, and ensure seamless collaboration across multidisciplinary teams. Adept at troubleshooting, coding, and maintaining high technical standards, while remaining adaptable to evolving project requirements. Reliable team player focused on delivering tangible results and driving impactful solutions.

Overview

years of professional experience

Work History

Data Integration engineer

Apymsa

11.2024 - Current

Using SSIS to create packages to transform data and implementing the data in the database
SQL management studio to create jobs and schedule the execution of the packages
Merging and controlling different versions of the projects using Team Foundation (TFS)
Troubleshoot failure of the jobs and how the fixed them

Data engineer

Tata Consultancy Service

06.2021 - 11.2024

Use of Informatica Power Center for the creation, maintenance, and update of multiple jobs related to the creation of quarterly reports for insurance companies
Using Python with frameworks to transform data like pyspark and pandas
Control-M to schedule the insertion of the data
Direct communication with international business partners to review new requirements in the reports, necessary changes in the logic used to extract the information, new data structure, inquiries received, and so on
Use of agile methodology to display the status of the work assigned, impediments faced, and their resolution and documentation created
SQL, MySQL and PostgreSQL to transform and consulting data
Using snowflake to create virtual warehouse, staging, Scaling up and out and creations of pipelines for sources from S3 bucket and Azure Blob

Education

Bachelor's degree - nanotechnology engineering

University of Guadalajara

Guadalajara, Jalisco

01.2021

Skills

Good Communication
Adaptability
Research Methodology
Resilient
Problem Solving
Advanced Excel
Logical- Mathematics
Sociable
ETL
Troubleshooting
Testing
Ci/Cd
Data engineer
SQL
Unix
Control-M
Informatica Power Center
Python
Snowflake
Data Warehousing
Jira
DataStage IBM
C#
SaaS

Java
SSIS
TFS
SSMS
GitHub
PostgreSQL
Cloud
Troubleshooting skills
Problem solving
Effective communication
Business analysis
Data warehousing
Agile methodology
ETL processes
Data transformation
Data integration
Cloud storage
SQL querying
Data analysis
Communication skills
ETL development
Data pipeline design
Data modeling
Data migration

Languages

English

Timeline