Role Title: IICS Developer
Location: Remote
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
