Informatica Intelligent Data Management Cloud

Capgemini
Schaumburg, United States of America
3 days ago

Role details

Contract type
Temporary contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Compensation
$ 142K

Job location

Schaumburg, United States of America

Tech stack

API
Amazon Web Services (AWS)
Azure
Big Data
Google BigQuery
Software as a Service
Cloud Computing
Cloud Database
Databases
Data Governance
ETL
Data Transformation
Data Profiling
Data Warehousing
DevOps
Data Intelligence
JSON
Python
Oracle Applications
Performance Tuning
Salesforce
SAP Applications
Simple Object Access Protocol (SOAP)
SQL Databases
XML
Scripting (Bash/Python/Go/Ruby)
Snowflake
Informatica Cloud
SOAPAPI
Data Lake
Semi-structured Data
Collibra
Enterprise Integration
Api Management
Redshift

Job description

ETL/ELT Development salesforce integration performance tuning data modeling REST / SOAP DevOps & CI/CD Informatica data quality metadata management production support, Data Integration & ETL Development:

  • Design, develop, and maintain ETL/ELT pipelines using Informatica Cloud Data Integration (CDI)
  • Build reusable mappings, mapplets, task flows, 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

Monitoring & Support:

  • Monitor job executions and troubleshoot failures
  • Perform root cause analysis and implement fixes
  • Provide production support and performance tuning

Requirements

Technical Skills:

  • Strong experience with Informatica IDMC / IICS

Hands-on with:

  • Cloud Data Integration (CDI)
  • Taskflows & mappings
  • Secure Agent configuration

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 Skills:

  • 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 & conditions

The pay range that the employer in good faith reasonably expects to pay for this position is $43.69/hour - $68.26/hour. Our benefits include medical, dental, vision and retirement benefits. Applications will be accepted on an ongoing basis.

About the company

Capgemini ist einer der weltweit führenden Anbieter von Management- und IT-Beratung, Technologie-Services und Digitaler Transformation. Als ein Wegbereiter für Innovation unterstützt das Unternehmen seine Kunden bei deren komplexen Herausforderungen rund um Cloud, Digital und Plattformen.

Apply for this position