IICS Architect

Position : IICS Architect

Location : Milwaukee, WI (Onsite)

Term : W2/Full-Time Role

Job Summary

We are seeking an experienced IICS Architect to lead the design, architecture, and implementation of enterprise data integration solutions using Informatica Intelligent Cloud Services (IICS). The ideal candidate will have strong expertise in cloud data integration, ETL/ELT development, data migration, API integration, and cloud data warehouses such as Snowflake, Azure, or AWS.

Key Responsibilities

• Design and architect scalable data integration solutions using Informatica Intelligent Cloud Services (IICS).
• Lead end-to-end implementation of IICS Data Integration, Cloud Mass Ingestion (CMI), Application Integration, and API integration.
• Develop high-performance ETL/ELT pipelines for cloud and on-premise data sources.
• Design reusable mappings, taskflows, parameterization, and automation strategies.
• Integrate data from various sources including databases, flat files, APIs, SaaS applications, and cloud platforms.
• Optimize data integration jobs for performance, scalability, and reliability.
• Work closely with Data Architects, Business Analysts, and application teams to understand integration requirements.
• Design and implement data quality, data validation, and error-handling frameworks.
• Establish best practices, coding standards, and governance for IICS development.
• Support CI/CD implementation and DevOps processes for Informatica deployments.
• Mentor development teams and conduct architecture reviews.

Required Skills

Must Have

• 10 years of overall IT experience.
• 4 years of hands-on experience with Informatica Intelligent Cloud Services (IICS).
• Strong experience with:
  • IICS Data Integration
  • Cloud Mass Ingestion (CMI)
  • Taskflows
  • Parameter Files
  • Dynamic Mapping
• Experience migrating Informatica PowerCenter to IICS.
• Strong SQL development and database optimization skills.
• Experience with Snowflake.
• Experience with AWS, Azure, or Google Cloud Platform.
• Experience building REST API integrations.
• Strong ETL/ELT architecture experience.
• Data warehousing concepts including Star Schema and Snowflake Schema.
• Unix/Linux shell scripting.
• Performance tuning and troubleshooting.
• Excellent communication and stakeholder management skills.

Preferred Skills

• Informatica Cloud Data Quality (CDQ)
• Cloud Application Integration (CAI)
• Cloud Data Governance (CDGC)
• Enterprise Data Catalog (EDC)
• Master Data Management (MDM)
• Python or Java
• Apache Kafka
• Azure Data Factory (ADF)
• Databricks
• Delta Lake
• Terraform
• Git/GitHub
• Jenkins
• CI/CD pipelines
• Agile/Scrum methodology

Qualifications

• Bachelor's degree in Computer Science, Information Technology, or related field.
• Informatica IICS Certification (Preferred).
• AWS, Azure, or Snowflake Certifications are a plus.