Informatica PowerCenter Experts in Germany

• DWH modernization
• Migration from Informatica PowerCenter to IDMC/CDI
• Migration from IBM DB2 to Databricks

Technologies: Informatica IDMC, Databricks

(Technology)

• Design and implementation of an SAP BTP CAP microservice to consolidate cross-system transactional checks between SAP Sales Cloud (C4C) and On-Premise SAP CRM (05/2024– 06/2025)
• Bi-directional Cloud-to-On-Premise integration enabling real-time validation of Contact lifecycle and open document dependencies prior to record updates (05/2024– 06/2025)

Responsibilities / Deliverables

• development of custom CAP (Cloud Application Programming) services on SAP BTP
• API design, data mapping, and end-to-end integration across C4C (Cloud Runway) and legacy CRM (Traditional Runway)

I am an experienced data engineer specializing in end‑to‑end data integration, cloud DWH architectures, and high‑quality, governed data products.

I delivered following projects and engagements as a freelancer.

• Data Migration of CRM System for AL-FA Objekt Service Gmbh
• Microsoft Software Resales Partnership

I am looking for freelance roles like: Freelance Data Engineer Cloud Data Warehouse Architect Data Modeling & Architecture Consultant MDM & Data Governance Specialist BI & Analytics Developer

Technical Focus Areas

• Data Engineering & Integration: SQL Server/SSIS, Informatica PowerCenter/IDQ, Talend, Kafka, Azure Data Factory – Delta/CDC/ELT patterns, robust pipelines, monitoring/recovery, data lineage & impact analysis, medallion architecture Bronze/Silver/Gold layers
• DWH & Cloud: Azure SQL / Data Lake / Synapse, AWS Redshift/S3, on‑prem SQL/Oracle – scalable data marts with a strong cost/benefit focus.
• Data Modeling: Atomic (Inmon) and Dimensional (Kimball), Data Vault (Linstedt), Domain‑Driven Design, clear lineage & contracts.
• MDM & Governance: Informatica MDM, IBM MDM, stewardship processes, data quality rules, survivorship/XREF, catalog/glossary, SIF/BES/REST publication.
• Analytics/BI: Power BI, SSAS, Cognos – business‑ready, maintainable data products.

• Analyzing, aligning and modeling business processes (BPMN 2.0) for the 'The New Retail' program in the areas of invoicing, tax, customs and accounting
• Tracking user stories and their impact on processes
• Point of contact for preparing the tool migration from Symbio to Signavio for the mentioned areas
• Power user after the introduction of Signavio, point of contact and coach for other process modelers

• Development and maintenance of database-driven applications for managing supplier and food contracts, with extensive use of Oracle PL/SQL for complex business logic and data processing
• Optimization of PL/SQL procedures, functions, and triggers to ensure the performance and scalability of Oracle database solutions
• Ensuring compliance with best practices in PL/SQL development and implementing standards for code quality and data integrity
• Close collaboration with backend and frontend teams to ensure smooth integration between the Oracle database, C#-based APIs, and Azure cloud services

• Supported the International Web Presence project of the Federal Employment Agency (IntWeb) in quality management, taking on responsibility for the quality of processes and project deliverables while adhering to BA standards. The project's main goals are to give professionals abroad a quick overview of their chances to move to Germany and to enable them to take the necessary steps in a consistently digital way.

• Set the fundamental guidelines using the QA handbook

• Summarized test results in QA reports for PLA

• Analyzed project outcomes for improvement opportunities

• Quality management of requirements analysis (especially processes, methods and tools)

• Ensured compliance with SERA guidelines

• Created a cross-project test concept

• Agreed on sprint completion reports

• Conducted formal reviews of deliverables according to guidelines and/or project plan

• Acted as contact person for internal audit and external audits by auditors or the Federal Audit Office (BRH)

• Technologies: JIRA, Confluence, MS Office, GitLab, Kubernetes

• Setting architectural standards for Informatica Power Center development teams
• Maintenance-performance-health for DWH (Exadata) environments
• Qlik Sense / BO reports architectural standards
• Implementing best practices in ETL tasks
• Documentation ETL standards on Confluence
• Dynamic Data Masking rules for GDPR/KVKK regulations by using Informatica DDM tool
• DWH Data model Power Designer
• Upgrade Qlik Sense versions
• Merge all Informatica server's repository databases on one Oracle DB

• Datastage 11.7, dbt, Oracle 19, Python 3.12 / PySpark 3.5, Azure GitHub, Azure DevOps, Automic
• Development of migration jobs to transfer data from the collection DWH to the new Risk Mart, as well as development of ETL pipelines to migrate historical data from the old Mart to the new Risk Mart.
• Storage of the silver layer on Hadoop and the gold layer in Oracle.
• Translation of DataStage jobs into dbt to publish reporting data in Google Cloud to a PostgreSQL database.
• Creation and optimization of complex SQL queries for data extraction from a data vault, taking into account historical data in the point-in-time tables.
• Creation of Oracle table definitions (DDL) and adjustment of existing stored procedures.
• Versioning changes in GitHub and deployment via the CI/CD portal.
• Refactoring long-running DataStage jobs into Python using PySpark to reduce server load.
• Migration of SAS scripts to PL/SQL, including new development of distribution functions that have no direct equivalent in Oracle.
• Development of Automic jobs to run DataStage pipelines and Python scripts (PySpark jobs) that control the population of the SME and institutional risk tables in the Risk Mart and perform business calculations.
• Participation in the agile process, including creating user stories, estimations, and planning in Azure DevOps.
• Handling Azure DevOps tickets and close collaboration with testers and business teams for error analysis and resolution.

