Description

You will design, develop, and optimize ETL processes using Informatica Cloud and PowerCenter across Oracle, MSSQL, and DB2 environments.

Responsibilities

• Develop, test, and enhance advanced ETL jobs based on business specifications.
• Write complex SQL queries and stored procedures for various database environments.
• Optimize Informatica transformations, Maplets, Workflows, and Sessions for performance.
• Manage data integration workflows across Oracle, MSSQL, and DB2 backends.

Required Skills

• 10+ years of total professional experience in data development.
• 5+ years of hands-on experience specifically in Informatica Cloud (IICS) development.
• 5+ years of experience with Informatica PowerCenter, specifically version 10.5.2 or higher.
• Strong proficiency in writing SQL queries and stored procedures.
• Extensive experience with Oracle, DB2, or MSSQL databases.
• Deep understanding of Informatica transformations, Maplets, and workflows.
• Proven ability in performance optimization for ETL processes.

Preferred Skills

• Strong communication and interpersonal skills.

Key Skills

Education

Any gradudate