Software Developer - ETL - Senior
Offre en anglaisThe 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.
- Hybride
- Toronto, ON
- Publié 25 août 2026
- Postuler avant le 24 sept. 2026
- 1 poste
D’autres postes auxquels postuler directement
Des possibilités semblables publiées par des employeurs qui recrutent sur Jobs.ca, sans formulaire externe.
Segal Centre for Performing Arts
Coordination de l’accueil
- Hybride
City of Toronto
Senior Project Manager CS
- Hybride
Revenu Québec
Cheffe ou chef du Service des produits liés à la facturation obligatoire
- Hybride
Résumé du poste
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.
Ce que vous ferez
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.
Exigences
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.
Compétences indiquées
- SQLSouhaitée
Autres compétences pertinentes
Relevées dans la description du poste. Confirmez les exigences importantes ci-dessus.
- Informatica PowerCentre
- Informatica Cloud (IDMC)
- SQL
- PL/SQL
- Oracle 11g
- Oracle 19c
- ETL
- Data Warehousing
- Performance Tuning
- Root Cause Analysis
Domaines d’emploi
- Software
- Data & Analytics
- Technology
Renseignements supplémentaires
- Expérience minimale
- 5+ ans
- Postuler avant le
- 24 sept. 2026
- Langue de l’offre
- anglais
- Heures de travail
- 40 heures par semaine
- Présence au bureau
- 3 jours par semaine
- Niveau d’expérience
- Mid-Senior level
- Mode de candidature
- La candidature directe est offerte