Job Summary
job Title: KNIME ETL Developer – PLM Migration
Experience: 4–10 Years
Role Overview
A skilled KNIME ETL Developer to design and implement data transformation workflows for a large-scale PLM migration. The role involves building scalable ETL pipelines, implementing incremental (delta) data processing, and ensuring high data quality and integrity throughout the migration lifecycle.
Key Responsibilities
• Design and develop KNIME workflows for data extraction, transformation, and loading (ETL)
• Implement delta/incremental data processing frameworks (timestamp, CDC, or key-based)
• Perform data mapping and transformation between Windchill and 3DEXPERIENCE schemas
• Develop reusable KNIME components and metanodes for standard ETL patterns
• Handle large datasets and performance optimization
• Integrate KNIME with Oracle / SQL databases
• Perform data validation, reconciliation, and quality checks
• Build error handling, logging, and restart mechanisms
• Support cutover, mock runs, and go-live activities
• Collaborate with PLM functional, data, and migration teams
Required Skills
KNIME & ETL & Python
• Strong experience in KNIME Analytics Platform
• Expertise in: DB nodes (DB Query Reader, DB Insert, DB Merge), Joiner, Rule Engine, Column Expressions, Flow Variables & Components, Experience in building modular and reusable workflows, Reconciliation techniques, Handling duplicates and inconsistencies
Delta / Incremental Processing
• Hands-on experience with: Timestamp-based delta loads, Key-based incremental loads, Change Data Capture (CDC), Ability to design control tables and metadata-driven ETL, Handling late-arriving and updated records
PLM Knowledge (Preferred)
• Experience with: any PLM data model
• Understanding of: Parts, BOM, Documents, CAD structures, Versioning & lifecycle states
Key Responsibilities
2. To conduct comprehensive code reviews, establish and oversee quality assurance processes, performance optimization , implementation of best practices and coding standards to ensure successful delivery of complex projects.
3. To ensure process compliance in the assigned module| and participate in technical discussions/review as a technical consultant for feasibility study (technical alternatives, best packages, supporting architecture best practices, technical risks, breakdown into components, estimations).
4. To collaborate with stakeholders to define project scope, objectives, deliverables and accordingly prepare and submit status reports for minimizing exposure & closure of escalations.