Irving DIAZ
Data Architect & Engineer
+33 783 90 29 03
Email:
Address:
Courveboie, Paris 92400
Phone:
CERTIFICATIONS
Microsoft
Azure Data Engineer
Microsoft
Azure Database Administrator
Microsoft
Microsoft SQL Server Database Development
Microsoft
Microsoft SQL Server Implementation and maintenance
Open Intelligence
PostgreSQL
Microsoft
Microsoft Certified Professional
EXPIRIENCE
Cloud Data integration project leader
2019-2022
FORVIA
Proven expertise in designing and implementing data integration solutions that enable efficient data management, processing, and analysis within complex modern data ecosystems. Adept at leveraging cloud-based resources and open-source tools to drive data-driven insights and empower organizations with scalable, performant, and cost-effective data solutions.
2015-2019
FAURECIA
Senior Big Data Engineer
Big Data Engineer with a strong experience in data digital transformation. I have a proven expertise in variety of big data lakehouse platforms includes data processing, real-time data ingestion & analytics, end-to-end data pipelines development & optimization and security management.
2007-2015
Database & Business Intelligence Expert
FINDEP
Data expert, responsible for the development and management different database architectures and Business intelligence business use cases, capable of transforming data into actionable insights with technical expertise and skills to code, implement and lead data projects
EDUCATION
Master's Degree
Tecnológico de Estudios Superiores
​Master degree Software engineering & Computer science
Bachelor's Degree
Universidad Tecnológica de Mexico
Computer science & Administration
SKILLS
Big Data
Palantir Foundry, Apache Spark, Hive, Impala, Kudu, Kafka, Nifi, Minifi, Dataiku, Airflow, Hadoop, ADLS2, Cloudera (CDP, CFM, CEM), Azure Databricks, Delta lake
Business Intelligence
#SSIS #SSAS #SSRS
Data Analytics
#Azure Synapse #Power BI #Azure Cognitive Services #Microsoft Intelligent Data Platform
Data Architecture
#Data Mesh #Data Driven #Data Gov #Cloud adoption framework #Data modeling #Data lakehouse #Data sharing
Azure Cloud
Azure Data Factory, Azure SQL Database, Azure DevOps, Azure for PostgreSQL,
Azure Cosmos DB for PostgreSQL (hyperscale), EvenHubs, Azure Databricks, Azure
Synapse Analytics, Azure Cognitive Services, Azure Datalake Storage Gen2, Azure Data Explorer, Azure Cache for Redis
Databases
SQL Server, SQL Edge, ORACLE, PostgreSQL, SAP ASE, InfluxDB, Azure Cosmos DB
Languages
Spanish
English
French
Programming Languages
#Python #PySpark #T-SQL #SQL
EXPERTISE
Cloud Data integration project leader
Senior Big Data Engineer
Database & Business Intelligence Expert
Implement Data Governance best practices and Ontologies using data mesh architecture
Collect and ingest near real time data, from different and heterogenous data sources into Data Lake using Azure Data Factory and Azure Event Hubs
Migrate production data platform from on-premises to Azure Cloud
Delta data ingestion using Change Data Capture (CDC) for RDBMS to ADLS2
Develop data collection pipelines with Apache Nifi & Kafka and Spark transformations
Data migration from Cloudera to Palantir Foundry
Create and manage data flows for multiple use cases in Palantir Foundry such as industrial and purchasing data streams
IoT data collection from machines using Raspberry, Apache Minif -Nifi
Senior Database expert in high critical solving problems worldwide and data architecture solutions
Implement different database architectures and technologies
Troubleshoot database programing and query tuning.
Adapt different database architectures and solutions using NoSQL, structured and unstructured databases.
Adapting high availability (HA) standards to ensure the business continuity with Cluster Always ON, High availability groups (Mirroring), Log shipping and different replication technologies
Develop highly efficient stored procedures that maximize the resources in hardware consumption, with extensive experience in reading and improve query execution plans and its performance problems like deadlocks and blocking issues.
Maintain and updated standard documentation for database setups.
Migrate and upgrade production database environments on-premises
Develop backup standards and strategies to ensure data recovery with native and 3rd party technologies
Data expert in structured and unstructured databases and Business Intelligence
Drive different data technologies such as Big Data, Business Intelligence, NoSQL, Graph, In-Memory, Columnar, Documental key value , RDBMS, JSON and OLAP databases solutions on premises and in Azure Cloud
Modeling relational and multidimensional databases to maximize the investment in technology infrastructure
Establish procedures to monitor critical processes, skilled to discover problems and suggest preventive corrections.
Implement mechanisms to ensure the security of the information TLS, Certificates, TDE, data masking
ETL that allow interoperability between heterogeneous data sources with Sql Server Integration Services
Performance, optimization for highly transactional environments with large volumes of data
Database migration across heterogeneous databases ORACLE - SAP ASE - SQL Server on-premise and cloud
Develop Store Procedures, UDF, triggers, disectioning execution plans and Query tunning