Skip to content
Search jobs inside your AI agent. Claude, ChatGPT, Claude Code, Codex, Gemini, Cursor and Grok
Connect

Apptoza Inc.

NewBe an early applicant

Informatica ETL Developer

Posted 20 views

Summary

Designs, develops, and optimizes ETL pipelines and enterprise data warehouse solutions using Informatica PowerCenter 10.x — building mappings, mapplets, and workflows, modeling Star Schema/SCD Type 2 dimensions, loading Salesforce data via PowerExchange, and tuning SQL and data-quality processes.

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.

Skills

Apply

See also

Data Engineering jobs by country — openings, pay and top skills →