Mario Picáns
Data Integration Engineer
Profile
Data Integration Engineer with a strong mathematical background, focused on designing and maintaining ETL processes in enterprise environments.
I work mainly on data integration and transformation, from requirements analysis and ETL design to testing, validation and production support, ensuring data quality and reliability across systems.
My approach is analytical and structured, combining technical implementation with a solid understanding of data and business needs.
Experience
Data Integration Engineer
Working on data integration projects in enterprise environments, mainly focused on the design, development and maintenance of ETL processes using Oracle Data Integrator (ODI).
My responsibilities include requirements analysis with stakeholders, ETL design and implementation, data validation and testing, as well as participation in UATs and production support.
I collaborate closely with other technical teams and business users, ensuring reliable data integration across systems in a large-scale energy sector project.
Data Analyst
Worked on the analysis of hospital datasets, focusing on data cleaning, processing and exploratory analysis using R.
Applied descriptive statistics and predictive modeling techniques, including generalized additive models (GAMs) and time series analysis, to support healthcare-related decision making.
This work was carried out as part of a research grant (“Bolsa Explora”) awarded by the Galician Center for Mathematical Research (CITMAga).
Skills
Data Engineering & ETL
- End-to-end ETL design and development using Oracle Data Integrator (ODI)
- Data transformation, validation and reconciliation processes
- Production support, corrective actions and ad-hoc SQL fixes
- Direct interaction with business stakeholders (UFD / Naturgy)
Databases & Analytics
- Advanced SQL (Oracle)
- Data modeling for analytical use cases
- Data analysis with R (dplyr)
- Descriptive statistics and exploratory data analysis
Statistical Modeling
- Predictive modeling using Generalized Additive Models (GAMs)
- Time series analysis applied to healthcare data
- Hospital occupancy and length of stay forecasting
Cloud & Tools
- AWS fundamentals (Cloud Practitioner level)
- ETL concepts with AWS Glue
- Git (basic workflow)
- Visual Studio Code, Excel
Education & Certifications
MSc in Statistical Techniques
Advanced training in statistical modeling, data analysis and inference, with a strong focus on applied statistics and real-world data problems.
BSc in Mathematics
Solid mathematical foundation covering analysis, algebra, probability and statistics, providing a rigorous analytical background for data-related work.
Contact
- Email:
- LinkedIn: linkedin.com/in/mariopicans
Why this website?
This website is a concise and curated overview of my professional background. While platforms like LinkedIn focus on visibility and networking, this space allows me to present my profile in a more deliberate and structured way.