Informatica Intelligent Data Management Cloud

Capgemini

Schaumburg, IL, United States

25 days ago

Role details

Contract type

Temporary contract

Employment type

Full-time (> 32 hours)

Compensation

$90,875.0 - $141,981.0

Working hours

Regular working hours

Job source

www.indeed.com

Tech stack

Application Programming Interfaces (APIs) Amazon Web Services Microsoft Azure Big Data BigQuery Software as a Service Cloud Computing Cloud Database Databases Data Governance Extract Transform Load (ETL) Data Transformation

+23 more

Data Profiling Data Warehousing DevOps Data Intelligence JSON Python (Programming Language) Oracle (Applications) Performance Tuning Salesforce.Com SAP (Applications) Simple Object Access Protocol (SOAP) SQL Databases Extensible Markup Language (XML) Scripting Snowflake Informatica Cloud SOAPAPI Data Lakes Semi-structured Data Collibra Enterprise Integration Api Management Amazon 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.