Summary
Overview
Work History
Education
Skills
Professional Affiliations Certifications
Foreign Language Skills
Timeline
Generic

Hector Solis

ETL Data Engineer
Zapopan

Summary

Senior ETL developer with experience in analysis, design, development, implementation, testing and support of Data Warehousing and Data Integration solutions. Proficiency in developing SQL with various relational databases like Snowflake, Oracle, SQL Server. Experience working with Cloud Solutions like Azure and AWS.

Results-driven data engineering professional with solid foundation in designing and maintaining scalable data systems. Expertise in developing efficient ETL processes and ensuring data accuracy, contributing to impactful business insights. Known for strong collaborative skills and ability to adapt to dynamic project requirements, delivering reliable and timely solutions.

Overview

2026
2026
years of professional experience
4
4
years of post-secondary education

Work History

ETL Data engineer

US automotive company
- Current
  • Working as an ETL data engineer with SQL/Snowflake
  • Azure Data Factory implementation
  • ETL job orchestration using Redwood RMJ
  • Constant support to the pipelines
  • Agile methodologies used during the whole project
  • Migration to Apache Airflow
  • Technical Environment: Snowflake, Azure data factory, Redwood RMJ, Airflow

Snowflake Data Lead / Engineer

US Mining company
  • Working as an ETL data engineer with Snowflake
  • Azure integration
  • Team Lead for a Snowflake IoT (sensor) live stream project
  • Migration of ETL jobs into Snowflake logic
  • ETL logic implementation using snow pipe, external stages, tasks, etc
  • Reduced the auto clustering cost of the company by 80%
  • Constant support to the pipes and streams
  • Constant integration with Power BI users
  • Agile methodologies used during the whole project
  • Usage of PISQL and PI explorer for sensor hierarchy
  • Technical Environment: Snowflake, Azure, PISQL, Redwood

ETL specialist

Multinational health care company
  • Gathered and analyzed the requirements of the in-house business users for the data warehousing
  • Designed staging and error handling tables keeping in view the overall ETL strategy
  • Develop, test, analyze, upgrade, and maintain data models and processes in an ETL environment using DataStage 11.5
  • Application migration from DataStage 11.5 to 11.7
  • Developed ETL programs using Data stage to implement the business requirements
  • Created shell scripts to fine tune the ETL flow of the DataStage workflows
  • Reviewed and analyzed functional requirements, mapping documents, problem solving and trouble shooting
  • Hands on experience with Cloud Solutions (AWS)
  • Agile methodologies used during the whole project
  • Technical Environment: DataStage 11.5/11.7, AWS (s3, athena, lambda), Snowflake, Oracle DB, Unix, Control M

ETL senior developer

Financial services group of companies
  • Company Overview: offering banking, investing, and insurance to people and families who serve, or served, in the United States Armed Forces
  • Created DataStage jobs using different stages like Transformer, Aggregator, Sort, Join, Merge, Lookup, Data Set, Funnel, Remove Duplicates, Copy, Modify, Filter, Change Data Capture, Change Apply, Sample, Surrogate Key, Column Generator, Row Generator, Etc
  • Used the Data Stage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions on ad hoc or scheduled basis
  • Creation of jobs sequences
  • Maintained Data Warehouse by loading dimensions and facts as part of project
  • Created shell script to run data stage jobs from UNIX and then schedule this script to run data stage jobs through scheduling tool (Control M)
  • Worked with Agile Methodologies, having daily scrum calls (Daily Stand ups)
  • Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis
  • Implemented slowly changing dimension methodology for accessing the full history of accounts
  • Work with Architects to create meaningful requirements for Data Warehouse ETL development
  • Offering banking, investing, and insurance to people and families who serve, or served, in the United States Armed Forces
  • Technical Environment: DataStage 11.3, Informatica Power Center, Control M, Unix shell script, Netezza, Oracle, RTC, Agile, Business Objects, Apache Hive

Education

Bachelor of Mechatronics engineering -

Instituto Teconologico de Veracruz
01.2010 - 01.2014

Skills

  • DataStage Development Experience

  • Informatica ETL Development

  • Matillion Workflow Optimization

  • Cloud Solutions with AWS

  • Control M Experience

  • Cloud Data Pipeline Development (Azure factory)

  • Version Control Expertise

  • Data Visualization Tools

  • Data Pipeline Management Skills

  • Data Integration Development

Professional Affiliations Certifications

AWS Cloud Practitioner Certification

Foreign Language Skills

  • English, Fluent in business
  • Spanish, Native
  • Japanese, Basic
  • German, Basic

Timeline

Bachelor of Mechatronics engineering -

Instituto Teconologico de Veracruz
01.2010 - 01.2014

ETL Data engineer

US automotive company
- Current

Snowflake Data Lead / Engineer

US Mining company

ETL specialist

Multinational health care company

ETL senior developer

Financial services group of companies

Similar Profiles

CREATE PROFILE
Hector SolisETL Data Engineer