Etl informatica developer • old toronto on
We are seeking an experienced Senior Software Developer - ETL to design, build, and continuously expand enterprise data pipelines, data warehouses, and business intelligence solutions.In this role,... Show more
ETL and Data warehouse experience.Synapse OR Azure services is nice to have.Candidates only Physically in Canada having Valid Canadian Work Authorization will be considered.NO VISA SPONSORSHIP will... Show more
Sync is Canada’s largest cloud storage provider and a global leader in secure file sharing and document collaboration.We’re expanding into the enterprise market, and we need your help.Join us as we... Show more
ShoreWise Consulting is a world class IT solution provider offering technology solutions and managed services in verticals such as Customer Contact, Healthcare and Finance (banking & trading).Using... Show more
Job Title: ETL Lead Developer <p><b>Job Type:</b> Full Time<br /> <b>Location:</b> Toronto, ON (Onsite)<br /> <b>Number of Positions:</b> 5<... Show more
Employment Ontario’ is one of the major programs delivered by the Employment and Training Division of the Ontario Ministry of Training, Colleges and Universities.Employment Ontario helps the citize... Show more
Contribute to development activities within the Scrum team, supporting sprint objectives and project milestones.Write well‑designed, testable, and efficient code using best software development pra... Show more
Our Technology team wakes up every day with one goal in mind - connecting Canadians to the people and things that matter most.Together, we are proud to support 30 million Canadians each month throu... Show more
Join us in building the future of finance.Our mission is to democratize finance for all.The largest transfer of wealth in human history.If you’re ready to be at the epicenter of this historic cultu... Show more
ONSITE 5 days(182 business days) - possible extension .Extensive experience in gathering requirements and business process knowledge in order to design correct and high-quality data transformation.... Show more
CoreFactor is searching for an ETL Tester on a contract basis for a Financial Services client in the GTA.This position is hybrid and will require the successful incumbent to go into the office four... Show more
At Interac, we protect both — driving trust, security, and inclusion, so our digital economy thrives.Founded in 1984, Interac connects Canadians through secure digital payments, advanced identity v... Show more
Senior Informatica PowerCenter Developer - IDMC / IICS.Key Requirements & Responsibilities.ETL development experience in large IT organizations.Minimum 5 years of strong hands-on development ex... Show more
Senior Business Systems Analyst – Data Integration (ETL, Databricks/Snowflake) -.Months initial (Extension until EOY confirmed).Toronto, Winnipeg (Hybrid 3x/week).The successful candidate will have... Show more
A stealth new app created by Fintros AI is launching in September 2021.In less than 180 days, our app has attracted 150,000 jobs across 500+ companies.By 2023, our company will power the talent att... Show more
Toronto, Ontario, Canada — Hybrid.We are seeking a Quantitative Developer with strong expertise in quantitative finance and advanced proficiency in Python.This role focuses on building and implemen... Show more
Join us as we change healthcare for the better.OceanMD, a WELLSTAR Company, is the leading provider of EMR-integrated Patient Engagement and eReferral tools in Canada, playing a critical role in mi... Show more
Senior Software Developer – ETL.A modernization initiative is replacing legacy technology, increasing standardization of processes, and integrating systems across multiple business lines.The initia... Show more
We are seeking an experienced Senior Software Developer - ETL to lead and oversee the end-to-end data and document migration strategy for enterprise modernization initiatives. In this role, you will be responsible for analyzing, profiling, cleansing, and transforming legacy data structures and document attachments into modernized cloud database solutions. Leveraging advanced ETL tools, complex SQL development, and relational database expertise across Oracle, MS SQL Server, and Azure SQL Database, you will develop detailed technical specifications, construct automated data migration pipelines, conduct mock conversions, and ensure data integrity through post-migration reconciliation and audit controls.
Location: Toronto, ON (Fully Onsite – 5 days/week required)
Duration: 10-month contract.
Advantages
Modern Cloud Stack: Hands-on experience with Azure Data Factory, Azure SQL Database, and cloud storage architectures.
End-to-End Migration Scope: Lead the full conversion lifecycle spanning data profiling, attachment migration, mock conversions, and cutover.
Complex Data Integration: Work across diverse relational and non-relational database structures, including Oracle, MS SQL Server, and legacy mainframe data formats.
Dedicated Onsite Collaboration: Collaborate directly alongside senior database administrators, enterprise architects, and technical leads in a focused 5-day per week workspace.
Responsibilities
ETL & Data Migration Leadership: Design, develop, document, and execute full-lifecycle data and file migration solutions to transition legacy systems to modernized platforms.
Data Profiling & Cleansing: Analyze source data across heterogeneous platforms, conduct comprehensive data profiling, and implement pre- and post-migration data cleansing routines.
Pipeline & Interface Engineering: Build, configure, and maintain scalable ETL/ELT pipelines using Azure Data Factory, Informatica, and custom conversion scripts.
Complex Database Development: Write and optimize complex SQL queries, PL/SQL routines, and data extraction scripts across Oracle, MS SQL Server, and Azure SQL Database environments.
Document Attachment Migration: Lead the extraction, mapping, and transfer of legacy document attachments and binary files to modern cloud storage repositories.
Migration Artifact Documentation: Author data migration strategies, detailed source-to-target mapping documents, data dictionaries, interface definitions, and business case justification files.
Validation, Audit & Cutover Support: Conduct mock conversions, establish testing strategies, execute post-migration data reconciliation, generate exception reports, and provide cutover support.
Qualifications
ETL & Data Conversion Experience: 7+ years of experience developing, executing, and documenting ETL processes for large-scale data conversion and migration projects (Strictly Required).
Modernization & Migration Planning: Extensive experience with data migration planning, legacy-to-cloud application transformations, and data conversion methodologies (Strictly Required).
Relational Database & Complex SQL: Advanced expertise with relational databases (Oracle, MS SQL Server, Azure SQL Database) and complex SQL/PL-SQL query development (Strictly Required).
Document & File Attachment Migration: Proven experience migrating document attachments and binary files from legacy applications to modernized solutions (Strictly Required).
Cloud Database & ETL Tooling: Demonstrated experience with cloud database platforms (Azure SQL) and leading ETL tools such as Azure Data Factory or Informatica (Strictly Required).
Technical Documentation: Hands-on experience creating ETL mappings, data dictionaries, migration strategies, and technical specifications (Strictly Required).
Nice-to-Have Assets:
Prior data migration or ETL development experience within a public sector or enterprise environment.
Knowledge of mainframe data formats, segments, and non-relational data structures.
Experience with case management data models and master data management (MDM) concepts.
Summary
If you're interested in the "Senior Software Developer - ETL" role based in Toronto, we encourage you to apply online at www.randstad.ca.
Only qualified candidates will be contacted for the next steps. We look forward to hearing from you!
Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.
Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.
