Data Migration Lead - Mississauga, Canada - opentext

opentext

Verified Company

Mississauga, Canada

4 weeks ago

Posted by:

Sophia Lee

beBee Recruiter

Description

OPENTEXT - THE INFORMATION COMPANY

As the Information Company, our mission at OpenText is to create software solutions and deliver services that redefine the future of digital.

Be part of a winning team that leads the way in Enterprise Information Management.

The Opportunity:

You will be the lead on data migration projects that deal with legacy data from acquired companies (M&A) into OpenText systems, ensuring business requirements are met and business processes are aligned.

Your role is to be the expert in extracting, analyzing and presenting relevant data points from a variety of sources to the business partners and IT leaders.

You will be responsible to help design the data layer as part of migration projects, lead the offshore SQL developers in scripting out the tables for various migration objects and provide data cross-reference to downstream systems that consume migrated data.

Your expertise should be on the ERP related backend data - master data objects including Customer, Contacts, Vendor, Materials and its multiple attributes, transaction objects such as open orders, receivables, payables etc.

An understanding of the flow and impact of master data objects to downstream systems and other transactional data objects.

You should be able to work with cross functional business as well as IT teams and be able to share the data analysis across these teams.

You Are Great At:

Take ownership of design & development of all data extract, analysis and presentation activities Working with the project team to ensure that all ongoing data transformation, deduplication, extraction and load functions once ready for production deployment are documented in detailed data lineage models
Work with diverse backend systems such as Oracle ERP, Netsuite, Salesforce, support/ticketing systems to extract and map data in a SQL staging data layer.
Own/execute process to deduplicate and fuzzy match data
Ability to run, recommend different extraction tools such as DBamp, Suiteanalytics to effectively and efficiently.
Develop best practice, processes, and standards for effectively carrying out data migration activities.
Help prepare data migration plans including migration risk, milestones, quality and business signoff details.
Understanding of data integrations, specifically how master data from SAP can impact downstream systems.
Building and maintaining crossfunctional relationships, including aligning opinions and approaches across disparate teams.
Assisting with designing business processes to be aligned to the master data
Ensuring data accuracy, integrity, and completeness.

What It Takes:

Substantial experience working with databases, including T-SQL
ETL tools capable of data cleansing and deduplication
Ability to engage clearly with client representatives to explain data migration concepts; support deep dive discussions to get answers for required data objects
Passionate about understanding complex data and problem solving
Demonstratable experience in migrating from other ERP systems to SAP S4 is a definite asset
General understanding of project lifecycle & development
Excellent collaboration & presentation skills
Bachelor's Degree in Computer Science, Engineering, or a related field or a combination of education and equivalent experience
8+ years of providing data solutions in a similar setting.
Strong verbal, written and interpersonal communication skills