Current jobs related to Data Conversion Specialist - Toronto - Cleo Consulting

  • Azure Synapse Data Engineer

    2 weeks ago

    Toronto, Ohio, United States Mastech Digital Full time

    Job Title: Azure Synapse Data EngineerJob Summary:Mastech Digital is seeking an experienced Azure Synapse Data Engineer to join our team. As a key member of our consulting domain, you will be responsible for designing, implementing, and maintaining large-scale data warehouses and big data ecosystems on the Microsoft Azure platform.Key Responsibilities:-...

  • Senior Privacy Specialist

    3 weeks ago

    Toronto, Ohio, United States Emp IT Solutions Full time

    Job Title: Privacy Impact Assessment Specialist SeniorEmp IT Solutions is seeking a highly skilled Privacy Impact Assessment Specialist Senior to join our team. As a key member of our organization, you will be responsible for conducting privacy impact assessments and providing expert advice on complex health privacy issues.Key Responsibilities:Conducting and...

  • Privacy Impact Assessment

    4 weeks ago

    Toronto, United States Emp IT Solutions Full time

    Job Description: RQ00176 - Privacy Impact Assessment (PIA) Specialist SeniorSubmission Closing: Oct 14 4pmStart Date: 2024-10-28End Date: 2025-03-31Extension # of Days: 252.00Max Extension Term(s): 2 TimesAssignment type: HybridLocation: 525 University Avenue. Toronto, OntarioJob Title: RQ-2024-007266- Privacy Impact Assessment (PIA) Specialist -...

  • Systems Testing/QA Specialist Senior

    3 weeks ago

    Toronto, United States Emp IT Solutions Full time

    Job Description: RQ07411 - Systems Testing/QA Specialist SeniorSubmission Closing: Oct 22 11amStart Date: 2024-10-28End Date: 2025-03-31Assignment type: OnsiteLocation: Toronto, OntarioJob Title: Systems Testing/QA SpecialistDescriptionResponsibilities: Provides advice on the testing strategy, test plans, the selection of testing tools, and the...

  • Inclusion Specialist

    2 weeks ago

    Toronto, Ohio, United States Infrastructure Ontario Full time

    Job SummaryInfrastructure Ontario is seeking an Inclusion Specialist to enhance organizational culture and integrate diversity, equity, and inclusion principles. The successful candidate will address systemic racism, ensure equitable representation, and lead training programs on human rights and anti-discrimination.Key ResponsibilitiesIntegrate and lead...

  • Packaging Engineer

    1 month ago

    Toronto, United States Stefanini Full time

    Stefanini Group is hiring! Stefanini is looking for a Packaging Engineer in Toronto, ON CAN (Onsite) For quick apply, please reach out to Madelaine MADIE Yu Call: / Email: Are You Ready to Make It Happen? Join our Mission to Lead the Future of Snacking. Make It with Pride. This position reports to the Packaging Lead for Canada businesses. You will be...

  • Revenue Operations Specialist

    2 weeks ago

    Toronto, Ohio, United States MaintainX Full time

    About the RoleMaintainX is a leading mobile-first workflow management platform for industrial and frontline workers. As a Revenue Operations Analyst, you will support stakeholders across multiple cross-functional teams, driving strategic growth and providing analytical support to optimize operational processes and contribute to strategic planning efforts.Key...

  • OTC Derivatives Business Solutions Specialist

    3 weeks ago

    Toronto, Ohio, United States Luxoft USA Inc Full time

    Job Title: OTC Derivatives Business AnalystJoin Luxoft USA Inc as a key member of our Business Intelligence, Performance Systems and Analytics team. We are seeking a highly skilled OTC Derivatives Business Analyst to contribute to the development of our business intelligence capabilities.Key Responsibilities:Develop a deep understanding of portfolio and deal...

  • Senior Systems Support Specialist

    1 month ago

    Toronto, Ohio, United States Experis Full time

    Job DescriptionWe are seeking a highly skilled Senior Systems Support Analyst to join our team at Experis. The successful candidate will be responsible for providing technical support and maintenance for our IT infrastructure.Key Responsibilities:Provide technical support and maintenance for Citrix XenApp, VMWare, and LPAR Windows and AIX servers.Configure...

  • Business Development Manager

    3 days ago

    Toronto, United States Esprow Full time

    Esprow is looking for an experienced, ambitious, and astute Business Development Manager to build a network of distribution and integration partnersCompany DescriptionEsprow is a highly innovative and fast-growing company with some of the world's highest profile companies as our clients. Working with us, you will be exposed to innovative and cutting-edge...

  • Plant Quality Manager

    2 weeks ago

    Toronto, United States Precision Castparts Corp Full time

    Country United States of America State / County Ohio City Toronto Division Metals Company Toronto Function Quality Workplace Type On-Site Position type Full Time Opportunity ID 14695 Company ProfileWith more than 120 operations and approximately 20,000 employees worldwide, Precision...

  • Business Development Manager

    4 days ago

    Toronto, United States Esprow Full time

    Esprow is looking for an experienced, ambitious, and astute Business Development Manager to build a network of distribution and integration partners Company Description Esprow is a highly innovative and fast-growing company with some of the world's highest profile companies as our clients. Working with us, you will be exposed to innovative and cutting-edge...

  • Business Development Manager

    5 days ago

    Toronto, United States Esprow Full time

    Esprow is looking for an experienced, ambitious, and astute Business Development Manager to build a network of distribution and integration partners Company Description Esprow is a highly innovative and fast-growing company with some of the world's highest profile companies as our clients. Working with us, you will be exposed to innovative and cutting-edge...

  • Marketing Manager, Canada

    3 months ago

    ON-Toronto, United States GRIFOLS, S.A. Full time

    table.MiTabla { max-width: 1020px;!important Would you like to join an international team working to improve the future of healthcare? Do you want to enhance the lives of millions of people? Grifols is a global healthcare company that since 1909 has been working to improve the health and well-being of people around the world. We are leaders...

Data Conversion Specialist

2 months ago

Toronto, United States Cleo Consulting Full time
Assignment: RQ07688 Data Conversion Specialist Senior Job Title: Data Conversion Specialist Requisition (SS): RQ07688 Start Date: End Date: Client: Children Youth & Social Services Cluster Office Location: 5700 Yonge St. Toronto Organization: Children Youth & Social Services Cluster Extension # of Days: 248.00 Ministry: Ministry of Children Community and Social Services # Business Days: 142.00

Note: 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 23 days per week at discretion of HM. Successful candidate must reside in Ontario.

Must Haves:

  • 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

Description

Detailed 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 lifecycle 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 tobe 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 problemsolving 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

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: (50%)

  • Proven experience as Data Conversion Specialist leading data migration planning and execution from a case management legacy platform to a modern technology platform eg. 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 stepbystep procedures
  • Documentation of migration processes configurations and troubleshooting steps

Technical Competency: (40%)

  • Experience in data migration staging ETL process and tools
  • Experience in SaaS Cloudbased 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 onpremises 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: (10%)

  • Proven ability to communicate and partner effectively and anticipate stakeholder needs and expectations across a multisector 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

ideasWeb Specifications:

  • ideasWeb 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.0161