DirectJobHub
Jobs · Information Technology · Illinois

Informatica Cloud Data Engineer (IDMC/IICS)

Capgemini · Chicago, IL · 3 mo ago
Information TechnologyFull-time

About the role

Join us and help the world's leading organizations unlock the value of technology and build a more sustainable, more inclusive world.

Responsibilities

  • Data Integration & ETL Development
  • Design, develop, and maintain ETL/ELT pipelines using Informatica Cloud Data Integration (CDI)
  • Build reusable mappings, mapplets, taskflows, and workflows
  • Extract data from multiple sources (databases, APIs, flat files, cloud apps) and load into target systems (Data Warehouse, Data Lake, etc.)
  • Optimize performance of ETL jobs for large-scale data processing
  • Cloud & Platform Management
  • Work With Informatica Intelligent Data Management Cloud (IDMC) Modules
  • Cloud Data Integration (CDI)
  • Cloud Data Quality (CDQ)
  • Cloud Application Integration (CAI)
  • API Manager / Data Governance tools (optional)
  • Configure Secure Agent setup, connectivity, and runtime environments
  • Manage deployments across environments (Dev, QA, Prod)
  • Data Quality & Governance
  • Implement data quality rules, profiling, cleansing, and validation using CDQ
  • Ensure data consistency, completeness, and accuracy across systems
  • Support data governance initiatives (metadata, lineage, catalog)
  • Integration & APIs
  • Develop integrations between systems using REST/SOAP APIs
  • Work with third-party applications (Salesforce, SAP, Oracle, etc.)
  • Handle real-time and batch integrations
  • Collaboration & Stakeholder Management
  • Gather and analyze business/data requirements
  • Translate requirements into technical solutions
  • Collaborate with analysts, architects, and business users
  • Misson & Support
  • Monitor job executions and troubleshoot failures
  • Perform root cause analysis and implement fixes
  • Provide production support and performance tuning

Required Skills

  • Strong experience with Informatica IDMC / IICS
  • Hands-on With Cloud Data Integration (CDI) Taskflows & mappings
  • Solid Understanding Of ETL concepts and data warehousing
  • SQL (advanced level)
  • Data modeling concepts
  • Experience With Cloud Platforms AWS / Azure / GCP (at least one)
  • Knowledge of APIs (REST/SOAP), JSON, XML
  • Data transformation, cleansing, and validation
  • Data profiling and quality tools
  • Handling structured and semi-structured data

Preferred Skills

  • Experience with Informatica Cloud Data Quality (CDQ)
  • Knowledge of Informatica Data Governance / EDC / Axon
  • Experience in real-time integration (CAI)
  • Familiarity with DevOps practices (CI/CD pipelines)
  • Scripting knowledge (Python / Shell)
  • Experience with Snowflake, Redshift, BigQuery, etc.

Benefits

Capgemini provides a comprehensive, non-negotiable benefits package to all regular, full-time employees. In the U.S. and Canada, available benefits are determined by local policy and eligibility and may include:

  • Paid time off based on employee grade (A-F)
  • Company paid holidays, Personal Days, Sick Leave
  • Medical, dental, and vision coverage (or provincial healthcare coordination in Canada)
  • Retail savings plans (e.g., 401(k) in the U.S., RRSP in Canada)
  • Life and disability insurance
  • Employee assistance programs
  • Other benefits as provided by local policy and eligibility

Qualifications

The base compensation range for this role in the posted location is: 103,330 to 128,656

Disclaimers

Compensation (including bonuses, commissions, or other forms of incentive pay) is not considered earned, vested, or payable until it becomes due under the terms of applicable plans or agreements and is subject to Capgemini’s discretion, consistent with applicable laws. The Company reserves the right to amend or withdraw compensation programs at any time, within the limits of applicable legislation.

Similar jobs