What are the responsibilities and job description for the Informatica Intelligent Data Management Cloud (IDMC) Developer with Insurance Domain in IL position at Smart Caliber Technology?
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