RQ10574 - Sr. Software Developer - ETLSource Code • Toronto, ON, Canada

RQ10574 - Sr. Software Developer - ETL

Source Code • Toronto, ON, Canada

11 days ago

Job type

Full-time

Quick Apply

Job description

RQ10574 - Sr. Software Developer - ETL

1-year contract (250 business days) - 1 possible extension

ONSITE 5 days a week - College St. Toronto

Security Level : CRJMC

Scope

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

Assignment Deliverables

Provide best practice migration solutions and oversee all facilities of the data and files migration from legacy application to a new solution.

Establish a strong working relationship with clients, interact effectively at all levels and analyses legacy data and files stored in a variety of data sources and formats.

Analyze and complete data profiling and suggest any pre migration data cleansing activities.

Complete data migration strategy, data mapping, define interfaces, perform mock conversion, define enhancements and perform actual conversion.

Required to translate technical systems specifications into working, tested applications. This includes developing detailed programming specifications, writing and / or generating code, compiling data-driven programs, maintaining, and conducting unit tests.

Resolve and troubleshoot technical problems which arise during the use and operation of software packages, including technical assistance in implementation, conversion and migrations

Work with importing files from heterogeneous platforms and coordinates data file migration.

Define testing strategy, plan and conducts testing to ensure data integrity and data comparisons.

Perform post migration audit and data reconciliation.

Generate data migration exception reporting and perform data cleansing as required.

Provides pre- and post-effective conversion support to business clients

Desired Skills and Experience

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

MUST HAVES

7+ years of experience in developing and documenting ETL for data conversion and migration

Extensive experience in data migration and migration planning in terms of digital transformation, ETL experience in migrating data from legacy applications to modernized solutions.

Extensive experience with various database structures and RDMS like Oracle, MS SQL Server, Azure SQL Database, and write complex SQL queries, conduct data analysis, data validation, and solve complex technical problems

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 with ETL tools such as Azure Data Factory, Informatica, etc.

Experience in development of documentation such as ETL mappings, data dictionaries, 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.

Create a job alert for this search

RQ10574 Sr Software Developer ETL • Toronto, ON, Canada

Similar jobs

Senior ETL Engineer

DeFi Planet • Toronto

Full-time

Senior ETL EngineerScotiabankTorontoRequisition ID : 238183 Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture. The Team • • • We are the CRM, Sales...Show more

Last updated: 24 days ago • Promoted

Sr Software Engineer

Synopsys, Inc. • Markham

Full-time

At Synopsys, we drive the innovations that shape the way we live and connect.Our technology is central to the Era of Pervasive Intelligence, from self-driving cars to learning machines.We lead in c...Show more

Last updated: 24 days ago • Promoted

Sr. Integration Developer

Align Technology • Toronto, Ontario, CA

Full-time

Quick Apply

We’re seeking a Senior Integration Developer to join the Treatment Planning team and drive innovation in release and documentation workflows for regulated medical software.You’ll design and impleme...Show more

Last updated: 4 days ago

Senior ETL Developer

Encore Technical Solutions Inc. • Markham

Full-time

A degree in Computer Science, Software Engineering, or comparable professional experience.CDC techniques, and crafting / optimizing SQL queries. MS SSIS / SSDT and Pitney Bowes migration utilities.Famil...Show more

Last updated: 15 days ago • Promoted

Sr. Integration Developer

Align Technology, Inc. • Toronto

Full-time

Last updated: 2 days ago • Promoted

Senior ETL Tester

CGI • Toronto

Full-time

This role is hybrid and requires you to be at a Client office in downtown, Toronto at a minimum 4 days per week - subject to change at any time. We are seeking a highly skilled professional with str...Show more

Last updated: 30+ days ago • Promoted

Sr. Software Applications Engineer

Qualcomm • Markham

Full-time

Engineering Group, Engineering Group > .Software Applications Engineering.Automotive is the first major industry that Qualcomm is disrupting by building on our foundational leadership, differentiati...Show more

Last updated: 24 days ago • Promoted

Sr ETL Developer

Bevertec • Toronto

Full-time

Designing and developing scalable Medallion Data Lakehouse architectures.Expertise in data ingestion, transformation, and curation using Delta Lake and Databricks. Experience integrating structured ...Show more

Last updated: 21 days ago • Promoted

Senior Consultant- ETL Dev

Virtusa • Toronto

Full-time

Senior Consultant- ETL Dev - ( CREQ125383 ).Job Description for ETL Application Developer.Accountable for the design, development, testing and support of applications utilized in Lines of Business ...Show more

Last updated: 24 days ago • Promoted

Senior ETL Engineer

Swagher • Toronto

Full-time

Last updated: 24 days ago • Promoted

ETL Developer

Tata Consultancy Services • Toronto

Full-time

Tata Consultancy Services (TCS) is an equal opportunity employer, and embraces diversity in race, nationality, ethnicity, gender, age, physical ability, neurodiversity, and sexual orientation, to c...Show more

Last updated: 6 days ago • Promoted

Senior ETL Engineer

Women Thrive Magazine • Toronto

Full-time

Last updated: 24 days ago • Promoted

RQ10584 - Software Developer - ETL - Senior

Maarut • Toronto, ON, ca

Full-time

Quick Apply

Contribute to and support design, development, and maintenance of ETL processes using Informatica Cloud (.Migrate Informatica PowerCentre v10. ETL code including embedded SQL and PL / SQL code develop...Show more

Last updated: 3 days ago

ETL Developer

Compunnel, Inc. • Toronto

Full-time

We are seeking a skilled ETL Developer to support our data integration and transformation initiatives.The ideal candidate will have hands-on experience in ETL / ELT development, data warehousing, and...Show more

Last updated: 24 days ago • Promoted

Ab Initio ETL Developer

Adastra Corporation • Markham

Full-time

Join our team at Adastra as a Senior Ab Initio ETL Developer and be at the forefront of enterprise data solutions.In this role, you will lead ETL development, provide expert guidance, and collabora...Show more

Last updated: 24 days ago • Promoted

Sr. Software Development Engineer

Advanced Micro Devices • Markham

Full-time

WHAT YOU DO AT AMD CHANGES EVERYTHING.At AMD, our mission is to build great products that accelerate next-generation computing experiences—from AI and data centers, to PCs, gaming and embedded syst...Show more

Last updated: 24 days ago • Promoted

Sr. Software Development Engineer

AMD • Markham

Full-time

What you do at AMD changes everything.At AMD, our mission is to build great products that accelerate next‑generation computing experiences—from AI and data centers to PCs, gaming, and embedded syst...Show more

Last updated: 24 days ago • Promoted

Senior ETL Engineer

Thebusinessyear • Toronto

Full-time

Last updated: 24 days ago • Promoted