DE&A - Core - Cloud Data Engineering - Informatica Cloud

Key Skills & Experience - ETL / Informatica IDMC Developer:

· Strong hands-on experience with Informatica PowerCenter and Informatica Intelligent Data Management Cloud (IDMC/IICS).

• Proven experience in at least one end-to-end migration project from Informatica PowerCenter to IDMC.
• Expertise in designing, developing, and supporting ETL/ELT solutions using:
  • Cloud Data Integration (CDI)
  • Mass Ingestion
  • Cloud Application Integration (CAI)
  • Data Quality (DQ)
• Hands-on experience integrating data from REST APIs using Informatica IDMC/IICS REST V2 Connector or Web Services Connector.
• Strong understanding of JSON/XML payloads, API authentication, pagination handling, and loading data into relational databases and cloud data warehouse platforms.
• Excellent SQL development skills with experience in:
  • Oracle
  • Snowflake
  • Query optimization and performance tuning
• Strong experience in UNIX/Linux Shell Scripting for automation, orchestration, and support activities.

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.

Qualifications

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 GCP.
• Familiarity with job scheduling tools (e.g., Control-M, Autosys).
• Good communication and interpersonal skills to interact with cross-functional teams.