Informatica ETL Developer
Apptoza Inc.
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.
Reference: WJ-4483_1631007 · Posted 15 Nov 2026, 02:11 AM