Informatica Developer
Job Title: Informatica Intelligent Cloud Services (IICS) Developer
Duration: 12 Months Contract
Location: Remote Opportunity
Required Skills: Informatica Intelligent Cloud Services (IICS)
Preferred Skills:
- SnowflakeJob 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.
- Build and manage data integration workflows using Informatica Intelligent Cloud Services (IICS), including data ingestion, transformation, orchestration, scheduling, monitoring, and error handling.
- Utilize IICS data quality capabilities to profile data, define quality rules and thresholds, validate results, and document exceptions and remediation activities.
- Maintain business glossary terms, metadata, classifications, data domains, lineage, ownership, and stewardship assignments using approved data 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.
- Implement data quality controls to ensure completeness, validity, consistency, uniqueness, timeliness, referential integrity, and reconciliation, as applicable.
- Support data integration with SFTP, Azure Blob Storage, Snowflake, and other approved Agency platforms.
- Perform unit, integration, regression, data quality, reconciliation, and end-to-end validation testing.
- Document technical and operational metadata to support future enterprise data catalog and governance implementations.
- Participate in Agile ceremonies, including sprint planning, backlog refinement, daily coordination, sprint reviews, retrospectives, and quality-gate activities.
- Support production deployments, cutover activities, hypercare, troubleshooting, and transition to operations.
- Provide end-user training, demonstrations, knowledge transfer, and ongoing support to HHSC staff and data owners.
- Ensure compliance with HHSC security, privacy, accessibility, documentation, change-control, and operational requirements.
- Expected DeliverablesETL CodeTest Results
- Release Documentation