Ioannis TSOLKAS

– Data engineering and ETL development for the Belgian Federal Agency for the Safety of the Food Chain. – Responsible for maintaining and developing data pipelines using Informatica PowerCenter. – Led enterprise data governance strategy using DataGalaxy: established data dictionaries, authored metadata cataloguing standards, and built the organisation's knowledge management framework covering data lineage, business glossary, and governance workflows. – Documented end-to-end data lineage from source systems through warehouse layers, ensuring traceability and alignment with regulatory data quality and privacy requirements. – Acted as analytical liaison between business stakeholders and the data engineering team, translating reporting requirements into functional data specifications and ETL transformation logic. – Led root cause analysis for data quality incidents and pipeline failures, producing resolution documentation and preventive recommendations. – Defined and executed test plans to validate warehouse outputs against business-defined specifications for regulatory reporting.

– Short-term contract supporting Informatica PowerCenter development at the European Organisation for the Safety of Air Navigation.

– Data engineering and ETL development supporting FedEx logistics data infrastructure in the Brussels region.

– Technical management of data applications and ETL processes within one of Belgium's largest banking institutions. – Overseeing Informatica PowerCenter environments and data integration solutions.

– Senior Informatica PowerCenter development for Belgium's leading telecommunications company. – ETL development, data warehousing, and BI solutions.

– Technical lead for Informatica PowerCenter at one of the Netherlands' largest banks. – Specialised in Informatica Data Quality and Informatica Metadata Manager. – Used Informatica Metadata Manager for metadata cataloging, data lineage tracking, business glossary management, and governance workflows across enterprise data assets. – Led ETL development teams and architectural decisions for data warehousing projects. – Collaborated with business stakeholders to elicit data requirements and translate them into logical data models and DWH integration specifications. – Authored data mapping documents and functional specifications covering data lineage, transformation logic, and KPI definitions for financial reporting. – Defined UAT test plans and validated warehouse data against business-defined rules, ensuring accuracy of regulatory and management reporting outputs.

– Senior Informatica PowerCenter developer for the global healthcare multinational. – Data Vault implementation – designing and building data warehouse solutions using Data Vault methodology. – Translated complex healthcare business requirements into detailed data mapping documents and functional specifications for Data Vault Hub, Link, and Satellite structures. – Performed SQL-based data profiling and quality assessments on source systems to validate integration assumptions and business rules prior to warehouse loads.

– ETL Architect for the Connect project, part of Solvency II regulatory compliance programme. – Designed and implemented ETL architecture for complex insurance data requirements.

– Development of LOTOS DATA ANALYST modular data warehousing solution for Lotteries, comprising an ETL tool, data repository, and reporting tool. – Pre-sales, budgeting, and RFP (Request for Proposal) management. – Team management and technical leadership of the DWH team. – Elicited and documented business requirements from international lottery clients, translating operational needs into data warehouse specifications and KPI definitions. – Performed SQL analysis and data profiling on source systems to validate business rules and assess data quality ahead of warehouse integration. – Leveraged SAP Sybase IQ as the analytical database engine underpinning the LOTOS DATA ANALYST DWH solution, and delivered reporting and dashboards via SAP Business Objects to operational and management audiences. – Presented DWH solution designs and analytical results directly to C-level and operational management teams across international lottery client organisations.

– Development of all international MIS (Management Information System) projects. – Pre-sales, RFP, budgeting, and benchmarking tests for international clients. – Management of the BI International Sector department. – Gathered and formalised business requirements from international clients, authoring functional specifications and data mapping documents for multi-country BI and MIS implementations. – Performed data analysis and benchmarking to validate reporting solutions against client-defined KPIs and business logic. – Utilised SAP Business Objects and SAP Sybase IQ for BI reporting, dashboard delivery, and analytical database operations across international MIS projects. – Delivered BI and MIS project outcomes directly to senior management and C-level decision-makers at international client organisations, acting as primary business-facing contact for all data analytics deliverables.