• Skip to primary navigation
  • Skip to main content
  • Skip to footer
  • Email
  • Facebook
  • Instagram
  • LinkedIn
  • Twitter

1.844.822.0541

info@nexusgroup.ca

  • English
    • Français
  • Consultant Login
  • Find Your Opportunity
Nexus Systems Group

Nexus Systems Group

  • Home
  • What We Do
    • Staffing Solutions Made Easy
    • Contingent Workforce Management and Payroll Solutions
    • Technology Consulting and Delivery
  • Who We Serve
  • Who We Are
    • Our Team
    • News and Awards
    • Associations and Community
  • Contact Us
  • News

ETL Developer

April 26, 2024 by

Software Developer – ETL – Senior
Government Services 
Security Level – Enhanced (Must have)
Downtown Toronto – 3 days onsite
2024-06-03 – 2025-03-31 and two extensions

MANDATORY REQUIREMENTS:

• 7+ years of experience in developing data conversion and migration
• Extensive experience in data migration in terms of digital transformation,ETL experience in migrating data from legacy applications to modernized solutions.
• Experience in migrating document attachments from legacy solution to a new modernized solution.
• Experience working in cloud DB technologies (such as Azure SQL).
• Experience working in ETL tools such as Azure Data Factory, Informatica, etc.
• Knowledge and experience in development of business case, data migration strategy and plan.
• Knowledge and understanding of Information Management principles, concepts, policies and practices.
• Excellent understanding of master data and transactional data concepts and interdependencies.

SKILLS AND KNOWLEDGE:

• Full life-cycle data conversion experience with enterprise systems, including deployment experience.
• Experience working with all steps of data migration activities such as data profiling, data mapping, developing data migration solutions, data validation and audit.
• Proficiency in query languages such as SQL, PL-SQL.
• Familiarity with and construction of complex query statements.
• Knowledge of various database structures and RDMS like Oracle DB and MS SQL Server, Azure SQL Database, and write complex SQL queries
• Knowledge and understanding of mainframe data formats, data types, segments and non-relational data structures
• Experience ensuring the data migration solution is scalable.
• Data analysis, investigative and logic skills with high attention to detail
• Experience with migrating file attachments from legacy applications to new solution.
• Experience with data conversion scripts and various ETL tools such as Informatica, Azure Data Factory, etc.
• 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

CRITERIA:

Criteria 1 – Data Knowledge Expertise Skills (35 Points)
• 7+ years of experience in developing data conversion and migration
• At least one experience of working with migrating data from different legacy platforms to a new solution.
• Full life-cycle data conversion experience with enterprise systems, including deployment experience.
• Data analysis, investigative and logic skills, including the ability to troubleshoot and solve complex technical problems.
• Experience with overseeing /completing all tasks involved in the conversion process including data extraction, profiling, cleansing, import data, manipulate data, transformation and loading.
• Experience liaising with teams to understand to-be migration requirements.
• Knowledge and understanding of Information Management principles, concepts, policies and practices.
• Experience providing support through the cutover process.
• Knowledge of data model of case management solutions and experience in data migration/conversion of large case management applications.
• Experience with migrating attachment files from legacy applications to new solution.
• Experience with document migration

Criteria 2 – Technical Skills (35 Points)
• Experience with industry leading ETL tools such as Informatica, Azure Data Factory and cloud technologies.
• Proficiency in query languages such as Oracle SQL, PL-SQL, SQL Server, etc.,
• Exceptional level of knowledge on relationships between tables to perform and construct complex query statements from multiple data sources.
• Knowledge of various database structures and RDMS like Oracle, MS SQL Server, Azure SQL Database, and write complex SQL queries, etc.,
• Knowledge and understanding of mainframe data formats, data types, segments and non-relational data structures
• Data analysis, investigative and logic skills with high attention to details, including ability to troubleshoot and solve complex technical problems.
• Experience with data conversion scripts and tools.
• Experience with file migration from different file storages such as Azure BLOB, Azure file share, SharePoint, Oracle BLOBs.
• Experience completing mapping, interfaces, conversion work, data exclusion and inclusion, documentation and verifying completeness and accuracy of converted data, including data dictionary development and updates.
• Experience delivering the required system changes and/or working with the development team or a dedicated conversion team to specify loads programs.

Criteria 3 – Communication Skills (25 Points)
• Communication, facilitation, negotiation, consensus building, and problem-solving skills
• Provide periodic status reports, present data migration strategy and approach to executives and other stakeholders

Criteria 4 – Public Sector Experience (5 Points)
• Previous experience working in Government or Public Sector organizations

 

  • Apply Now
  • See All Jobs

Footer

ABOUT NEXUS SYSTEMS GROUP

Nexus is one of North America’s leaders in the provision of technology staff augmentation and strategic resource consulting. With a team of talented professionals using best of breed methodologies, Nexus consistently over delivers with quick, quality and trusted results to its clients and consultants.

LATEST OPPORTUNITIES

  • Senior DBA June 11, 2025
  • Senior Developer – ServiceNow June 10, 2025
  • Business Systems Analyst – ServiceNow June 10, 2025
  • Business Continuity/Disaster Recovery Consultant June 9, 2025

SOCIAL

  • Email
  • Facebook
  • Instagram
  • LinkedIn
  • Twitter
Report on Business Canada's Top Growing Companies - Nexus Group
Nexus Group Growth 500 2019
Nexus Systems Group Growth 500 2018
NEXUS GROUP SYSTEMS GROUP INC. NEXUSGROUP.CA
  • Contact Us
  • Terms & Conditions
  • Privacy Policy