Enterprise Data Warehouse ETL Developer

19 hours ago

Toronto, Ontario, Canada Apptoza Inc. Full-time

Enterprise data warehousing and Type-2 SCD knowledge define this Informatica ETL Developer position. PowerCenter 10.x experience supports complex integration delivery.

The experienced developer builds and optimizes ETL solutions for enterprise data warehouse environments. Responsibilities include source analysis, data integration, warehouse modeling, and collaboration with DBAs and Data Architects. The work also includes Salesforce PowerExchange and relational database loading.

Key Responsibilities:

  • Analyze source systems and perform data integration activities
  • Build warehouse solutions using Type-2 SCD and Star Schema
  • Collaborate on data partitioning strategies with DBAs and Architects
  • Load Salesforce PowerExchange data into relational databases
  • Implement repository version control and coding best practices

Requirements:

  • 8+ years of ETL development and Data Warehousing experience
  • Strong Informatica PowerCenter 10.x hands-on expertise
  • Enterprise data warehouse environment experience
  • Experience with Salesforce PowerExchange
  • Strong understanding of aggregations and Star Schema

Use Informatica, warehouse modeling, Salesforce PowerExchange, and integration expertise to deliver enterprise data solutions.