About the position
The Teamcenter Data Migration Expert will be responsible for developing and implementing comprehensive data migration strategies and plans specifically for Teamcenter Product Lifecycle Management (PLM). This role requires a thorough assessment of the current data environment to identify necessary systemic changes and data model updates that will facilitate the migration from various source systems, including Enovia, Windchill, and ARAS, to the target system, Teamcenter. The expert will analyze and map the source data to the target Teamcenter PLM structures, ensuring that all data transformation rules are defined and documented to maintain data integrity and consistency throughout the migration process. In addition to planning and strategy, the role involves leading the execution of data migration activities, which includes data extraction, transformation, and loading (ETL) processes. The candidate must possess hands-on experience with Teamcenter versions TC13/14 and be capable of developing SQL scripts and ITK codes to facilitate data migration and transformation. Utilizing migration tools and scripts to automate data migration tasks will be essential for improving efficiency. The expert will also conduct data validation and reconciliation to ensure the accuracy and completeness of the migrated data, identifying and resolving any discrepancies or issues that arise during and after the migration. Collaboration with cross-functional teams, including IT, PLM developers, business analysts, and end-users, is crucial to gather requirements and ensure a successful migration. Regular updates and reports on migration progress, issues, and resolutions will be provided to stakeholders to keep them informed throughout the process.
Responsibilities
- Develop and implement comprehensive data migration strategies and plans for Teamcenter PLM.
- Assess the current data environment and identify systemic changes and data model updates required for migration.
- Analyze and map source data to target Teamcenter PLM structures.
- Define and document data transformation rules to ensure data integrity and consistency during migration.
- Lead the execution of data migration activities, including data extraction, transformation, and loading (ETL) processes.
- Develop SQL scripts and ITK codes to perform data migration and transformation.
- Utilize migration tools and scripts to automate data migration tasks and improve efficiency.
- Conduct data validation and reconciliation to ensure the accuracy and completeness of migrated data.
- Identify and resolve data discrepancies and issues during and after migration.
- Collaborate with cross-functional teams to gather requirements and ensure successful migration.
- Provide regular updates and reports on migration progress, issues, and resolutions to stakeholders.
Requirements
- 7 years of experience in data migration or related field.
- 6 years of experience with SQL.
- Senior level experience in Product Lifecycle Management (PLM).
- Hands-on experience with Teamcenter versions TC13/14.
Nice-to-haves
- Experience with Enovia, Windchill, and ARAS systems.
- Ability to commute to Phoenix, AZ.
- Willingness to relocate before starting work.
Benefits
- Health insurance
- Dental insurance
- 401(k)
