Informatica IICS/Snowflake consultant - Hybrid - 2 days per wee

Title: Informatica IICS/Snowflake consultant - Hybrid - 2 days per week onsite

Location: Austin, TX, USA

Length: Long term

Restriction: W2 or C2C

Description:

Interview Type: Skype *** Very long term project need 3 references*** Local candidate or local to TX only but must relocate ***Hybrid*** ***2 days per week onsite***

Description:

Level Description

8 or more years of experience, relies on experience and judgment to plan and accomplish goals, independently performs a variety of complicated tasks, a wide degree of creativity and latitude is expected.

Additional job details and special considerations

We are seeking a highly experienced and motivated individual who specializes in Informatica Cloud Services (IICS). The ideal candidate will have deep technical expertise in multi-domain environments, enabling them to lead and deliver complex IICS implementations for our clients. This role requires a strong understanding of the Informatica toolset, including IICS and relevant business processes, along with excellent communication and client management skills.

Required Skills

Extensive experience in designing, implementing, and managing Informatica IICS/snowflake solutions. 8 years

E2E implementation experience involving phases from design, realization, testing, to go-live 8 years

Deep understanding of Informatica data modeling, workflow, and integration capabilities and technologies, APIs, web services, and Informatica ETL tools. 8 years

Strong knowledge of data governance, data quality, and data integration principles. 8 years

Expertise in Azure Cloud and Snowflake Cloud Datawarehouse 8 years

Strong knowledge in SQL Queries and Query optimization 8 years

Ability to interact at a technical and non-technical level with Infrastructure, Network, Development, BA and QA 8 years

Development experience in high transaction/high availability systems. 8 years

Experience with analyzing and recommending solutions for Production issues short-term and long term. 8 years

Must have informatica PowerCenter/IICS development experience. 8 years

Knowledge and experience of managing reference data systems 8 years

Provide technical mentorship to junior ETL developers; establish coding standards, templates, and best practices. 8 years

Experience in Python with data science libraries 8 years

Experience in SQL programming and writing stored procedures, functions, views, SQL queries 8 years

Experience working with HIPAA regulations and handling protected health information (PHI) and personally identifiable information (PII). 8 years

Strong organizational and time management skills. 8 years

Preferred Skills

Data warehouse development experience 8 years

Experience with Snowflake 8 years

Experience in designing, optimizing, documenting, and implementing the operational aspects that support the Snowflake cloud data platform, including cost monitoring, optimizations, and user security auditing. 4 years

Experience in implementing and supporting automation for managing Snowflake accounts, databases, and access roles. 4 years

Experience and understanding in proposing and implementing database and Snowflake query performance optimizations. 4 years

Experience with Git hub integration with snowflake and load data. 4 years