Data Transfer Engineer

The Data Transfer Engineer is responsible for planning, executing, validating, and supporting the migration of business data, documents, workflows, and records from Lotus Notes to PH Connect. The role ensures data integrity, accuracy, security, and business continuity throughout the migration lifecycle while coordinating with business stakeholders, IT teams, and application owners.

• Analyze existing Lotus Notes databases, applications, workflows, and document repositories.
• Define migration strategy, data mapping, and transformation requirements.
• Identify dependencies, risks, and migration constraints.
• Develop migration schedules, cutover plans, and validation procedures.

• Extract structured and unstructured data from Lotus Notes databases.
• Cleanse, standardize, and transform data to meet PH Connect requirements.
• Develop and execute data conversion scripts and migration tools.
• Ensure metadata, attachments, permissions, and relationships are preserved.

• Load migrated data into PH Connect environments.
• Perform reconciliation and validation checks to ensure data completeness and accuracy.
• Conduct user acceptance testing (UAT) support and defect resolution.
• Verify document accessibility, searchability, and workflow functionality post-migration.

• Work closely with business users, IT teams, administrators, and project managers.
• Gather business requirements and migration acceptance criteria.
• Provide migration status reports, issue logs, and risk assessments.
• Coordinate cutover activities and post-go-live support.

• Ensure compliance with data security, privacy, and governance policies.
• Maintain migration documentation, audit trails, and technical procedures.
• Perform root cause analysis for migration issues and implement corrective actions.
• Support data archiving and retention requirements.

• Bachelor's degree in Mechanical, Industrial or related field.
• 3-6 years of experience in data migration, system integration, or application support.
• Experience working with Lotus Notes/Domino databases and applications.
• Knowledge of data migration methodologies and ETL (Extract, Transform, Load) processes.
• Excellent communication and stakeholder management abilities.

• Experience with PH Connect or similar enterprise collaboration platforms.
• Knowledge of scripting and automation tools (Python, Power Shell, SQL).
• Experience with document management and workflow migration projects.
• Understanding of data governance and information security practices.