About
My one-page resume.
Jaime MontoyaCondominio Los Castaños, apartamento 36, Colonia Escalón, San Salvador, El Salvador.
SUMMARY
Data engineer specialist in ETL integrations.
TECHNICAL SKILLS
- Languages: Scala, Java, PHP, Python.
- Databases: SQL, SQL Server, Oracle, MySQL, PostgreSQL, SQLite, Cosmos DB, MongoDB.
- Other: Git, GitHub, SSIS, Apache Spark, Apache Maven, Gradle, sbt, CI/CD with Jenkins, Apache Airflow, HTML, CSS, JavaScript.
EXPERIENCE
TEAM International Services Inc. | Data Analyst | Remote | August 2022 - Present
- Integrated ETL processes to migrate data for merging systems between Republic Services, Inc. and its acquired companies.
- Created scripts to transform data from heterogeneous source systems (relational Oracle; cloud-based, and on-premises SQL Server databases; and text/JSON/Excel/CSV files) into destination systems.
- Performed data cleaning tasks using Fuzzy Lookup and Fuzzy Grouping transformations.
Applaudo Studios | ETL Developer | Remote | September 2020 - July 2022
- Orchestrated workflows with Apache Airflow to deploy big data migrations for Walmart Inc. data engineering projects.
- Created ETL processes in Scala to extract data from ORC files in Google Cloud Storage and load it into MySQL.
- Connected to JavaScript front-end APIs to display information to end users with data populated from back-end migrated environments.
- Migrated big data using Apache Hadoop, Apache Spark, and related family of technologies to process data on distributed storage systems.
- Connected modern Scala applications with legacy Java systems to refactor, migrate and upgrade source code for the migration of data sets classified as "Big Data".
- Collaborated using modern software development tools with large groups of developers from Walmart Inc. headquarters in Bentonville, Arkansas, and from around the world, using technologies such as Git, GitHub, Apache Maven, Gradle, sbt, CI/CD with Jenkins pipelines.
Cupón Club | Programmer | San Salvador, El Salvador | October 2016 - September 2020
- Implemented system of push notifications for an Android app using Firebase in Java.
ESEN | Systems Analyst (March 2011 - March 2013), Adjunct Lecturer (May 2017 - July 2017, January 2018 - July 2018) | La Libertad, El Salvador
- Taught Introduction to Databases, Excel VBA and Programming I.
Kodak Alaris | Software Intern | Rochester, NY | Summer 2014, 2015 and 2016
- Implemented transformations with SQL Server Data Tools to produce desired output data types for data migrated from Oracle transactional databases to SQL Server data warehouses.
- Created OLAP cubes in SSIS and ETL processes for business intelligence, analytics, and reporting applications.
EDUCATION
Rochester Institute of Technology | Master of Science in Information Sciences and Technologies | Rochester, NY | August 2013 - May 2016
- Fulbright Foreign Student Program Scholarship (flagship U.S. Department of State’s exchange program).
- GPA 3.87/4.0.
- RIT Graduate Merit Scholarship.
Loyola University Chicago | Fulbright Intensive English Program | Chicago, IL | March - August 2013
UNICAES | Bachelor of Science in Computer Engineering, Cum Laude | El Salvador | January 2005 - May 2011
- GPA 8.8/10.0 (Class rank: 1 out of a graduating class of 14).
University of Alabama in Huntsville | Global UGRAD Exchange Program | Huntsville, AL | August 2009 - May 2010
- Concentration in Computer Engineering.
- GPA 4.0/4.0.
- Global UGRAD Scholarship (U.S. Department of State’s exchange program).