Services
Services
PowerCenter · IDMC · Cloud Migration · Claude Code · Agentic Development
Migrating PowerCenter to IDMC
Moving Informatica PowerCenter to the IDMC cloud platform – from setting up the environment and the Secure Agent, through migrating the load processes, to switching the target database.
I set up Informatica Cloud Data Integration (CDI), install and configure the Secure Agent on Linux and connect existing PowerCenter environments to the CDI-PC cloud service. Moving a Secure Agent from Microsoft Azure to an on-premises server is part of this as well.
I move PowerCenter workflows and load processes to IDMC and test the migration with old-versus-new comparisons. Where required, the databases change too: from HP Vertica to Google BigQuery, from MS SQL Server to PostgreSQL or from Db2 z/OS to MS SQL Server.
After the go-live I support the operation, maintenance and further development of the IDMC environment. Certification: Informatica Cloud Data and Application Integration Certified Professional.
Read more
Specification-driven development with Claude Code
Requirements become a versioned specification, broken down into work packages that my own AI agents design, implement, test and review – each through to pull request and merge.
I work with a specification-driven development process I set up myself in Claude Code: requirements become a versioned specification, broken down into milestones and work packages as issues. Custom subagents handle design, design review, implementation, testing and code review, each through to pull request and merge. Workflow and model choice depend on complexity; entire milestones can run unattended, stopping at the first failure.
This is how I build my own tooling for IDMC in Python: a deployment tool for the automated promotion of IDMC assets via the REST API, a metering tool for license consumption analysis and, currently in development, a web-based runtime monitor with a Gantt chart of job and taskflow runs. I also apply AI-assisted development in client projects, for example for a deployment tool for IDMC and the migration from PowerCenter to IDMC.
So that AI agents work on reliable domain knowledge, I build my own skills: on the IDMC REST API, verified against real orgs; on the IDMC design objects mapping, mapping task and taskflow, reconstructed from production mappings; on the IDMC connectors; and on Informatica PowerCenter, verified against real exports.
Read more
Informatica PowerCenter – development, administration, upgrades
Development, performance tuning, administration, upgrades and deployment of Informatica PowerCenter, including PowerExchange and the Web Services Hub.
I build and extend load processes with Informatica PowerCenter and connect sources and targets via PowerExchange, for example SAP, Salesforce, mainframe, MQSeries and HP Vertica. This includes real-time extraction from SAP, processing IDocs and interfaces via SOAP, REST and the Web Services Hub.
On the administration side I install PowerCenter environments, carry out upgrades and move environments to new data centers, including updates of the Linux servers.
When PowerCenter is introduced, I support teams with training, a rights and roles concept, development guidelines and naming conventions, up to replacing legacy COBOL applications. Test data management with pseudonymization and synthetic data completes the picture. Certification: Informatica Certified Developer.
Read more
Data governance & data quality (EDC, Axon, CDGC, Informatica Data Quality)
Supporting data governance initiatives with Informatica EDC, Axon and CDGC, and data quality rules with Informatica Data Quality.
I connect source systems to the Enterprise Data Catalog, configure profiling and metadata loading and enrich the metadata with data domains and custom attributes. For data lineage and impact analysis I use EDC, and for data lineage in the cloud also Cloud Data Governance and Catalog (CDGC).
As part of a proof of concept, I implemented rights and roles concepts, datasets, systems, the business glossary, system lineage and the data marketplace in Axon. I advise on standards, guidelines and best practices for EDC and contribute to workshops on its strategic direction.
I define data quality rules and agree them with the business; this includes duplicate checks, format checks and address validation, for example with Address Doctor and Informatica Data Quality. I provide functional and technical support for proofs of concept for EDC, Axon and Data Quality. Certification: Informatica Enterprise Data Catalog Specialist.
Read more
DWH architecture & Data Vault 2.0
Designing DWH architectures based on Data Vault 2.0, plus reporting-oriented and relational data modeling.
I design the architecture and data model of new data warehouses and integrate new requirements into existing ones. When building an enterprise data warehouse based on Data Vault 2.0, I design and implement the ETL processes from the staging area into the raw vault and on into the business vault, and advise on best practices and performance optimization.
I build central analytical platforms and data warehouses, for example on MS SQL Server with data marts moved out of Db2 z/OS, and design interfaces via REST, SOAP, OData and IDocs. As technical project lead I coordinate teams, model data and tune performance.
Certifications: CDVP2 – Certified Data Vault 2.0 Practitioner, Microsoft DP-700: Fabric Data Engineer Associate and Microsoft DP-900: Azure Data Fundamentals.
Read more
Migration and deployment tooling (AI-assisted)
Custom tooling for migration and deployment, including AI-assisted development with Claude Code.
I design and build deployment tools for Informatica environments, among them a deployment tool for IDMC, developed with the support of Claude Code. I also migrate PowerCenter workflows to IDMC with the support of Claude Code.
For testing I use old-versus-new comparisons and a test framework in Python with pandas. The toolbox also includes SQL, Shell, Git and Liquibase.