This is a contract position for a Data Conversion Specialist - Senior for our public sector client.
Work location: 5700 Yonge St.
Duration: Seven Months
7.25 hours/day
This is a Hybrid role that requires the candidate to be onsite 3 days of the week (This is a mandatory requirement of the role and is non-negotiable outside of exceptional circumstances.)
...
Advantages
Good compensation working on projects that will make a difference to the people of Ontario.
Responsibilities
•Responsible for developing and implementing the data migration strategy including project deliverables for completeness, quality, and compliance with established project standards
•Work with the Ministry and vendor team(s) to develop core data migration deliverables and requirements, data mapping and transformation rules
•Design and implement a data migration audit process to ensure data integrity and ability to mitigate/remediate data quality issues
•Manage the data migration deliverables throughout development to ensure quality and traceability to requirements
•Manage assigned risks and monitor potential impacts, including escalation as part of the data migration plan
•Support the Ministry and vendor test teams with the creation of test data
•Ensure test data conforms to data security requirements
•Perform data migration audit, reconciliation, and exception reporting for static and transactional data
•Ensure privacy and security access controls are followed for sensitive personal data in accordance with
•OPS standards and guidelines
•Ensure security in reporting and data warehousing
•Provide guidance to the project team and transferring knowledge and skills to these team members
Responsibilities:
•Oversees all facilities of the conversion process.
•Completes mapping, interfaces, mock conversion work, enhancements, actual conversion, and verifies completeness and accuracy of converted data.
•Establish a strong working relationship with all clients, interact effectively with all levels of client personnel, and provide conversion support.
•Analyzes and coordinates data file conversions.
•Works with importing files from heterogeneous platforms.
General Skills:
•Full life-cycle data conversion experience with Enterprise Resource Planning (ERP) Systems, including deployment experience
•Proficiency in query languages
•Familiarity with and construction of complex query statements
•Knowledge of various database structures
•Data analysis, investigative and logic skills
•Experience with data conversion scripts and tools
•Experience with overseeing /completing all tasks involved in the conversion process including data extraction, cleansing, transformation and loading
•Experience liaising with teams to understand to-be migration requirements.
•Establish a strong working relationship with all groups, interact effectively with all levels of client personnel, and provide conversion support.
•Experience completing mapping, interfaces, conversion work, documentation and verifying completeness and accuracy of converted data.
•Experience delivering the required system changes and/or working with the development team or a dedicated conversion team to specify loads programs.
•Experience providing support through the cutover process
•A team player with a track record for meeting deadlines, managing competing priorities and client relationship management experience
•Communication, facilitation, negotiation, consensus building, and problem-solving skills
Desirable Skills:
•Knowledge and experience in business case development
•Knowledge and understanding of Information Management principles, concepts, policies and practices
•Excellent understanding of master data and transactional data concepts and interdependencies
Experience and Skill Set Requirements
•Hybrid Assignment- As a result of current OPS direction, the successful candidate will be required to work on site in person at the work location listed in the RQ for a minimum of 2-3 days per week at discretion of HM.
•Successful candidate must reside in Ontario.
Data Conversion Specialist
Will work as part of a core project team comprised of Children, Youth and Social Service Cluster, and Child Parent Resource Institute to achieve the deliverables of the Electronic Medical Record Project.
Skills and Competencies
Data Conversion Specialist will be expected to hit the ground running and will use their expertise and attention to detail to help the project achieve a robust and comprehensive data migration approach.
Leadership Attributes:
•Proven experience as Data Conversion Specialist leading data migration planning and execution from a case management legacy platform to a modern technology platform e.g. SaaS.
•Knowledge and experience in successfully setting priorities and delivering quality results on time and on budget
•Ability to lead and determine suitable data migration performance measures
•Ability to create detailed migration plans, including step-by-step procedures
•Documentation of migration processes, configurations, and troubleshooting steps
Technical Competency:
•Experience in data migration staging, ETL process and tools
•Experience in SaaS Cloud-based technologies
•Experience with analyzing data in case management source systems, including flat files, to identify data cleanliness issues (e.g. missing values, duplicate meanings, and invalid data) and developing feedback processes to get corrupt data fixed in the source systems.
•Proficiency with both MS SQL and MySQL databases
•Proficiency in understanding source data structures (ColdFusion, MS SQL and MySQL) and mapping them to the target schema
•Understanding of database schema, data types, and query optimization
•Knowledge of migration tools and services for data transfer between on-premises databases and cloud platforms
•Demonstrated experience in designing data models and design artefacts, data architecture and mapping
•Experience with developing automation extraction, cleansing and scripting routines
•Experience with assessing existing data workloads, identifying dependencies, and planning the migration process
•Ability to analyze data structures, indexes, and constraints
•Awareness of security best practices during migration
•Understanding of encryption, access controls, and compliance requirements
•Troubleshooting skills to address migration issues, connectivity problems, and data inconsistencies
•Debugging experience with migration scripts and tools
•Relevant certifications such as ITIL, Microsoft Certified Solutions Expert (MCSE), or Certified Information Systems Security Professional (CISSP) are a plus
•Strong understanding of security and privacy best practices
Stakeholder Needs:
•Proven ability to communicate and partner effectively and anticipate stakeholder needs and expectations across a multi-sector environment
•Proven analytical abilities with the ability to propose and contribute to improvement strategies within legislative and policy parameters
•Collaboration with infrastructure teams, developers, security, architecture
FCIS and ideasWeb are legacy applications in use by the business client. They do not have third party vendor support.
FCIS Specifications:
•FCIS database is 2.9GB in size, contains 387 tables
•Citrix LTSR 2023 CU1
•SQL Server 2019, SP4
•A file server, accessed through the KIDS server, storing uploaded reports (MS Word and PDF)
•SSRS Reporting server used for KIDS reports
ideas WEB Specifications:
•ideas WEB database (MSSQL) is approximately 50GB in size, contains 140 tables
•Windows Server 2012 R2, Version 6.3.9600 Build 9600
•Database MySQL 5.6
•IIS v.8
•ColdFusion 2016 Application Server Standard Edition
•Tomcat Version 8.5.28.0
•Java Version 1.8.0_161
Qualifications
End to end experience in data migration
Proven experience as Data Conversion Specialist leading data migration planning and execution from a legacy platform to a modern technology platform eg. SaaS.
Experience case management
FCIS Specifications:
· FCIS database is 2.9GB in size, contains 387 tables
· Citrix LTSR 2023 CU1
· SQL Server 2019, SP4
· A file server, accessed through the KIDS server, storing uploaded reports (MS Word and PDF)
· SSRS Reporting server used for KIDS reports
Summary
If interested and qualified for this role, please apply today for immediate consideration!
Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.
Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.
show more
This is a contract position for a Data Conversion Specialist - Senior for our public sector client.
Work location: 5700 Yonge St.
Duration: Seven Months
7.25 hours/day
This is a Hybrid role that requires the candidate to be onsite 3 days of the week (This is a mandatory requirement of the role and is non-negotiable outside of exceptional circumstances.)
Advantages
Good compensation working on projects that will make a difference to the people of Ontario.
Responsibilities
•Responsible for developing and implementing the data migration strategy including project deliverables for completeness, quality, and compliance with established project standards
•Work with the Ministry and vendor team(s) to develop core data migration deliverables and requirements, data mapping and transformation rules
•Design and implement a data migration audit process to ensure data integrity and ability to mitigate/remediate data quality issues
•Manage the data migration deliverables throughout development to ensure quality and traceability to requirements
•Manage assigned risks and monitor potential impacts, including escalation as part of the data migration plan
...
•Support the Ministry and vendor test teams with the creation of test data
•Ensure test data conforms to data security requirements
•Perform data migration audit, reconciliation, and exception reporting for static and transactional data
•Ensure privacy and security access controls are followed for sensitive personal data in accordance with
•OPS standards and guidelines
•Ensure security in reporting and data warehousing
•Provide guidance to the project team and transferring knowledge and skills to these team members
Responsibilities:
•Oversees all facilities of the conversion process.
•Completes mapping, interfaces, mock conversion work, enhancements, actual conversion, and verifies completeness and accuracy of converted data.
•Establish a strong working relationship with all clients, interact effectively with all levels of client personnel, and provide conversion support.
•Analyzes and coordinates data file conversions.
•Works with importing files from heterogeneous platforms.
General Skills:
•Full life-cycle data conversion experience with Enterprise Resource Planning (ERP) Systems, including deployment experience
•Proficiency in query languages
•Familiarity with and construction of complex query statements
•Knowledge of various database structures
•Data analysis, investigative and logic skills
•Experience with data conversion scripts and tools
•Experience with overseeing /completing all tasks involved in the conversion process including data extraction, cleansing, transformation and loading
•Experience liaising with teams to understand to-be migration requirements.
•Establish a strong working relationship with all groups, interact effectively with all levels of client personnel, and provide conversion support.
•Experience completing mapping, interfaces, conversion work, documentation and verifying completeness and accuracy of converted data.
•Experience delivering the required system changes and/or working with the development team or a dedicated conversion team to specify loads programs.
•Experience providing support through the cutover process
•A team player with a track record for meeting deadlines, managing competing priorities and client relationship management experience
•Communication, facilitation, negotiation, consensus building, and problem-solving skills
Desirable Skills:
•Knowledge and experience in business case development
•Knowledge and understanding of Information Management principles, concepts, policies and practices
•Excellent understanding of master data and transactional data concepts and interdependencies
Experience and Skill Set Requirements
•Hybrid Assignment- As a result of current OPS direction, the successful candidate will be required to work on site in person at the work location listed in the RQ for a minimum of 2-3 days per week at discretion of HM.
•Successful candidate must reside in Ontario.
Data Conversion Specialist
Will work as part of a core project team comprised of Children, Youth and Social Service Cluster, and Child Parent Resource Institute to achieve the deliverables of the Electronic Medical Record Project.
Skills and Competencies
Data Conversion Specialist will be expected to hit the ground running and will use their expertise and attention to detail to help the project achieve a robust and comprehensive data migration approach.
Leadership Attributes:
•Proven experience as Data Conversion Specialist leading data migration planning and execution from a case management legacy platform to a modern technology platform e.g. SaaS.
•Knowledge and experience in successfully setting priorities and delivering quality results on time and on budget
•Ability to lead and determine suitable data migration performance measures
•Ability to create detailed migration plans, including step-by-step procedures
•Documentation of migration processes, configurations, and troubleshooting steps
Technical Competency:
•Experience in data migration staging, ETL process and tools
•Experience in SaaS Cloud-based technologies
•Experience with analyzing data in case management source systems, including flat files, to identify data cleanliness issues (e.g. missing values, duplicate meanings, and invalid data) and developing feedback processes to get corrupt data fixed in the source systems.
•Proficiency with both MS SQL and MySQL databases
•Proficiency in understanding source data structures (ColdFusion, MS SQL and MySQL) and mapping them to the target schema
•Understanding of database schema, data types, and query optimization
•Knowledge of migration tools and services for data transfer between on-premises databases and cloud platforms
•Demonstrated experience in designing data models and design artefacts, data architecture and mapping
•Experience with developing automation extraction, cleansing and scripting routines
•Experience with assessing existing data workloads, identifying dependencies, and planning the migration process
•Ability to analyze data structures, indexes, and constraints
•Awareness of security best practices during migration
•Understanding of encryption, access controls, and compliance requirements
•Troubleshooting skills to address migration issues, connectivity problems, and data inconsistencies
•Debugging experience with migration scripts and tools
•Relevant certifications such as ITIL, Microsoft Certified Solutions Expert (MCSE), or Certified Information Systems Security Professional (CISSP) are a plus
•Strong understanding of security and privacy best practices
Stakeholder Needs:
•Proven ability to communicate and partner effectively and anticipate stakeholder needs and expectations across a multi-sector environment
•Proven analytical abilities with the ability to propose and contribute to improvement strategies within legislative and policy parameters
•Collaboration with infrastructure teams, developers, security, architecture
FCIS and ideasWeb are legacy applications in use by the business client. They do not have third party vendor support.
FCIS Specifications:
•FCIS database is 2.9GB in size, contains 387 tables
•Citrix LTSR 2023 CU1
•SQL Server 2019, SP4
•A file server, accessed through the KIDS server, storing uploaded reports (MS Word and PDF)
•SSRS Reporting server used for KIDS reports
ideas WEB Specifications:
•ideas WEB database (MSSQL) is approximately 50GB in size, contains 140 tables
•Windows Server 2012 R2, Version 6.3.9600 Build 9600
•Database MySQL 5.6
•IIS v.8
•ColdFusion 2016 Application Server Standard Edition
•Tomcat Version 8.5.28.0
•Java Version 1.8.0_161
Qualifications
End to end experience in data migration
Proven experience as Data Conversion Specialist leading data migration planning and execution from a legacy platform to a modern technology platform eg. SaaS.
Experience case management
FCIS Specifications:
· FCIS database is 2.9GB in size, contains 387 tables
· Citrix LTSR 2023 CU1
· SQL Server 2019, SP4
· A file server, accessed through the KIDS server, storing uploaded reports (MS Word and PDF)
· SSRS Reporting server used for KIDS reports
Summary
If interested and qualified for this role, please apply today for immediate consideration!
Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.
Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.
show more