Roe : Informatica ETL Developer – PowerCenter / Data Warehousing

Job Description:

We are looking for an experienced

Informatica ETL Developer

with robust 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.

#J-18808-Ljbffr

📌 Informatica ETL Developer (Winnipeg)
🏢 apptoza
📍 Winnipeg