Informatica Intelligent Data Management Cloud (IDMC) Developer

Smart Caliber Technology
Schaumburg, United States of America
yesterday

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English

Job location

Schaumburg, United States of America

Tech stack

API
Amazon Web Services (AWS)
Azure
Software as a Service
Cloud Computing
Cloud Database
Profiling
Databases
Continuous Integration
Data Governance
Data Integration
ETL
Data Transformation
Data Profiling
Data Warehousing
DevOps
Data Intelligence
JSON
Python
Meta-Data Management
Oracle Applications
Performance Tuning
Salesforce
SAP Applications
Shell Script
Web Services
XML
Enterprise Data Management
Data Processing
Google Cloud Platform
Enterprise Software Applications
Sql Optimization
Snowflake
Informatica Cloud
SOAPAPI
Data Lake
Data Lineage
Collibra
Google BigQuery
Enterprise Integration
Cloud Integration
Data Pipelines
Api Management
Redshift

Job description

Role: Informatica Intelligent Data Management Cloud (IDMC) Developer with Insurance Domain in IL, 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., 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.

Requirements

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

Apply for this position