OPENTEXT - THE INFORMATION COMPANY

OpenText is a global leader in information management, where innovation, creativity, and collaboration are the key components of our corporate culture. As a member of our team, you will have the opportunity to partner with the most highly regarded companies in the world, tackle complex issues, and contribute to projects that shape the future of digital transformation.
AI-First. Future-Driven. Human-Centered.
At OpenText, AI is at the heart of everything we do—powering innovation, transforming work, and empowering digital knowledge workers. We’re hiring talent that AI can’t replace to help us shape the future of information management. Join us.

Data Extraction

• Extract data from source systems (databases, files, legacy platforms, third-party applications).
• Work with SQL, APIs, or connectors to pull raw data efficiently and accurately.

Data Transformation

• Develop transformation logic to align source data with Salesforce data models.
• Cleanse, deduplicate, and enrich data to ensure consistency and usability.
• Apply business rules for formatting, validation, and relationship mapping.

Data Loading

• Load data into Salesforce using Salesforce Data Loader, Bulk API, Workbench, or third-party ETL tools.
• Sequence object loads considering dependencies (Accounts, Contacts, Opportunities, etc.).
• Handle large data volumes using chunking and batch processing techniques.

Testing& Validation

• Perform data reconciliation to confirm accuracy post-load.
• Conduct pre-load and post-load validations to ensure integrity.
• Support business users in data verification and user acceptance testing (UAT).

Error Handling& Optimization

• Identify and resolve load failures, transformation errors, and data mismatches.
• Implement retry logic and log/audit mechanisms.
• Optimize performance of ETL processes.

Documentation& Support

• Maintain field mapping documents and transformation scripts.
• Document all steps of the migration process for auditing and repeatability.
• Support cutover activities and post-migration support phases.