IT & Software

Informatica ETL Developer

Apptoza Inc.

Toronto · Ontario · Canada

Share this job: X Facebook WhatsApp Save job : Informatica ETL Developer

Roe : Informatica ETL Developer – PowerCenter / Data Warehousing

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.
#J-18808-Ljbffr

Reference: WJ-4483_1631007 · Posted 15 Nov 2026, 02:11 AM

Find more on GigBlow

This role is listed on GigBlow for discovery and search. Hiring decisions and applications are handled by the employer or their chosen application system.

Browse jobs