Software Developer - ETL - Senior
The role involves migrating ETL code from Informatica PowerCentre to Informatica Cloud (IDMC) and maintaining data pipelines. Responsibilities include optimizing SQL queries and performing data extraction and loading into star or snowflake schemas.
- Hybrid
- Toronto, ON
- Posted Aug 25, 2026
- Apply by Sep 24, 2026
- 1 position
More jobs you can apply to directly
Similar opportunities posted by employers hiring on Jobs.ca, with no external application form.
Job summary
Job Role: Software Developer - ETL - Senior Location : Toronto, ON/Hybrid Position Type : Contract Role Start Date 2027-02-12 End Date 2027-03-31 Hybrid: Candidate must work 3 days onsite Ideal Candidate Rate: CAD 90-95/Hr (Depending on the experience) Must Have: Migrate Informatica PowerCentre v10.2 ETL code including embedded SQL and PL/SQL code developed using Oracle 11g and 19c Contribute to and support design, development, and maintenance of ETL processes using Informatica Cloud (IDMC). Test migrated embedded SQL code and PL/SQL based Stored Procedures. Performance-tune and optimize SQL queries and PL/SQL code for performance and scalability. Conduct root cause analysis and resolve ETL issues, including performance tuning and recovery to achieve optimum baseline-based performance Perform data extraction, transformation, and loading (ETL) from various sources into data warehouses (star/snowflake schemas). Translate technical specifications into fully tested applications and data pipelines. Note: AI-enabled tools may be used to sort applications based on job-related criteria. All AI generated results are vetted by our team and the decision of which candidates move forward is always made by a human.
What you’ll do
The role involves migrating ETL code from Informatica PowerCentre to Informatica Cloud (IDMC) and maintaining data pipelines. Responsibilities include optimizing SQL queries and performing data extraction and loading into star or snowflake schemas.
Requirements
Candidates must have expertise in migrating Informatica PowerCentre code and working with Oracle 11g/19c PL/SQL. Experience in performance tuning and translating technical specifications into tested applications is required.
Listed skills
- SQLPreferred
Other relevant skills
Identified from the job description. Confirm important requirements above.
- Informatica PowerCentre
- Informatica Cloud (IDMC)
- SQL
- PL/SQL
- Oracle 11g
- Oracle 19c
- ETL
- Data Warehousing
- Performance Tuning
- Root Cause Analysis
Job areas
- Software
- Data & Analytics
- Technology
Additional details
- Minimum experience
- 5+ years
- Apply by
- Sep 24, 2026
- Posting language
- English
- Working hours
- 40 hours per week
- Office presence
- 3 days per week
- Seniority
- Mid-Senior level
- Application method
- Direct apply is available