IICS Developer

Required Skills

• Informatica Intelligent Cloud Services (IICS)

Preferred Skills

• Snowflake

Responsibilities

• Implement and maintain the approved Medallion Architecture, including bronze, silver, and gold data layers.
• Design and develop Snowflake databases, schemas, tables, views, data models, and curated data products.
• Use Informatica Intelligent Cloud Services (IICS) to build and operate data-integration workflows for ingestion, transformation, orchestration, scheduling, monitoring, and error handling.
• Use IICS data-quality capabilities to profile data, define quality rules and thresholds, validate results, and document exceptions and remediation.
• Maintain business glossary terms, metadata, classifications, data domains, lineage, ownership, and stewardship assignments using approved governance and catalog tools or processes.
• Configure and support metadata harvesting, catalog scanning, lineage capture, and metadata-completeness monitoring using approved tools and connectors.
• Develop source-to-target mappings, transformation specifications, data dictionaries, technical designs, and operational procedures.
• Apply data-quality controls for completeness, validity, consistency, uniqueness, timeliness, referential integrity, and reconciliation, as applicable.
• Support integration with SFTP, Azure Blob Storage, Snowflake, and other approved Agency platforms.
• Document technical and operational metadata to support future enterprise data catalog and governance implementations.
• Participate in sprint planning, backlog refinement, daily coordination, sprint reviews, retrospectives, and quality-gate activities.
• Provide end-user training, demonstrations, knowledge transfer, and support to HHSC staff and data owners.
• Comply with HHSC security, privacy, accessibility, documentation, change-control, and operational requirements.
• Expected Deliverable(s) : ETL Code, Test results , release document