Posted 3 days ago
Informatica ETL Developer
@ Apptoza Inc.
Toronto, Ontario
Overview
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.
Responsibilities:
- 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
Requirements summary:
- 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
Tools & skills
Source and dates
Source type not verified · apify-linkedin
- Employer posting date
- 2026-11-10
- First seen by our source
- 2026-11-14
- Source record updated
- 2026-11-14
These dates describe the source record, not a live verification that the employer is still hiring. Check the original posting.
Job details
| Seniority | Senior |
| Department | Data & analytics |
| Experience | 8+ years |
| 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.
Apptoza Inc.
| Field | Value |
|---|---|
| Open jobs on 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
Only you can see this. Kept on this device, and in your account when you sign in.