Senior Software Developer – ETL - 26-14972

Senior Software Developer – ETL
Location: Toronto, ON (Onsite)
Duration: 250 days
Employment Type: Contract

Job Summary
A modernization initiative is replacing legacy technology, increasing standardization of processes, and integrating systems across multiple business lines. The initiative is centered on an end-to-end digital solution supporting e-filing, document management and sharing, case management, scheduling, and a public portal. It will modernize how services are delivered and administered by providing accessible online options to a broad range of users, including self-represented individuals, legal professionals, public sector users, and staff.

A senior Software Developer (ETL) is required to provide best-practice migration solutions and oversee all facilities of the data and file migration from a legacy application to a new solution.

Responsibilities

• Provide best-practice migration solutions and oversee all facilities of data and file migration from the legacy application to the new solution
• Establish strong working relationships with clients, interact effectively at all levels, and analyze legacy data and files stored in a variety of data sources and formats
• Analyze and complete data profiling, and suggest pre-migration data cleansing activities
• Complete the data migration strategy, data mapping, interface definition, mock conversion, enhancement definition, and actual conversion
• Translate technical system specifications into working, tested applications, including developing detailed programming specifications, writing and/or generating code, compiling data-driven programs, maintaining code, and conducting unit tests
• Resolve and troubleshoot technical problems that arise during the use and operation of software packages, including technical assistance with implementation, conversion, and migrations
• Import files from heterogeneous platforms and coordinate data file migration
• Define the testing strategy, plan, and conduct testing to ensure data integrity and data comparisons
• Perform post-migration audit and data reconciliation
• Generate data migration exception reports and perform data cleansing as required
• Provide pre- and post-conversion support to business clients
• Provide periodic status reports and present the data migration strategy and approach to executives and other stakeholders
• Transfer knowledge (code and all assigned documentation) to the Project Manager and team members through 1:1 meetings, team meetings, and documentation on a shared SharePoint site throughout the project life cycle

Mandatory Requirements

• 7+ years of experience developing and documenting ETL for data conversion and migration projects
• Extensive experience in data migration and migration planning for digital transformation initiatives, including migrating data from legacy applications to modernized solutions using ETL methodologies
• Extensive experience with various database structures and RDBMS such as Oracle, MS SQL Server, and Azure SQL Database, including writing complex SQL queries, conducting data analysis and data validation, and solving complex technical problems
• Experience migrating document attachments from legacy solutions to a new modernized solution
• Experience working with cloud database technologies (e.g., Azure SQL)
• Experience with ETL tools such as Azure Data Factory, Informatica, or similar
• Experience developing documentation such as ETL mappings, data dictionaries, business cases, and data migration strategies and plans
• Knowledge and understanding of Information Management principles, concepts, policies, and practices
• Excellent understanding of master data and transactional data concepts and interdependencies

Desired Skills and Experience

• Full life-cycle data conversion experience with enterprise systems, including deployment experience
• Experience with all steps of data migration, including data profiling, data mapping, developing migration solutions, data validation, and audit
• Proficiency in query languages such as SQL and PL/SQL, including construction of complex query statements from multiple data sources
• Exceptional knowledge of relationships between tables
• 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 migrating file attachments from legacy applications to the new solution, including file migration from storage such as Azure Blob, Azure File Share, SharePoint, and Oracle BLOBs
• Experience with data conversion scripts and ETL tools such as Informatica and Azure Data Factory
• Experience overseeing and completing all tasks in the conversion process, including data extraction, profiling, cleansing, transformation, and loading
• Experience liaising with teams to understand to-be migration requirements
• 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 required system changes and/or working with the development team or a dedicated conversion team to specify load programs
• Experience providing support through the cutover process
• Knowledge of case management data models and experience migrating data from large case management applications
• Previous experience working in government or public sector organizations
• Team player with a track record of meeting deadlines, managing competing priorities, and client relationship management
• Communication, facilitation, negotiation, consensus-building, and problem-solving skills