Publié il y a 3 mois
Hybrid! ETL Developer, 1 Month Contract
@ Dimensional Tech Inc.
Toronto, Ontario
En bref
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.
Responsabilités :
- 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
Résumé des exigences :
- 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
Outils et compétences
Source et dates
Type de source non vérifié · crelate
- Date publiée par l’employeur
- 2026-08-25
- Première détection par notre source
- 2026-10-16
- Mise à jour du dossier source
- 2026-11-07
Ces dates décrivent le dossier source, pas une vérification en direct du recrutement. Consultez l’offre originale.
Détails du poste
| Niveau | Intermédiaire |
| Domaine | Développement logiciel |
| Déplacements | avion : aucun · route : aucun |
| Milieu de travail | Bureau |
| Position | Surtout assis |
| Exigences physiques | physique faible · ordinateur élevé |
| Langues | English |
Résumé et détails rédigés par l’IA à partir de l’offre; l’offre de l’employeur fait foi.
Dimensional Tech Inc.
| Champ | Valeur |
|---|---|
| Offres sur Jobsy | 164 |
• 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
Visible seulement par vous. Conservé sur cet appareil, et dans votre compte une fois connecté.