Informatica IICS || Orlando, FL (3 days a week onsite)

Job Title: Informatica IICS

Location: Orlando, FL (3 days a week onsite)

Job Description:

As the DE&A - Core - Cloud Data Engineering - Informatica Cloud expert, you will play a pivotal role in shaping our data integration strategy. Your primary focus will be on leveraging Informatica PowerCenter and CDI to design and develop robust data integration solutions. This role offers an opportunity to work with cutting-edge technologies and contribute to the success of our cloud-based data management initiatives.

Key Responsibilities:

• Develop, enhance, and maintain ETL processes using Informatica PowerCenter and Informatica Cloud Data Integration (CDI).
• Lead or contribute to migration efforts from PowerCenter to IDMC/CDI.
• Integrate data across various platforms including Oracle, SQL Server, and Snowflake.
• Leverage REST APIs within IDMC CDI to connect with internal and external applications and systems.
• Collaborate with business and technical teams to understand data requirements and translate them into effective integration solutions.
• Work independently to analyze complex source-to-target mappings and resolve data integration challenges.
• Troubleshoot and optimize data workflows for issue resolution, performance, and scalability in a cloud environment.
• Develop and maintain SQL queries and Unix Shell scripts as part of data workflows and automation.
• Document ETL processes, data flows, and system integrations effectively.

Required Qualifications:

• 5+ years of hands-on experience with Informatica PowerCenter.
• 3+ years of experience with Informatica Cloud Data Integration (CDI).
• Experience with IDMC migration projects is a strong plus.
• Strong understanding of ETL architecture, data modeling concepts, and data warehousing best practices.
• Proficiency in SQL (complex queries, optimization) and Shell scripting.
• Ability to work independently with minimal supervision in a fast-paced environment.
• Excellent problem-solving skills and a proactive attitude toward learning and development.

Preferred Qualifications:

• Experience with Informatica Data Management Cloud Services (IDMC), Data Quality (IDQ), or other IDMC components.
• Exposure to cloud platforms such as AWS, Azure, or Google Cloud Platform.
• Familiarity with job scheduling tools (e.g., Control-M, Autosys).
• Good communication and interpersonal skills to interact with cross-functional teams.