Pablo G.
Professional Summary
14 yrs of overall experience in the IT Industry specializing in Microsoft SQL Server and data platform technologies and has been a Data Engineer since 2014. 5+ years of experience designing and delivering cloud-based data solutions on Microsoft Azure, including Azure Data Factory, Azure Data Lake, Azure Analysis Services, Azure Synapse Analytics (SQL Data Warehouse), Azure Blob Storage, Azure Storage Explorer, and Azure Logic Apps.Strong background in ETL design and development using SQL Server Integration Services (SSIS), creating workflows and mappings to extract, transform, and load data from Oracle, Access, flat files, and other heterogeneous data sources.
Develop metadata-driven pipelines in Azure Data Factory to dynamically orchestrate API integrations and automate ingestion workflows across multiple endpoints. Build logic within Azure Data Factory pipelines to capture, parse, and store API responses, enabling their reuse as inputs for subsequent API calls in multi-step integrations.Implement error handling and response validation mechanisms in Azure Data Factory pipelines, Develop generic pipeline templates to standardize ingestion patterns and reduce development time across multiple data sources, integrate ADF pipelines with Azure Key Vault to securely manage credentials, API keys, and connection strings. Experience migrating SSIS packages to Azure Data Factory. Some experience developing C#/VB.NET scripting for SSIS packages, among other experience.
Develop metadata-driven pipelines in Azure Data Factory to dynamically orchestrate API integrations and automate ingestion workflows across multiple endpoints. Build logic within Azure Data Factory pipelines to capture, parse, and store API responses, enabling their reuse as inputs for subsequent API calls in multi-step integrations.Implement error handling and response validation mechanisms in Azure Data Factory pipelines, Develop generic pipeline templates to standardize ingestion patterns and reduce development time across multiple data sources, integrate ADF pipelines with Azure Key Vault to securely manage credentials, API keys, and connection strings. Experience migrating SSIS packages to Azure Data Factory. Some experience developing C#/VB.NET scripting for SSIS packages, among other experience.
Skills, Tools & Frameworks
- SQL Server
- Snowflake
- Azure Data Factory
- Microsoft Azure
- Azure SQL Database
- RESTful APIs
- ETL processes
Position (Role)
Data Engineering
Accomplishments & Activities
His most recent role involved designing highly sophisticated, metadata-driven pipelines for dynamic REST API integrations. Modernization Specialist: He has a proven track record of migrating legacy SSIS environments into modern Azure cloud architectures. Data Architecture: He is well-versed in “Medallion Architecture” (Bronze/Silver/Gold) and advanced data modeling.
Tools & Frameworks
Snowflake , SQL , Azure Data Factory, Microsoft Azure, Azure SQL Database, Restful APIs, ETL Processes
Education
Bachelor’s Degree in Computer Science. Durango Technological Institute 2007 – 201
Training & Certifications
Databricks Data Engineer Associate: ID119924696