Senior ETL Developer

Wirehead; Toronto; On-site; CAD 80,000 - 100,000; Full time

Job summary

An established industry player is seeking a skilled data migration specialist to lead critical projects involving the transition of data from legacy systems to modern solutions. This role demands extensive experience in ETL processes, cloud technologies, and a strong understanding of data management principles. You will work collaboratively with teams to ensure seamless data conversions while troubleshooting complex issues. Join a dynamic environment where your expertise will directly influence successful digital transformations and contribute to innovative solutions in the realm of information technology. If you are passionate about data and eager to make a significant impact, this opportunity is perfect for you.

Qualifications

• 7+ years of experience in data conversion and migration required.
• Proficiency in ETL tools and cloud technologies essential.
• Strong data analysis and troubleshooting skills needed.

Responsibilities

• Oversee data migration processes from legacy to modern systems.
• Develop data migration strategies and business cases.
• Ensure data accuracy and integrity during migration.

Skills

Data Migration

ETL Experience

Cloud DB Technologies

Data Analysis

Troubleshooting

Document Migration

Information Management Principles

SQL Proficiency

Tools

Azure Data Factory

Informatica

Oracle SQL

SQL Server

Job description

This range is provided by Wirehead. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

Base pay range

CA$85.00/hr - CA$90.00/hr

Skills, Knowledge, Experience, and Qualifications:

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.

Resumes Evaluation/Criteria:

• 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

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

PREFERRED SKILLS

HOW TO APPLY

Matt Dawson is hiring for this position.

Apply to this position through LinkedIn Easy Apply or Email us at: [e-mail]

Interested in working with us in the future?

Privately share your profile with us: [e-mail]

Follow Wirehead on LinkedIn.

We thank all candidates for their interest but advise that only candidates selected for interviews will be contacted directly. Rest assured that your resume will be kept on our database and will be considered for all future opportunities.

Applicants must be authorized to work in Canada.

Seniority level

• Mid-Senior level

Employment type

• Contract

Job function

• Consulting, Information Technology, and Engineering
• Industries: Government Administration