Teamcenter Migration Architect

Tata Consultancy Services; San Diego (CA); On-site; USD 90,000 - 130,000; Full time

Job summary

Tata Consultancy Services in San Diego, CA seeks a data migration specialist to lead Teamcenter PLM migrations. The role focuses on planning, mapping source data, and executing ETL processes from Agile PLM to Teamcenter.

You will develop transformation rules, validate migrated data, and collaborate with IT, PLM developers, and business analysts to ensure a smooth transition. Hands-on experience with bulk data migration tools and SQL/ITK scripting is required, with strong client-facing

Qualifications

• Experience in data migration from Agile PLM to Teamcenter PLM.
• Hands-on with bulk data migration tools and scripting.
• Ability to develop data transformation rules and ETL workflows.

Responsibilities

• Develop and implement data migration strategies for Teamcenter PLM.
• Assess data environments and propose model updates for migration.
• Map source data to target Teamcenter structures and define transformation rules.
• Lead ETL execution including extraction, transformation, and loading.
• Validate migrated data and reconcile discrepancies.
• Collaborate with IT, PLM developers, business analysts, and end-users to gather requirements.

Skills

Data migration

SQL scripting

ITK coding

Teamcenter PLM

ETL processes

Job description

Job Description

• Hands-on experience with any bulk data migration tool is must.
• Hands on experience with TC2506.x or higher ability to develop SQL scripts and ITK codes to perform data migration & transformation
• Experience in executing data migration from any PLM to Teamcenter PLM
• Develop and implement comprehensive data migration strategies and plans for Teamcenter PLM.
• Assess the current data environment and identify systemic changes, data model updates required to support migration from source (Agile PLM) to target system (Teamcenter)
• 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.
• 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, including IT, PLM developers, business analysts, and end-users, to gather requirements and ensure successful migration.

Must Have Technical/Functional Skills

• Hands-on experience with any bulk data migration tool is must.
• Hands on experience with TC2506.x or higher ability to develop SQL scripts and ITK codes to perform data migration & transformation
• Experience in executing data migration from any PLM to Teamcenter PLM

Roles & Responsibilities

• Develop and implement comprehensive data migration strategies and plans for Teamcenter PLM.
• Assess the current data environment and identify systemic changes, data model updates required to support migration from source (Agile PLM) to target system (Teamcenter)
• 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.
• 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, including IT, PLM developers, business analysts, and end-users, to gather requirements and ensure successful migration.

Provide regular updates and reports on migration progress, issues, and resolutions to stakeholders

Generic Managerial Skills, If any

• Good verbal and written communication skills.
• Strong onsite customer-facing consulting and stakeholder management capability
• Ability to work in a multi-vendor, multi-geography program environment
• Good documentation and presentation skills

Salary Range: $90,000 - $130,000 a year