Senior ETL Developer – Informatica / Oracle II Toronto, ON

Russell Tobin & Associates is hiring on behalf of one of its esteemed clients. Job ID: 26-26120 Job Title: Senior ETL Developer - Informatica / Oracle Location: Toronto, ON (HYBRID) Duration: 29 Days Client: Public Sector Pay Rate: $85-$90/hr [CAD] Job Description Seeking a Senior ETL Developer with 5+ years of experience in ETL, data warehousing, Informatica, Oracle PL/SQL, and cloud data integration. The candidate will develop, migrate, optimize, and support data integration solutions and ETL pipelines. Key Responsibilities Develop and maintain ETL processes using Informatica IDMC. Migrate Informatica PowerCenter 10.2 ETL code, including embedded SQL/PL-SQL from Oracle 11g/19c. Test migrated SQL and PL/SQL stored procedures. Perform SQL/PL-SQL performance tuning, troubleshooting, and optimization. Conduct root-cause analysis and resolve ETL/data pipeline issues. Perform ETL from multiple sources into data warehouses, star/snowflake schemas. Build and support Azure Data Factory pipelines and cloud data solutions. Translate technical requirements into tested applications and data pipelines. Collaborate with BA, QA, vendors, developers, and business stakeholders. Prepare technical documentation and provide post-implementation support. Must-Have Skills 5+ years of ETL/Data Warehousing experience. Informatica PowerCenter 10.2 & Informatica IDMC. Strong Oracle PL/SQL, SQL, stored procedures. Experience with Oracle 11g/19c. Data warehousing and star/snowflake schema. ETL performance tuning and troubleshooting. Azure Data Factory & Azure SQL. Experience with cloud platforms such as Azure/AWS/GCP. Strong data migration and integration experience. Knowledge of Python/Unix scripting, GitHub, JIRA/Azure DevOps. Strong analytical, troubleshooting, communication, and documentation skills. Agile/Scrum and SDLC experience. If this opportunity matches your experience and career goals, please share your most updated resume for consideration. About Us Russell Tobin is a leading minority-owned professional and technical recruitment and staffing advisory organization. We are comprised of specialized practices focusing on a variety of skill sets and industries. Having a depth and breadth of industry expertise, our subject matter experts are able to provide tailored and swift sourcing solutions to fulfill client hiring needs. In other words, we connect top talent with companies. We are the staffing arm of the Pride Global network, a minority-owned integrated human capital solutions firm, with additional offerings in vendor management, payroll programs, and business process optimization. Equal Employment Opportunity Russell Tobin is an equal opportunity employer. We do not discriminate on the basis of the race, religious creed, color, national origin, ancestry, physical disability, mental disability, reproductive health decision making, medical condition, genetic information, marital status, sex, gender, gender identity, gender expression, age, sexual orientation, veteran or military status, or any other characteristic protected by applicable federal, state, or local law. #RTA PrideGlobal and it's affiliates offers eligible employee’s comprehensive healthcare coverage (medical, dental, and vision plans), supplemental coverage (accident insurance, critical illness insurance and hospital indemnity), 401(k)-retirement savings, life & disability insurance, an employee assistance program, legal support, pet insurance and employee discounts with preferred vendors. Equal Employment Opportunity PrideGlobal and it's affiliates are an equal opportunity employer. We do not discriminate on the basis of the race, religious creed, color, national origin, ancestry, physical disability, mental disability, reproductive health decision making, medical condition, genetic information, marital status, sex, gender, gender identity, gender expression, age, sexual orientation, veteran or military status, or any other characteristic protected by applicable federal, state, or local law. Fair Chance Employment PrideGlobal and it's affiliates are a Fair Chance employer. We consider all qualified applicants, including those with criminal histories, in a manner consistent with applicable state and local Fair Chance laws and ordinances, including, the California Fair Chance Act and all applicable local Fair Chance ordinances. Accommodations We are committed to providing reasonable accommodations to applicants and employees with disabilities. If you require a reasonable accommodation to participate in the application or interview process, or to perform the essential functions of this role, please contact us. Only applicable for San Francisco Candidates: Under the San Francisco Lactation in the Workplace Ordinance, we will provide written notice of lactation accommodation rights, and this notice will automatically be given upon hiring, any inquiry of parental leave or lactation accommodation. Only applicable for Kentucky positions: For this type of employment, state law requires a criminal record check as a condition of employment. This applies to direct care staff (Examples: RN, LPN, Nurse Aides, Therapists) referred to Kentucky nursing facilities, assisted living communities, or long-term care facilities, in accordance with KRS 216.793.

Develop, migrate, and optimize ETL processes and data pipelines using Informatica IDMC and Azure Data Factory. Collaborate with stakeholders to translate technical requirements into tested applications and provide post-implementation support.

Requires over 5 years of experience in ETL and data warehousing with strong expertise in Oracle PL/SQL and Informatica. Proficiency in cloud platforms like Azure and experience with data migration and performance tuning are essential.

• Medical insurance • Dental insurance • Vision insurance • Accident insurance • Critical illness insurance • Hospital indemnity • 401(k) retirement savings • Life insurance • Disability insurance • Employee assistance program • Legal support • Pet insurance • Employee discounts

• GitHubPreferred
• JiraPreferred
• PythonPreferred

Identified from the job description. Confirm important requirements above.

• Informatica IDMC
• Informatica PowerCenter 10.2
• Oracle PL/SQL
• Azure Data Factory
• Azure SQL
• Data Warehousing
• ETL Performance Tuning
• Star/Snowflake Schema
• Cloud Data Integration
• Python
• Unix Scripting
• GitHub
• Jira
• Azure DevOps
• Agile/Scrum
• SDLC

• Data & Analytics
• Technology
• Software
• Government & Public Sector

Minimum experience

5+ years

Apply by

Sep 24, 2026

Posting language

English

Working hours

40 hours per week

Seniority

Mid-Senior level

Application method

Direct apply is available