Software Developer
Job Description
One (1) Software Developer ETL – Senior
Security clearance or 5 years of PR in Canada or Citizen
Hybrid, Toronto, Ontario, Canada
Contract
Must have skills:
• 7+ years of experience in developing data conversion and migration
• At least one experience migrating data from 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 overseeing /completing all tasks involved in the conversion process including data extraction, profiling, cleansing, importing data, manipulating 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 models 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 solutions.
• Experience with document migration
• 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 of 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 detail, including the 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, and 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 load programs.
• Communication, facilitation, negotiation, consensus-building, and problem-solving skills
• Provide periodic status reports, present data migration strategy and approach to executives and other stakeholders
Please send your resume to jim.nickolson@noramtec.com
Only qualified candidates will be contacted for an interview
