Publié il y a 3 jours
Informatica ETL Developer
@ Apptoza Inc.
Toronto, Ontario
En bref
Apptoza Inc. is hiring a contract Informatica ETL Developer in Toronto, ON, to design, build and optimize ETL solutions for enterprise data warehouses. The role calls for 8+ years of ETL and data warehousing experience with hands-on Informatica PowerCenter 10.x work.
Responsabilités :
- Design and maintain ETL mappings and workflows in Informatica PowerCenter 10.x
- Build data warehouse solutions with SCD Type 2 and star schema
- Develop and optimize SQL queries and stored procedures
- Load Salesforce data via PowerExchange
- Troubleshoot and optimize ETL performance
Résumé des exigences :
- 8+ years of ETL development and data warehousing
- Strong hands-on Informatica PowerCenter 10.x
- Expertise in SQL and query optimization
- Knowledge of Informatica Data Quality, XML and Java
- Experience with enterprise data warehouse environments
Outils et compétences
Source et dates
Type de source non vérifié · apify-linkedin
- Date publiée par l’employeur
- 2026-11-10
- Première détection par notre source
- 2026-11-14
- Mise à jour du dossier source
- 2026-11-14
Ces dates décrivent le dossier source, pas une vérification en direct du recrutement. Consultez l’offre originale.
Détails du poste
| Niveau | Senior |
| Domaine | Données et analytique |
| Expérience | 8 an(s) et plus |
| 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.
Apptoza Inc.
| Champ | Valeur |
|---|---|
| Offres sur Jobsy | 25 |
Roe : Informatica ETL Developer – PowerCenter / Data Warehousing
📍 Location: Toronto, ON, Canada
💼 Experience: 8+ Years
🛠️ Primary Skill: Informatica PowerCenter
Job Description:
We are looking for an experienced Informatica ETL Developer with strong hands-on expertise in Informatica PowerCenter and Enterprise Data Warehousing to design, develop, and optimize ETL solutions.
Key Responsibilities:
- Design, develop, and maintain ETL mappings, mapplets, workflows, and worklets using Informatica PowerCenter 10.x.
- Prepare technical specifications and ETL design documentation.
- Build data warehouse solutions using Type-2 Slowly Changing Dimensions (SCD), aggregations, and Star Schema.
- Perform source system analysis and data integration activities.
- Collaborate with DBAs and Data Architects on data partitioning strategies.
- Develop and optimize SQL queries, stored procedures, and database triggers.
- Implement ETL repository version control and coding best practices.
- Load data from Salesforce PowerExchange into relational databases using Informatica.
- Work with XML, XML Parser, Java, and HTTP transformations within Informatica.
- Leverage Informatica Data Quality (Analyst and Developer) for data profiling and quality management.
- Troubleshoot ETL processes and optimize performance.
Required Skills & Qualifications:
- 8+ years of experience in ETL development and Data Warehousing.
- Strong hands-on experience with Informatica PowerCenter 10.x.
- Strong knowledge of ETL mappings, mapplets, workflows, and worklets.
- Expertise in SQL, stored procedures, and query optimization.
- Strong understanding of Data Warehousing concepts, SCD Type 2, Star Schema, and aggregations.
- Experience with Salesforce PowerExchange.
- Knowledge of XML, Java, HTTP Transformation, and Informatica Data Quality.
- Experience working with enterprise data warehouse environments.
Journal
Visible seulement par vous. Conservé sur cet appareil, et dans votre compte une fois connecté.