Sr. ETL Developer

Full Time
  • Full Time
  • Toronto


Job Description:

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


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


To apply, please visit the following URL: