Capgemini Engineering, the leader in engineering and R&D services, helps clients unleash their R&D potential.

Windchill Data Migration Developer

Data EngineerData EngineerFull TimeRemoteTeam 10,001+H1B No SponsorCompany Site LinkedIn

Location

United States

Posted

110 days ago

Salary

$124.2K - $140K / year

Bachelor Degree5 yrs expEnglishSQL

Job Description

• Collaborate with cross-functional teams to understand business requirements and translate them into technical solutions. • Analyze source system and data to develop mapping and transform logic/scripts to enable migration in target Windchill environment. • Query Windchill database to confirm data trends or report out information to support solutioning or business needs. • Leverage Windchill Bulk Migrator, PTC’s Load From File Framework, Windchill’s Importable Spreadsheet, and/or custom scripts/utilities to load data into the target Windchill system, or to modify, append to, or cleanse data already loaded. • Support integration projects between Windchill and other enterprise systems and applications which may require initializing datasets or assistance querying or extracting Windchill data in bulk. • Conduct comprehensive testing, including unit, integration, and system testing ensuring application quality and functionality stay in spec. • Debug and resolve complex application, customization, or data defects and issues. • Develop and maintain technical documentation for all data extraction, transformation, loading and cleansing rulesets and solutions. • Provide training and support to end-users on data relationships and extract, transform, load, or cleansing logic when necessary. • Stay up to date with the latest Windchill developments and data migration industry best practices.

Job Requirements

Currently hold an active U.S. security clearance.
Currently hold PTC certifications for Windchill.
Bachelor’s degree in computer science, software engineering, or other engineering discipline.
Minimum 5 years of experience working with PTC’s Windchill PLM software and specifically with using and developing on top of Windchill Bulk Migrator.
Experience installing and configuring Windchill Bulk Migrator.
Minimum of 5 successful large scale data migration projects completed from different source systems into Windchill including but not limited to the loading of Parts, CAD, Documents, Links, Attribution, Primary and Secondary Content, Change Records, History, and BoMs.
Experience working with and developing on top of Windchill version 12.
Experience collaborating with the PTC Technical Support & R&D organizations.
Experience building custom loaders for WBM.
Experience with Windchill to Windchill data migrations.
Strong SQL scripting competency.
Strong understanding of Windchill’s db schema and object model.
Experience in Windchill Business Administration, including security configurations.
Excellent problem-solving skills and attention to detail.
Strong communication and interpersonal skills.
Strong documentation skills.
Ability to work independently and as part of a team.