Freelancer profile translated to English.
Back to original languageAbout Eryck
BI Consultant for Hager, I am carrying out the migration of on-premise Informatica mappings to the cloud as well as PowerBI dashboards for Data Quality monitoring.
I have 7 years of experience in data integration through Informatica PowerCenter ETL and Oracle databases.
I have mastered the entire ETL application lifecycle, from writing functional specifications to corrective maintenance.
I enjoy working with data, transforming it, visualizing it, directing it through optimized flows, but also the variety of functional areas it can lead me to.
Mobile in:
Ile-de-France/Grand-Est/Switzerland/Luxembourg and open to 100% remote.
Feel free to write to me on#informatica #iics # cloud #powerBI #BI #Dataanalyst
French
Native or bilingual
English
Fluent
Spanish
Conversational
Can work on-site
Strasbourg (up to 30km), Paris (up to 30km), Mulhouse (up to 20km), Metz (up to 20km)
Experience
- HAGERBI ConsultantNovember 2022 - Today (3 years and 7 months)Data Excellence Team.IICS:
- Migration of Informatica PowerCenter workflows to the Cloud (IICS).
- From IICS, migration of SAP sources to SAP/4HANA and ITEME to STIBO.
- Optimization of IICS workflows (execution speed x10 in mapping writing on targets, by updating the native IICS driver).
- Documentation of migrated mappings by writing the development matrix (data mapping).
- Production monitoring, impacts of IICS updates, optimization of IPU consumption.
PowerBi:- Creation and updating of existing PowerBI reports.
- Monitoring of Data Quality scores.
- Creation of the report for monitoring PEP (Product Environmental Profile) and integration of LCA (Life Cycle Analysis).
- Creation of the report for monitoring Milestone adherence on all CTO (create the offer) projects.
- ES EnergiesDATA ManagerSeptember 2019 - October 2022 (3 years and 1 month)Strasbourg, FranceTOPAZE Project, Data-D3S project team.Objectives:reunify electricity purchase and sale to optimize purchase-sale orders on the markets.Means used:Synchronization between Oracle efluid databases to esales via Informatica Powercenter.Writing specs + development/testing/maintenance and documentation of mappings/wkfInformatica:
- Planning and configuration of workflow chains, automatic mailing
- Production monitoring of OPCON chains.
- Corrective maintenance of developed chains.
- Redesign and optimization of previously developed Informatica workflows.
- Reduction of machine load and volume of data processed on the target.
Unix Scripts:decryption + unzip based on file types and dates from an FTP, for moving to the desired directory.Powershell Scripts:Automatic control of the structure and content of files from an API, then daily reporting by email of failures/successes to the relevant teams. - MMA AssurancesInformatica Developer AnalystMarch 2018 - September 2019 (1 year and 6 months)Le Mans, FranceCorrection of batch incidents in the inter-system batch exchange service (Ebisi). Production monitoring on $U. Corrective maintenance of Ebisi project workflows.
Recommendations
These freelancer profiles also match your criteria
Agatha Frydrych
Backend Java Software Engineer
4.7
(3)
2
Baptiste Duhen
Fullstack developer
4.6
(4)
5
Amed Hamou
Senior Lead Developer
4
(2)
7
Audrey Champion
Web developer
4.3
(3)
4
Education
- Mechatronics Engineer, Mechatronics, Robotics and Automation EngineeringENSIBS2012Ingénieur en mécatronique, Ingénierie mécatronique, robotique et automatisation