Data Integration/Data Architect - IDMC/IICS/PowerCenter Expert

12/2024 – 12/2024

Responsible for the migration of 270 assets from PowerCenter to IICS in a large-scale project.

Performing as daily tasks and main skills of the role:
• Migrating PowerCenter jobs to IICS (within an Azure serverless architecture) using the Informatica con-version utility RSA as well as Migration Factory.
• Working with various data sources including databases (Oracle, SQL Server, Salesforce, etc.), APIs REST v2 and flat files
• Dealing with complex SQL queries and working on data modelling and database design tasks
• Working in Agile/Scrum methodology.
• Collaborating with other team members to deliver high-quality solutions on time.

Technischer Sachbearbeiter

4/2022 – 12/2022

Responsible for the development for project at Merck Poland customer in order to implement a solution to analyze the quality of information coming from source systems and KPI analysis. The whole project was created in Informatica Data Quality (IDQ).
The project consisted of implementing validation rules and configuring acceptance or rejection thresh-olds according to business rules and data quality standards. All information that did not meet the quality standards was reported in a user interface implemented in APEX, where users could make modifications to the information reported there as a result of the validation rules executed by the automatic processes in IDQ.

Business Intelligence (BI)

12/2019 – 12/2023

Responsible for new developments within Oliver Wyman’s client to feed the SSOT (Single Source of Truth) database and all downstream internal subsystems, from Financial Force system. All new initiatives are created in Informatica Intelligent Cloud (IICS) and existing processes are maintained in SSDT.
The project consists of extracting all the data for Clients, Accounts, Legal Entities, Projects, Opportuni-ties, Timecards and Assignments from Sales Force (as CRM system will be shutting down) and storing it an SQL Server DB. It also requires to analyzing the impact upon all existing downstream systems and building the new ETL processes if needed or adjusting existing ones.
In addition, I participated in the construction of ETL processes in a project where the migration to a data vault architecture of the datawarehouse in snowflake (on GCP) was performed.

Data Warehousing