Eneco

Sr Data Warehouse Engineer 

Kramp

•	Design a Domain-Driven Data Architecture using Data Mesh.
•	Implement a Self-Serve Data Platform with GBQ, DBT, Striim and Tableau. 
•	Design Conceptual and Logical Data Models.
•	Support Data Engineers and Data Analysts in creation of Data Pipelines following best practices and proper naming conventions.
•	Develop, improve, and maintain enterprise data asset inventories, including the creation and maintenance of Business Glossary, data dictionaries, metadata, and data lineage information to improve data understanding and governance using Collibra.
•	Expand data governance across a diverse set of data stewards to ensure consistent processes and outcomes by changing organizational behaviors, developing policies and standards.

Lead Data Engineer

Xseed Solutions

• Lead the Implementation of the Datawarehouse.
• Define Data Architecture.
• Lead and execute Data Development process, such as: 
  - Data Ingestion in real-time from AWS Aurora MySQL, Salesforce and Hubspot to Snowflake using Stitch.
  - Data Transformations using DBT and Snowflake.
  - Data visualization for Customer and Internal Reports using Looker and Apache Superset

Lead Data Engineer 

•	Lead the Data Engineers Team, managing them on a day-to-day basis and supporting their professional growing. 
•	Collaborate with Business Areas Team leads to define data requirements and deliver solutions with a focus on continuous improvement. 
•	Lead on the daily development work of Data Warehouse, designing and implementing - Data Architecture, - Data Models, - Data Pipelines, and - Data Tests Cases. In addition, participate Data migration from on-premise solutions to Google Cloud Platform. 
•	Enjoy the team work, learning from the challenges and celebrating the successes.

Technical Lead Business Intelligence

Globant

Implementing the Datawarehouse for the Inter-American Development Bank and The Walt Disney Company, using mainly Teradata and IBM DB2:

•	Gathering requirements and translation to technical specifications to be sent to the Development Team.
•	Building ETL's to load data from Data Sources to Dimensional Models using Teradata and Python.
•	Design solutions to automate the data flow through all the data Layers.
•	ETL/SQL optimization in the Production environment

Senior Software Designer Business Intelligence

Teradata

•	Create the Functional Mapping between data sources and the Business Data Model.
•	Support business users in Acceptance Testing.
•	Design strategy for DWH data ingestion, considering types of sources, volume, frequency of extraction and load and history. 
•	In charge of 5 developers whose objective was to develop extract process, executing load process to the DWH and helping in the system testing.
Work with the Customer Project Manager to improve the working methodology between the two teams (TD and Customer) and to have more effective results.

Technical Leader at TERADATA for TELEFONICA COLOMBIA

•	Define the Project Architecture considering the use of Agile Frameworks such as Scrum, Kanban and Teradata Agile.
•	Technically lead the implementation of the DWH CRM to the Interbank Bank.
•	In charge of 4 developers whose functions were the Understanding of Functional Requirements, implementation of ETL's and execution of Unit tests.
•	Partial Scrum Master, teaching the team the principles of Teradata Agile and Scrum.

Technical Leader at TERADATA for INTERBANK PERÚ

•	Maintenance of the DWH in SURAMERICANA Seguros and EPS.
•	Generate reports in Excel for different health entities from the information loaded in the DWH.
•	Improve the quality of DWH data, with activities such as data profiling, data integrity validation, and monitoring uploaded data through row counts at various levels.
•	Optimization of queries to improve response times of dashboards built with MicroStrategy.

PS Consultant at TERADATA for SURA COLOMBIA

•	Participation in all phases of the implementation of a "Unified DWH" for Telefónica Movistar at the Regional level (Colombia, Peru, Argentina, Chile, Brazil, Venezuela, and Ecuador):
• Requirements Analysis
• Design technical specifications of load processes
• Develop extraction, transformation and load processes using DataStage and SQL
• Support in data modeling.

PS Consultant at TERADATA for TELEFONICA ESPAÑA

ETL Leader 
•	Lead migration project of over 1500 DataStage 8.1 to 8.5 jobs and 200 DB2 Database SPs to TERADATA 14.00 Database, working with a team from the Philippines.
•	Improve loading process times and queries with a 60% improvement. It was possible to create an adequate ETL design, improving queries and parallelizing workloads.

PS Consultant at TERADATA for HSBC ARGENTINA

•	Participation in all phases of the implementation of a DWH for Telefónica Movistar Colombia and Telefonica Telecom Colombia:
• Requirements Analysis
• Design technical specifications of load processes
• Develop extraction, transformation and load processes using DataStage and SQL
• Support in data modeling.

PS Consultant at TERADATA for Telefonica MOVISTAR/TELECOM Colombia

Escuela Colombiana de Ingeniería Julio Garavito

• Support laboratory users.
• Implement software applications for the lab using Java and HTML.
• Support students in Mathematical Logic classes.

Academic Facilitator

Lead Data Engineer with more than 15 years of experience across Data Management areas such as Data Modeling, Data Warehousing and Business Intelligence, and also important experience in Data Architecture and Data Governance.
Detail oriented with strong time management and organizational skills. Effective in building trust, respect, and cooperation among teams.

TECHNICAL SKILLS:
Database: 
Google Big Query, Snowflake, Teradata, Neo4j, Oracle, Apache Pinot

Data Transformation: 
SQL, DBT, SnowPipe, Stitch, DataStage, Wherescape, Census, Teradata Utilities, Shell Scripting, Python, Cypher
	
Data Modelling: 
Data Vault, Kimball and Inmon

Data Visualization: 
Looker

Data Governance: 
Collibra

CI/CD: 
GitHub, Bitbucket

Orchestration: 
Apache Airflow

Project Management: 
Jira (Scrum)

LANGUAGES:
- Spanish (Native)
- English (Professional)
- Portuguese (Professional)

Taplio

Diego A. Cortés J.'s Linkedin Analytics

Want to drive more opportunities from LinkedIn?

Taplio

.css-1jgreyo{background-image:linear-gradient(284deg, rgba(39,43,72,1) 0%, rgba(33,47,183,1) 100%);color:transparent;-webkit-background-clip:text;background-clip:text;}Diego A. Cortés J.'s Linkedin Analytics

Want to drive more opportunities from LinkedIn?

Diego A. Cortés J.'s Linkedin Analytics