Full Job Description
We are hiring for an Informatica Intelligent Cloud Services Developer opportunity.
Role: Informatica Intelligent Cloud Services Developer
Location: Remote
Position: 4
Work Arrangement: Remote
Role Overview
We are seeking Informatica Intelligent Cloud Services (IICS) Developers to support enterprise data integration, data quality, and governance initiatives for HHSC. The ideal candidates will have hands on experience with IICS and preferably Snowflake, along with the ability to develop and maintain data integration workflows, implement Medallion Architecture, and support enterprise data management practices.
Required Skills
- Hands on experience with Informatica Intelligent Cloud Services (IICS).
- Experience developing and maintaining data integration workflows for ingestion, transformation, orchestration, scheduling, monitoring, and error handling.
- Knowledge of data quality profiling, validation, quality rules, thresholds, and exception handling.
- Experience developing source to target mappings, transformation specifications, data dictionaries, and technical designs.
- Understanding of data quality controls, including completeness, validity, consistency, uniqueness, timeliness, referential integrity, and reconciliation.
- Experience with ETL development, testing, deployment, and production support.
- Ability to document technical and operational metadata.
Preferred Skills
- Experience with Snowflake databases, schemas, tables, views, data models, and curated data products.
- Experience implementing Medallion Architecture across Bronze, Silver, and Gold data layers.
- Experience with metadata management, data catalogs, business glossaries, data lineage, and data governance.
- Experience with metadata harvesting, catalog scanning, and lineage capture.
- Experience integrating with SFTP, Azure Blob Storage, Snowflake, and other enterprise platforms.
- Experience supporting enterprise data quality and governance initiatives.
Key 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.
- Execute 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 sprint planning, backlog refinement, daily coordination, sprint reviews, retrospectives, and quality gate activities.
- Support production deployment, cutover, hypercare, troubleshooting, and transition to operations.
- 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 Deliverables
- ETL Code
- Test Results
- Release Documentation
Education Requirement
Bachelor's degree in Computer Science, Information Technology, Engineering, Business Administration, or a related field is preferred.
Our Perks and Benefits
Our benefits and rewards program has been thoughtfully designed to recognize your skills and contributions, elevate your learning experience, and provide care and support for you and your loved ones.
We also offer:
- Health Insurance with Dental & Vision
- 401K Plan
- Life Insurance, STD & LTD
- Paid Vacations & Holidays
- Continuous Skill Based Development and Career Advancement Opportunities