• Designed and implemented scalable ETL/ELT pipelines using Python, SQL, dbt, AWS and Informatica to ingest data from sources such as APIs, relational databases, and flat files into Snowflake, reducing pipeline runtime by ~30%.
• Migrated high-volume datasets from on-premises Teradata to Snowflake using AWS services (S3, Glue, Step Functions, IAM), ensuring data consistency and integrity.
• Applied Kimball methodology to design star and snowflake schemas, improving query performance and reducing Snowflake compute costs.
• Implemented automated data quality checks using SQL-based dbt tests and the Great Expectations framework to detect anomalies and enforce data correctness before production loads.
• Orchestrated ETL workflows in Airflow using Python and managed code deployments via Git with CI/CD best practices to increase deployment reliability and maintain pipeline uptime.
• Built interactive Power BI dashboards and curated datasets to enable data-driven decision-making for stakeholders.
• Maintained technical documentation in Confluence for ETL workflows, and led knowledge-sharing sessions for new joiners.

• Analyzed the required scope of processes, infrastructure, and SAP for integrating the MacDermid subsidiaries
• Validated proposals from the new service providers
• Managed the collaboration and tracked the tasks of business and IT experts
• Coordinated communication and the PMO
• Created cutover plans in three waves for SAP conversion, Salesforce, and Ariba

• Head of overall technical integration NSC (National Secure Cloud, project with approx. 60 employees).

• Technical integration of all subprojects into one product, definition of interfaces and basic components of a cloud including hardware, technical architecture of the IABG platform.

• Development of a Cloud Management Platform (CMP) capable of creating private/mixed clouds of any complexity based on a textual description with one click or interactively.

• CMP also includes the complete hardware management lifecycle.

• Kubernetes, OpenStack and Hadoop are used as the foundation.

• The management layer includes Harbor, Gitea, Longhorn, Keycloak, Rancher and Jenkins, which are configured automatically.

• Private cloud can run any customer workloads, including a full Hadoop layer with HDFS, Spark, MapReduce, Mesos, HBase and around 20 additional ML/DL technologies.

• Hadoop worker clusters can also be installed automatically without Kubernetes on bare metal or commodity hardware.

• OpenStack with Nova, Neutron, Ironic, Swift, Cinder, Ceph.

• Development of a Java application Rudi: SOAP, REST, containers, DB.

• Technologies: Kubernetes (K3s, Rke2, Minikube, Harbor, Gitea, Jenkins, Longhorn, Keycloak, Rancher), OpenStack (Nova, Neutron, Keystone, Swift, Ceph, Cinder, Sahara, Magnum, Kayobe, Kolla, Bigrost, Ironic), Hadoop (HDFS, Ambari, Solr, Livy, Ranger, YARN, Tez, HBase, Kafka, Hive, Zookeeper, MapReduce, Spark, Oozie, Flink), virtualization (Kubernetes (K3S), VMware, Oracle), scripting (Ansible, Puppet, Juju, Shell, Groovy, Gradle, Maven).

• Replacement of a Java application and the Oracle DB for loading the internal WerWasWo system using SSIS.
• Development of SSIS packages to load text files into the database (SQL Server)
• Development of a database project for deployment on various servers
• Creation of queries to monitor the loading runs
• Development of a PowerShell script to automate the deployment of the SSDT projects.
• Oracle, SQL Developer, Microsoft SQL Server 2022 on-premises, SQL Server Management Studio v21, Visual Studio 2022, SSIS, SSDT, PowerShell.

• Developed and enhanced ETL loading jobs with IBM DataStage and optimized SQL in an IBM DB2 environment as part of the Agree21 data migration
• Analyzed data quality and developed test procedures
• Created PowerShell scripts and documented GIT deployment processes
• Technologies: RedHat Linux, IBM DB2 with DBVisualizer, IBM InfoSphere DataStage 11.7, JIRA, TortoiseGIT, TortoiseSVN, PowerShell scripts

• Project: SAP migration (ECC to S/4HANA) – US-based internal analytics product to manage finance and personnel performance insights of 10,000+ users across the Americas.
• Led cloud migration from a legacy data warehouse to Azure Data Lake and Databricks, improving system scalability by 40% and reducing manual interventions by 60%.
• Delivered end-to-end product ownership across 3 cross-functional Agile teams using SAFe methodology and Azure DevOps.
• Designed and implemented data pipelines using Azure Data Factory, improving data ingestion speed by 30% and reducing data errors by 25%.
• Defined the product roadmap, backlog, and sprint goals in collaboration with stakeholders, ensuring 95% of deliverables met business expectations.
• Managed the product backlog and prioritised feature development based on stakeholder needs, achieving a 25% increase in sprint velocity and a 100% sprint completion rate.
• Facilitated Agile ceremonies (sprint planning, reviews, retrospectives) that improved team collaboration and reduced delivery times by 20%.
• Led requirement gathering and analysis, enhancing data quality and aligning with business objectives, resulting in a 25% improvement in migration efficiency.
• Worked closely with business owners, achieving a 15% reduction in dispute resolution time and stronger alignment with business value.
• Established KPI dashboards to measure product adoption and platform stability, resulting in 20% improved stakeholder satisfaction.