Power Center IICS ETL Developer

Role: PowerCenter/IICS ETL Developer

Design and development of Informatica PowerCenter ETL processes, including complex transformations.
Strong skills in SQL and PL/SQL (Stored procedures, packages, and functions) using Oracle and PostgreSQL.
Develop, validate, and deploy ETL processes using Informatica data integration and quality tools.
Strong debugging, troubleshooting, and performance tuning skills.
Experience in creating SCD Types mappings and applying Data Warehouse concepts.
Ability to extract data from various heterogeneous source systems: Flat files, XML, Oracle, SQL Server, Postgres, SAP, and Web services.
Proficiency in creating test scripts and maintaining data quality.
Use of Informatica PowerCenter to create mappings and mapplets according to business rules.
Experience with Unix shell and Python scripting.
Hands-on experience with IICS mapping tasks, tasks, and task flows.
Deep knowledge of secure agent installation, configuring agent servers, and managing encryption and authentication protocols in Informatica Cloud Services.

10+ years of experience with Informatica PowerCenter and IICS development.
Extensive experience with Oracle and PostgreSQL SQL/PLSQL.
Experience with ETL mapping conversion from Oracle to PostgreSQL.
Strong analytical and problem-solving skills for designing, creating, and testing programs.
Excellent communication skills for interacting with team members, customers, and management.
Ability to work independently and in a team environment.