Informatica Lineage Mapping Documentation

I need a seasoned Informatica PowerCenter developer to dig into our existing repository, read each mapping from source to target, and surface the complete field-level lineage. The goal is strict data lineage transparency—every column, every hop, every transformation—so auditors and downstream teams can quickly verify how a value is derived.

Here is what the engagement looks like:

• Analyse all PowerCenter mappings, sessions, and workflows, including any reusable mapplets.
• Parse XML exports or query repository metadata directly; whichever approach you prefer, as long as it captures every transformation rule accurately.
• Produce an Excel workbook that clearly lists source fields, intermediate transformation steps, and final target fields.
• Complement the spreadsheet with Lucidchart diagrams that visually trace each field’s journey end-to-end.

Your output will be considered complete when each mapping shows field-level lineage in both the Excel file and its corresponding Lucidchart, and I can reconcile any value in the target back to its exact origin and transformation logic without ambiguity.

If you already have scripts or accelerators for harvesting metadata, feel free to leverage them. A strong grasp of PowerCenter XML structure and repository views will make this work go faster, so please highlight similar projects you have delivered.