Informatica Cloud Developer

Job Role: Informatica Cloud Developer

Location: Pittsburgh, PA

Job Description:

Must Have Technical/Functional Skills:

Informatica:

• Informatica Intelligent Cloud Services (IICS)
• Cloud Data Integration (CDI)
• Cloud Application Integration (CAI)
• Mass Ingestion
• Task flows
• Parameterization
• Mapping Designer
• Secure Agent Configuration

Databases:

• Oracle
• SQL Server
• PostgreSQL
• Snowflake

Cloud Platforms:

• Microsoft Azure
• AWS
• Google Cloud Platform (preferred)

Roles & Responsibilities:

Data Integration & ETL Development:

• Design, develop, and maintain ETL/ELT processes using Informatica Cloud (IICS).
• Build mappings, mapping tasks, task flows, schedules, and reusable transformations.
• Integrate data between core banking applications, CRM systems, data warehouses, and cloud platforms.
• Develop incremental and full-load data processing solutions.
• Optimize performance of data integration workflows.

Cloud & Database Integration:

• Implement integrations between:

o Oracle

o SQL Server

o PostgreSQL

o Snowflake

o Azure Data Lake

o AWS S3

o Salesforce

• Develop API-based integrations using REST and SOAP services.
• Manage secure connectivity through Secure Agents.