Senior Consultant – PowerDesigner to ER/Studio Migration

Roles & Responsibilities

1. Assess the customer's PowerDesigner landscape, including CDM, LDM, and PDM models.

2. Analyze model complexity, dependencies, custom properties, domains, scripts, extensions, and platform specific implementations.

3. Identify migration risks, assumptions, constraints, and remediation requirements.

4. Define migration approach, standards, governance, and quality controls.

5. Lead pilot migrations to validate conversion feasibility and effort.

6. Execute model migrations using ER/Studio MetaWizard and supporting tools.

7. Define source-to-target mappings for metadata, domains, datatypes, relationships, keys, and custom attributes.

8. Resolve conversion issues and implement remediation strategies for unsupported or customized constructs.

9. Ensure consistency, traceability, and repeatability throughout the migration process.

10. Design and execute reconciliation and validation processes.

11. Verify structural integrity of migrated models, including entities, attributes, relationships, keys, and metadata.

12. Identify and resolve migration defects, exceptions, and data modeling inconsistencies.

13. Produce migration quality metrics, validation reports, and acceptance documentation.

14. Design and develop automation utilities, scripts, macros, and accelerators to reduce manual effort.

15. Leverage ER/Studio Automation Interface and related technologies to support bulk migration and validation activities.

16. Establish reusable frameworks for future migration projects.

17. Work directly with customer architects, data modelers, database teams, and project stakeholders.

18. Facilitate migration workshops, discovery sessions, and technical reviews.

19. Provide expert guidance on migration decisions, trade-offs, and best practices.

20. Present findings, recommendations, and progress updates to leadership teams.

21. Develop migration assets, templates, standards, and best practices.

22. Create reusable migration playbooks and operating procedures.

23. Mentor consultants and contribute to building organizational capability in metadata migration and data modeling modernization.

Ideal Candidate

1Strong Senior Data-Modeling / Metadata-Migration Consultant Profile with deep SAP PowerDesigner and ER/Studio expertise

2Mandatory (Experience 1): Must have 10+ years in Data Warehousing, Data Architecture, or Enterprise Data Modeling, including 3+ years hands-on with SAP PowerDesigner and 2+ years with ER/Studio Data Architect, along with at least one real metadata-migration or model-conversion project.

3Mandatory (Experience 2): Must have proven experience in metadata migration, model conversion, or repository modernization initiatives.

4Mandatory (Experience 3): Must have experience assessing a PowerDesigner landscape, analyzing model complexity, dependencies, custom properties, and platform-specific implementations, and defining migration approach, standards, governance, and quality controls.

5Mandatory (Experience 4): Must be able to lead pilot migrations, execute model migrations, define source-to-target mappings (metadata, domains, datatypes, relationships, keys, custom attributes), and remediate unsupported / customized constructs.

6Mandatory (Experience 5): Must be able to design and execute reconciliation / validation processes, verify structural integrity of migrated models, and produce quality metrics, validation reports, and acceptance documentation.

7Mandatory (Experience 6): Must have experience working with large, complex enterprise data models.

8Mandatory (Tech skill 1): Must have strong hands-on experience with SAP PowerDesigner (CDM, LDM, PDM models, domains, custom properties, scripts, extensions).

9Mandatory (Tech skill 2): Must have strong hands-on experience with ER/Studio Data Architect, including the MetaWizard and Automation Interface.

10Mandatory (Tech skill 3): Must be able to design and develop automation utilities, scripts, macros, and accelerators (via the ER/Studio Automation Interface) to reduce manual effort and support bulk migration and validation.

11Mandatory (Skill): Must be able to engage stakeholders, facilitate migration workshops and technical reviews, provide expert guidance, present to leadership, and build reusable migration frameworks, playbooks, and standards; mentoring / capability-building experience a plus.

12Mandatory (Note1): This is a 6-month contract role. Candidate must be comfortable with the contract engagement and able to join immediately (urgent — onboarding within ~a week)

13Mandatory (Note 2): The candidate will be on TalentXO’s payroll.