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. 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.