Required Skills & Experience:
Strong hands-on experience with Informatica Cloud (IICS) including Data Integration and Application Integration.
Proven expertise in ETL/ELT development and enterprise data migration programs.
Secure Agent Management: Installing, configuring, monitoring, and troubleshooting the Informatica Secure Agent on local or cloud hosts
Platform Administration: Navigating the IICS/IDMC console, managing runtime environments, and setting up server groups or sub-orgs
User Access & Security: Configuring Single Sign-On (SSO), defining user roles, managing group permissions, and handling security keys/certificates (Keystore/Trust store).
Connection Management: Setting up and testing database, application, and flat-file connections (e.g., Oracle, Snowflake, AWS).
Robust knowledge of zero-downtime and incremental data synchronization techniques.
Experience implementing CDC, delta loads and near-real-time data replication patterns.
Strong knowledge of Oracle and SQL Server data sources and schemas.
Experience integrating Informatica Cloud with AWS-hosted databases and services.
Understanding of data quality, reconciliation, error handling and performance tuning.
Ability to collaborate with application, database and middleware teams (TIBCO ESB).