Informatica Cloud Data Engineer (IDMC/IICS)
Capgemini•Chicago, IL
•$103,330 - $128,656•Onsite
About The Position
Choosing Capgemini means choosing a company where you will be empowered to shape your career in the way you’d like, where you’ll be supported and inspired by a collaborative community of colleagues around the world, and where you’ll be able to reimagine what’s possible. Join us and help the world’s leading organizations unlock the value of technology and build a more sustainable, more inclusive world.
Requirements
- 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 transformation, cleansing, and validation
- Data profiling and quality tools
- Handling structured and semi-structured data
Nice To Haves
- 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
Responsibilities
- 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
- 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)
- 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)
- Develop integrations between systems using REST/SOAP APIs
- Work with third-party applications (Salesforce, SAP, Oracle, etc.)
- Handle real-time and batch integrations
- Gather and analyze business/data requirements
- Translate requirements into technical solutions
- Collaborate with analysts, architects, and business users
- Monitor job executions and troubleshoot failures
- Perform root cause analysis and implement fixes
- Provide production support and performance tuning
Benefits
- Flexible work
- Healthcare including dental, vision, mental health, and well-being programs
- Financial well-being programs such as 401(k) and Employee Share Ownership Plan
- Paid time off and paid holidays
- Paid parental leave
- Family building benefits like adoption assistance, surrogacy, and cryopreservation
- Social well-being benefits like subsidized back-up child/elder care and tutoring
- Mentoring, coaching and learning programs
- Employee Resource Groups
- Medical, dental, and vision coverage
- Retirement savings plans (e.g., 401(k) in the U.S., RRSP in Canada)
- Life and disability insurance
- Employee assistance programs
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
Upload and Match Resume
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Education Level
No Education Listed
