ETL / Informatica IDMC Developer
Manoj GRemoteMIDPosted 1h ago
Informatica PowerCenterInformatica IDMC/IICSCloud Data IntegrationMass IngestionCloud Application IntegrationData QualityREST APIsIDMC/IICS REST V2 ConnectorWeb Services ConnectorJSONXMLRelational databasesCloud data warehousesSQLOracleSnowflakeQuery optimizationPerformance tuningUNIX/Linux Shell Scripting
About the Role
We are looking for an experienced ETL / Informatica IDMC Developer to join our team. This role involves working with our client on data integration projects using Informatica PowerCenter and IDMC/IICS.
Key Responsibilities
• Design and implement data integration solutions using Informatica PowerCenter and IDMC/IICS
• Lead end-to-end migration projects from PowerCenter to IDMC
• Develop and integrate REST APIs using IDMC/IICS REST V2 Connector or Web Services Connector
• Load data into relational databases and cloud data warehouses
• Optimize SQL queries for performance
• Automate and orchestrate processes using UNIX/Linux Shell Scripting
Requirements
• 6+ years of experience with Informatica PowerCenter and Informatica IDMC/IICS
• Experience in at least one end-to-end migration project from PowerCenter to IDMC
• Expertise in Cloud Data Integration, Mass Ingestion, Cloud Application Integration, and Data Quality
• Strong understanding of JSON/XML payloads, API authentication, and pagination handling
• Excellent SQL development skills in Oracle and Snowflake
• Strong knowledge of query optimization and performance tuning
• Hands-on experience with UNIX/Linux Shell Scripting for automation and orchestration