Posted 2 months ago
Hybrid! ETL Developer, 1 Month Contract
@ Dimensional Tech Inc.
Toronto, Ontario
Overview
Dimensional Tech Inc. is hiring a hybrid ETL Developer on a one-month contract in Toronto, with three days per week onsite required. The work covers migrating Informatica PowerCenter ETL code and Oracle SQL/PL/SQL to Informatica Cloud, testing and tuning those migrations, and building data warehouse pipelines.
Responsibilities:
- Develop and maintain ETL processes in Informatica Cloud
- Migrate Informatica PowerCenter v10.2 code and Oracle embedded SQL and PL/SQL
- Test migrated SQL and stored procedures
- Tune SQL and PL/SQL for performance and scalability
- Build data pipelines into star and snowflake schema warehouses
Requirements summary:
- Experience with Informatica Cloud (IDMC) and PowerCenter
- Oracle 11g and 19c SQL and PL/SQL skills
- Query and PL/SQL performance tuning experience
- Root cause analysis of ETL issues
- Ability to work onsite three days per week in Toronto
Tools & skills
Source and dates
Source type not verified · crelate
- Employer posting date
- 2026-08-25
- First seen by our source
- 2026-10-16
- Source record updated
- 2026-10-16
These dates describe the source record, not a live verification that the employer is still hiring. Check the original posting.
Job details
| Seniority | Mid level |
| Department | Software development |
| Travel | air: none · ground: none |
| Work setting | Office |
| Position | Mostly sitting |
| Physical demands | physical low · computer high |
| Languages | English |
Summary and details written by AI from the posting; the employer’s posting is the authority.
Dimensional Tech Inc.
| Field | Value |
|---|---|
| Open jobs on Jobsy | 172 |
• Openings: 1
• Duration: 2027-02-12 to 2027-03-31 (29 days)
• Job Type: Hybrid: Candidate MUST work 3 days onsite
• Location: Toronto, Ontario
Requirements:
• Contribute to and support design, development, and maintenance of ETL processes using Informatica Cloud (IDMC).
• Migrate Informatica PowerCentre v10.2 ETL code including embedded SQL and PL/SQL code developed using Oracle 11g and 19c
• 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.
Journal
Only you can see this. Kept on this device, and in your account when you sign in.