This job board retrieves part of its jobs from: Sherbrooke Jobs | Laval Jobs | Work From Home

Top job offers in Montreal & Region

To post a job, login or create an account |  Post a Job

  English jobs in montreal  

Bringing the best, highest paying job offers near you

Slide 1
Slide 2
Slide 3
previous arrow
next arrow

Asset Information Management Lead – ETL Migration

ReVisionz Inc.

This is a Contract position in Montreal, QC posted July 11, 2021.

As part of a multi-year Asset Data Lifecycle Program (ADLP) targeted to implement a common set of applications and processes to significantly improve the management of asset information, ReVisionz has developed and operates an Extract/Transform/Load (ETL) process using specialized software to support the enrichment and migration of business asset information.

ReVisionz is seeking an Asset Information Management (AIM) ETL subject matter lead to join our team.

The AIM ETL Lead works closely with the team members and business counterparts to achieve rule-based enrichment and migration through the ETL solution.

Primary responsibility is to lead the ETL team with respect to configuration and operation of the ETL solution, so as to ensure that enrichment and migration will proceed effectively with exceptional quality and success.

Conduct specialized extraction of data sets from source SQL/Oracle databases and file shares and manipulate large volume complex information to discern content issues vis a vis the destination software requirements or other source issues, and plan actions to address the issues.

Coordinate with the business participants where pertinent to see migration issues are addressed where their participation is deemed necessary.

Code new business rules to the Transform aspect of the ETL tools in order to have the source content updated to meet destination load requirements, as well as to overcome historical poor-quality issues through such rules.

Work with the ETL tools to address any issues that are resulting in migration challenges.

Gain knowledge in client’s source system processes and functions as a basis to support migration issues management.

Liaise with the destination software OpenText CS10/Bentley eB/Bentley ProjectWise teams for migration processing where issues may involve the destination applications not processing what the ETL process sends for loading.

Review daily reports on migration status to understand where specific content has migration issues and based on understanding of the migration processes and rules, discern the nature of the issues involved and actions necessary.

Track content migration and loading progress.

Create exception reports and liaison with business owners.

Quality checks the uploading of data into the target environments.

Measure ETL performance and prepare business acceptance criteria.

Prepare daily and monthly progress reports Requirements Lead role focus includes Reporting the to the engagement lead on status, risks and issues Plan and deliverables management Leadership of the ETL team and coordinate plans and actions Assessment team scrum management Facilitating team dynamics to achieve a high-quality assessment Close working relationship with the ReVisionz site assessment and partner technical stream leaders Alignment with the quality assurance leader regarding testing processes and protocols Ensure deliverables align with corporate directives, plans and budgets Liaise in a client facing role to execute customer expectation management Act as the escalation point for all assessment issues in the business unit/facility Ensure the different phases of assessment are delivered on time and with exceptional quality Coordinate with other team components to define timeline and roadmap for alignment of activities and dependencies Ensure complete understanding of the project estimate and project scope Track record in effectively being able to understand issues and work them to resolution across multiple parties – key is full migration success which demands effective decision-making capabilities to understand and resolve issues.

Technical role ETL focus includes 10 years in asset-oriented CAPEX projects and Operational asset information management (AIM) .

10 years background in migration processes and ETL solutions Self-managed by objectives with minimum supervision Strong analytical ability and problem-solving skills In-depth experience in AIM pertaining to tags, asset and project documents and data, physical equipment and asset project turnover processes.

Experience in collection, analysis, sorting, organizing, classifying, validating and uploading very high volumes of asset records.

Strong background in C#, .Net and Visual Studio coding to facilitate configuration of the ETL tools by which business approved formal rules will be codified to the ETL solution to transform the documents and data to be migrated.

Extensive skills in the use of SQL for query, reporting and analysis.

Oracle and SQL database background.

Background in documenting existing systems functions (flow charts on how transactions flow, details on transaction processes, etc.), in regard to ETL solutions.

While not essential, skills with major AIM solutions such as Hexagon, Bentley or Aveva will be a strong asset.

This role will be based in Calgary, AB.

Applicants must be a Canadian citizen, have Permanent Resident status or hold an open work permit in Canada.

We value diversity in our business and encourage responses from all qualified applicants.

While we are appreciative of all applications we receive, we advise that only candidates under consideration will be contacted.