Informatica Intelligent Data Management Cloud (IDMC) Developer with Insurance Domain in IL

Role: Informatica Intelligent Data Management Cloud (IDMC) Developer with Insurance Domain in IL 

Location: Schaumburg, IL (Onsite/Hybrid)

 

Job Description

We are seeking an experienced Informatica Intelligent Data Management Cloud (IDMC) Developer with strong expertise in cloud-based data integration, ETL/ELT development, and data quality. The ideal candidate will have hands-on experience with Informatica IDMC/IICS, cloud platforms, and enterprise data integration.

Key Responsibilities

Data Integration & ETL Development

• Design, develop, and maintain ETL/ELT pipelines using Informatica Cloud Data Integration (CDI).
• Develop reusable mappings, mapplets, taskflows, and workflows.
• Extract data from databases, APIs, flat files, and cloud applications, and load into Data Warehouses or Data Lakes.
• Optimize ETL performance for high-volume data processing.

Informatica IDMC Administration

• Work extensively with Informatica Intelligent Data Management Cloud (IDMC), including:
  • Cloud Data Integration (CDI)
  • Cloud Data Quality (CDQ)
  • Cloud Application Integration (CAI)
  • API Manager/Data Governance tools (preferred)
• Configure and manage Secure Agents, connectivity, and runtime environments.
• Support deployments across Development, QA, and Production environments.

Data Quality & Governance

• Implement data profiling, cleansing, validation, and quality rules using CDQ.
• Ensure data consistency, completeness, and accuracy.
• Support metadata management, data lineage, and governance initiatives.

Integration & APIs

• Develop REST and SOAP API integrations.
• Integrate enterprise systems such as Salesforce, SAP, Oracle, and other third-party applications.
• Build and support both batch and real-time integrations.

Collaboration & Support

• Gather and analyze business and technical requirements.
• Translate business needs into scalable technical solutions.
• Collaborate with architects, business analysts, and stakeholders.
• Monitor production jobs, troubleshoot failures, perform root cause analysis, and optimize system performance.

Required Skills

Informatica

• Strong hands-on experience with Informatica IDMC/IICS
• Cloud Data Integration (CDI)
• Taskflows, mappings, workflows
• Secure Agent configuration and administration

Data & ETL

• Strong ETL/ELT development experience
• Advanced SQL
• Data Warehousing concepts
• Data Modeling
• Data transformation, profiling, cleansing, and validation

Cloud & Integration

• Experience with AWS, Azure, or Google Cloud Platform
• REST/SOAP APIs
• JSON and XML

Preferred Skills

• Informatica Cloud Data Quality (CDQ)
• Informatica Data Governance, Enterprise Data Catalog (EDC), or Axon
• Cloud Application Integration (CAI)
• CI/CD and DevOps practices
• Python or Shell scripting
• Experience with cloud data warehouses such as:
  • Snowflake
  • Amazon Redshift
  • Google BigQuery