Informatica Senior MDM Lead

Job Summary

Owns the end-to-end data platform design and migration strategy for the cloud-native eInvoice application on Azure PostgreSQL; ensures data model supports like-for-like functionality and enables reliable migration, reconciliation, and cutover.

• Define target domain data model (Accounts, Invoices, Payments, RBAC, Notifications, Config, etc.) and schema standards (naming, keys, constraints).

• Establish migration approach (bulk vs bulk+delta), cutover runbook, rollback strategy, and rehearsal plan.

• Define data mapping standards, transformation rules, and reconciliation framework (counts, checksums, financial totals).

• Set performance strategy (indexing patterns, partitioning approach if needed, read-model strategy for dashboards/search).

• Align data pipelines patterns (idempotency, error handling, retries, audit logs) with app and platform teams.

• Govern data security model (PII classification, token references, access patterns, auditing).

• Review and sign off on DB operational readiness (backup/restore, HA/DR assumptions, monitoring hooks).

• 10+ years in data architecture / DB engineering across enterprise systems.

• Strong PostgreSQL data modeling, schema design, indexing and query tuning experience.

• Proven experience planning and executing large-scale data migrations (legacy RDBMS to PostgreSQL or similar).

• Strong understanding of ELT/ETL patterns, idempotent loads, reconciliation, and cutover planning.

• Ability to lead cross-functional teams (app, data, platform, security) and produce design/runbook deliverables.

• Experience with Azure Database for PostgreSQL (managed) operations (HA, backups, monitoring, private endpoints).

• Experience designing data models for microservices (bounded contexts, schema-per-service, event/outbox patterns).

• Familiarity with regulated/finance-like reconciliation and audit controls.

• Experience with ADF/Synapse pipeline design patterns and governance.

Key Responsibilities

Owns the end-to-end data platform design and migration strategy for the cloud-native eInvoice application on Azure PostgreSQL; ensures data model supports like-for-like functionality and enables reliable migration, reconciliation, and cutover.

• Define target domain data model (Accounts, Invoices, Payments, RBAC, Notifications, Config, etc.) and schema standards (naming, keys, constraints).

• Establish migration approach (bulk vs bulk+delta), cutover runbook, rollback strategy, and rehearsal plan.

• Define data mapping standards, transformation rules, and reconciliation framework (counts, checksums, financial totals).

• Set performance strategy (indexing patterns, partitioning approach if needed, read-model strategy for dashboards/search).

• Align data pipelines patterns (idempotency, error handling, retries, audit logs) with app and platform teams.

• Govern data security model (PII classification, token references, access patterns, auditing).

• Review and sign off on DB operational readiness (backup/restore, HA/DR assumptions, monitoring hooks).

• 10+ years in data architecture / DB engineering across enterprise systems.

• Strong PostgreSQL data modeling, schema design, indexing and query tuning experience.

• Proven experience planning and executing large-scale data migrations (legacy RDBMS to PostgreSQL or similar).

• Strong understanding of ELT/ETL patterns, idempotent loads, reconciliation, and cutover planning.

• Ability to lead cross-functional teams (app, data, platform, security) and produce design/runbook deliverables.

• Experience with Azure Database for PostgreSQL (managed) operations (HA, backups, monitoring, private endpoints).

• Experience designing data models for microservices (bounded contexts, schema-per-service, event/outbox patterns).

• Familiarity with regulated/finance-like reconciliation and audit controls.

• Experience with ADF/Synapse pipeline design patterns and governance.

Skill Requirements

Owns the end-to-end data platform design and migration strategy for the cloud-native eInvoice application on Azure PostgreSQL; ensures data model supports like-for-like functionality and enables reliable migration, reconciliation, and cutover.

• Define target domain data model (Accounts, Invoices, Payments, RBAC, Notifications, Config, etc.) and schema standards (naming, keys, constraints).

• Establish migration approach (bulk vs bulk+delta), cutover runbook, rollback strategy, and rehearsal plan.

• Define data mapping standards, transformation rules, and reconciliation framework (counts, checksums, financial totals).

• Set performance strategy (indexing patterns, partitioning approach if needed, read-model strategy for dashboards/search).

• Align data pipelines patterns (idempotency, error handling, retries, audit logs) with app and platform teams.

• Govern data security model (PII classification, token references, access patterns, auditing).

• Review and sign off on DB operational readiness (backup/restore, HA/DR assumptions, monitoring hooks).

• 10+ years in data architecture / DB engineering across enterprise systems.

• Strong PostgreSQL data modeling, schema design, indexing and query tuning experience.

• Proven experience planning and executing large-scale data migrations (legacy RDBMS to PostgreSQL or similar).

• Strong understanding of ELT/ETL patterns, idempotent loads, reconciliation, and cutover planning.

• Ability to lead cross-functional teams (app, data, platform, security) and produce design/runbook deliverables.

• Experience with Azure Database for PostgreSQL (managed) operations (HA, backups, monitoring, private endpoints).

• Experience designing data models for microservices (bounded contexts, schema-per-service, event/outbox patterns).

• Familiarity with regulated/finance-like reconciliation and audit controls.

• Experience with ADF/Synapse pipeline design patterns and governance.

Other Requirements

null