IICS Informatica Developer

We are seeking an experienced Data Warehouse and Data Integration Engineer with strong expertise in Snowflake Data Cloud and Informatica IICS to design, build, and optimize enterprise data warehouse and analytics solutions.

Key Responsibilities

• Design and develop enterprise data warehouse and data lakehouse solutions using Snowflake Data Cloud.
• Perform ETL/ELT data integration using Informatica IICS, including Change Data Capture (CDC) with PowerExchange.
• Analyze transactional data sources and develop optimized data warehouse models for reporting and analytics.
• Build, prototype, and test dashboards and reports using Power BI and Tableau.
• Perform performance tuning for Snowflake and Informatica IICS Cloud.
• Maintain data warehouse metadata and support data governance initiatives.
• Provide technical leadership, mentoring, and best practices guidance to team members.
• Develop and maintain technical documentation and standards.

Required Skills & Experience

• 7+ years of IT experience in Data Warehousing, Data Integration, and Business Intelligence.
• Strong hands-on experience with:
  • Snowflake Data Cloud (Development & Administration)
  • Informatica IICS Cloud (Development, Administration, Performance Tuning)
  • Informatica PowerCenter and Data Quality
  • ETL/ELT and CDC (PowerExchange)
  • Power BI and Tableau
• Experience designing BI data models.
• Experience with IBM Mainframe technologies: COBOL, JCL, DB2.
• Experience with Data Governance tools: EDC, Axon, CDGC.