Etl informatica developer • toronto on
We are seeking an experienced Senior Software Developer - ETL to lead the design, development, and optimization of enterprise-grade data pipelines and data warehousing solutions.In this role, you w... Show more
Venture outside the ordinary - TMX Careers.The TMX group of companies includes leading global exchanges such as the Toronto Stock Exchange, Montreal Exchange, and numerous innovative organizations ... Show more
IDMC Developer – Informatica, IICS, SQL & ETL.Key Requirements & Responsibilities.ETL development experience in large IT organizations.Minimum 5 years of strong hands-on development experie... Show more
Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture.Contributes to the overall success of the Information Technology & Solutions (IT&S) glo... 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.J... 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: Boomi Developer Role: FT Location: Toronto, Canada Job Description: Strong experience in designing and implementing EDI and A2A solutions using Boomi platform.Monitor and maintain EDI an... 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
As a Quantitative Developer in RBC Global Asset Management’s Toronto office, you will be a key partner to the Quantitative Research and Investments team.You will deliver custom technology and analy... Show more
Our client is looking for an Android Developer to join their team.Must have skills required for this role.Minimum 4 years experience in Android SDK development, Mobile development with Java and Kot... Show more
Job Title:</b> Quadient Developer<br /> <b>Location:</b> Toronto, ON<br /> <b>Work Arrangement:</b> Hybrid 4 Days Onsite<br /> <b>Job Type:... Show more
Based in San Francisco, California, Turing is the world’s leading research accelerator for frontier AI labs and a trusted partner for global enterprises deploying advanced AI systems.Turing support... Show more
Join us as we change healthcare for the better.OceanMD, a WELL Health Company, is the leading provider of EMR-integrated Patient Engagement and eReferral tools in Canada, playing a critical role in... 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 impleme... Show more
Join Livingston and grow your career in the constantly changing world of international trade.Livingston is a market leader offering customs brokerage, international trade consulting, compliance and... 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
We are seeking a highly accomplished Senior Software Developer - ETL for an enterprise-level contract opportunity based in Toronto. In this role, you will take on a premier data engineering and integration capacity, specializing in designing, developing, migrating, and optimizing complex ETL processes and data pipeline architectures.
As a principal ETL developer, you will bridge the gap between legacy data infrastructure, enterprise data warehouses, and modern cloud integration platforms. Operating within a hybrid work model, you will lead the code migration from Informatica PowerCenter to Informatica Intelligent Data Management Cloud (IDMC), tune complex PL/SQL procedures, design star and snowflake data warehouse schemas, and ensure seamless end-to-end data pipelines across multi-tier environments. This position demands a seasoned technical authority who can perform root-cause analysis, drive query optimization, and deliver scalable data assets.
Location: Toronto, ON
Assignment Type: Hybrid (3 days per week onsite)
Contract Duration: 2-month contract (with potential for extension)
Advantages
High-Visibility Modernization: Lead complex cloud migration initiatives transitioning legacy Informatica PowerCenter environments to Informatica Intelligent Data Management Cloud (IDMC).
Advanced Data Engineering Stack: Expand technical depth across Informatica IDMC, Oracle PL/SQL, Azure Data Factory, Azure SQL Server, and cloud data warehouse architectures.
Complex Performance Tuning: Drive deep query optimization, database troubleshooting, and data pipeline scalability across large-scale datasets.
Flexible Working Model: Enjoy a balanced work structure combining collaborative onsite teamwork in Toronto with remote flexibility.
Responsibilities
Design, build, automate, and maintain robust ETL/ELT processes and data pipelines utilizing Informatica Intelligent Data Management Cloud (IDMC) and PL/SQL.
Migrate legacy Informatica PowerCenter v10.2 mappings, embedded SQL, and PL/SQL stored procedures developed on Oracle 11g and 19c to modern cloud environments.
Perform data extraction, transformation, and loading (ETL) from diverse relational and non-relational source systems into dimensional data warehouses (star and snowflake schemas).
Conduct performance tuning, query optimization, and root-cause analysis on complex SQL queries, stored procedures, packages, and database scripts.
Translate complex business specifications and functional requirements into fully tested, documented applications and data integration pipelines.
Collaborate with cross-functional project teams, business analysts, and QA leads to execute unit testing, debugging, and validation of ETL workflows.
Create de-normalized data assets from normalized relational databases and load them into destination database management systems.
Author comprehensive technical design documentation, deployment guides, interface specifications, and operational support materials.
Support database administration tasks, including configuration, backup/recovery, refresh procedures, user role management, and storage allocation using RMAN and Oracle utilities.
Participate actively in Agile/Scrum development cycles, sprint planning, and post-implementation knowledge-transfer sessions.
Qualifications
Core Requirements & Technical Expertise
ETL & Data Warehousing Tenure: 5+ years of progressive hands-on experience designing, developing, and supporting enterprise ETL processes, dimensional data modeling, and star/snowflake warehouse schemas.
Informatica Expertise: Proven experience with Informatica PowerCenter (v10.2) and hands-on expertise with Informatica Intelligent Data Management Cloud (IDMC).
Advanced Database & PL/SQL Skills: 5+ years of experience writing complex Oracle PL/SQL procedures, packages, triggers, views, and functions for data extraction, cleansing, transformation, and loading.
Performance Tuning Mastery: Deep technical experience conducting root-cause analysis, optimizing SQL query execution plans, and tuning database performance for scalability.
Cloud & Azure Data Services: Hands-on experience with cloud platforms (Azure, AWS, or GCP), specifically constructing data pipelines with Azure Data Factory and Azure SQL Server.
Version Control & DevOps: Proficiency with Git/GitHub for version control, JIRA, and Azure DevOps for issue tracking and CI/CD workflows.
Preferred Assets
Public Sector Context: Prior experience working on inter-jurisdictional public sector projects, government EA frameworks, or environmental data systems is considered an asset.
Scripting & Search Technologies: Familiarity with Python, Unix shell scripting, Elasticsearch, or RAD methodologies.
Accessibility Standards: Knowledge of digital accessibility regulations and standards (such as AODA).
Soft Skills & Delivery Attributes
Analytical Problem Solving: Superior diagnostic and troubleshooting capabilities to resolve complex data pipeline bottlenecks and systemic issues.
Consultative Communication: Excellent written, verbal, and interpersonal communication skills to engage effectively with diverse technical and business stakeholders.
Team Collaboration: Highly motivated team player with a strong customer service orientation, flexibility, and a track record of meeting strict delivery timelines.
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.
