Senior Consultant – PowerDesigner to ER/Studio Migration(6 Month Contract)

About Role Key Skills SAP PowerDesigner ER/Studio Data Architect Data Modeling Metadata Migration Data Warehousing Data Architecture Automation ER/Studio MetaWizard ETL Mapping Roles & Responsibilities Assess the customer's PowerDesigner landscape, including CDM, LDM, and PDM models. Analyze model complexity, dependencies, custom properties, domains, scripts, extensions, and platform specific implementations. Identify migration risks, assumptions, constraints, and remediation requirements. Define migration approach, standards, governance, and quality controls. Lead pilot migrations to validate conversion feasibility and effort. Execute model migrations using ER/Studio MetaWizard and supporting tools. Define source-to-target mappings for metadata, domains, datatypes, relationships, keys, and custom attributes. Resolve conversion issues and implement remediation strategies for unsupported or customized constructs. Ensure consistency, traceability, and repeatability throughout the migration process. Design and execute reconciliation and validation processes. Verify structural integrity of migrated models, including entities, attributes, relationships, keys, and metadata. Identify and resolve migration defects, exceptions, and data modeling inconsistencies. Produce migration quality metrics, validation reports, and acceptance documentation. Design and develop automation utilities, scripts, macros, and accelerators to reduce manual effort. Leverage ER/Studio Automation Interface and related technologies to support bulk migration and validation activities. Establish reusable frameworks for future migration projects. Work directly with customer architects, data modelers, database teams, and project stakeholders. Facilitate migration workshops, discovery sessions, and technical reviews. Provide expert guidance on migration decisions, trade-offs, and best practices. Present findings, recommendations, and progress updates to leadership teams. Develop migration assets, templates, standards, and best practices. Create reusable migration playbooks and operating procedures. Mentor consultants and contribute to building organizational capability in metadata migration and data modeling modernization. Ideal Candidate 1 Strong Senior Data-Modeling / Metadata-Migration Consultant Profile with deep SAP PowerDesigner and ER/Studio expertise 2 Mandatory (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. 3 Mandatory (Experience 2): Must have proven experience in metadata migration, model conversion, or repository modernization initiatives. 4 Mandatory (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. 5 Mandatory (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. 6 Mandatory (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. 7 Mandatory (Experience 6): Must have experience working with large, complex enterprise data models. 8 Mandatory (Tech skill 1): Must have strong hands-on experience with SAP PowerDesigner (CDM, LDM, PDM models, domains, custom properties, scripts, extensions). 9 Mandatory (Tech skill 2): Must have strong hands-on experience with ER/Studio Data Architect, including the MetaWizard and Automation Interface. 10 Mandatory (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. 11 Mandatory (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. 12 Mandatory (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) 13 Mandatory (Note 2): The candidate will be on TalentXO’s payroll. Additional Information This is a remote position. The role is a Senior Consulting role. The pay is mentioned as 2 LPM /Month (1200 /HR) and is negotiable. The focus is on establishing a repeatable enterprise migration capability. Interview Process Round 1: Role-specific interview Round 2: Final interview