Informatica ETL Developer
- Toronto, ON, Canada
Contract
Applications open in a new tab.
Job details
- Job type
- Contract
- Apply by
- Posting language
- English
- Posted
Original job description
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.
More about this job
Responsibilities
Design, develop, maintain, and optimize Informatica PowerCenter ETL solutions, including mappings, workflows, and data warehouse structures. Analyze source systems, integrate data, document designs, optimize database operations, and troubleshoot ETL processes.
Requirements
Requires 8+ years of ETL development and data warehousing experience, including strong hands-on expertise with Informatica PowerCenter 10.x. Candidates should have strong SQL skills and knowledge of SCD Type 2, star schemas, aggregations, Salesforce PowerExchange, XML, Java, HTTP transformations, and Informatica Data Quality.
Skills
- Informatica PowerCenter
- ETL Development
- Data Warehousing
- SQL
- Stored Procedures
- Query Optimization
- ETL Mappings
- Mapplets
- Workflows
- Worklets
- SCD Type 2
- Star Schema
- Salesforce PowerExchange
- XML
- Java
- Informatica Data Quality
Visa sponsorship
Not detected in the job text
Categories
- Technology
- Data & Analytics
- Software
Keywords
- Informatica PowerCenter 10.x
- ETL
- Enterprise Data Warehousing
- ETL Mappings
- Mapplets
- Workflows
- Worklets
- Technical Specifications
- ETL Design Documentation
- SCD Type 2
- Aggregations
- Star Schema
- Source System Analysis
- Data Integration
- Data Partitioning
- SQL
- Stored Procedures
- Database Triggers
- Query Optimization
- Salesforce PowerExchange
- Relational Databases
- XML
- XML Parser
- Java
- HTTP Transformation
- Informatica Data Quality
- Data Profiling
- ETL Performance Optimization