Overview
Skills
Job Details
Position: Informatica IICS/ Snowflake Consultant
Location: Austin TX (Tuesdays / Fridays Onsite)
Duration: 12+ Months
Job Description
Understands business objectives and problems, identifies alternative solutions, performs studies and cost/benefit analysis of alternatives. Analyzes user requirements, procedures, and problems to automate processing or to improve existing computer system: Confers with personnel of organizational units involved to analyze current operational procedures, identify problems, and learn specific input and output requirements, such as forms of data input, how data is to be; summarized, and formats for reports. Writes detailed description of user needs, program functions, and steps required to develop or modify computer program. Reviews computer system capabilities, specifications, and scheduling limitations to determine if requested program or program change is possible within existing system.
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.
CANDIDATE SKILLS AND QUALIFICATIONS
Minimum Requirements:
- 8+yrs exp with Extensive experience in designing, implementing, and managing Informatica IICS/snowflake solutions.
- 8+yrs exp with E2E implementation experience involving phases from design, realization, testing, to go-live
- 8+yrs exp with Deep understanding of Informatica data modeling, workflow, and integration capabilities and technologies, APIs, web services, and Informatica ETL tools.
- 8+yrs exp with Strong knowledge of data governance, data quality, and data integration principles.
- 8+yrs exp with Expertise in Azure Cloud and Snowflake Cloud Datawarehouse
- 8+yrs exp with Strong knowledge in SQL Queries and Query optimization
- 8+yrs exp with Ability to interact at a technical and non-technical level with Infrastructure, Network, Development, BA and QA
- 8+yrs exp with Development experience in high transaction/high availability systems.
- 8+yrs exp with Experience with analyzing and recommending solutions for Production issues short-term and long term.
- 8+yrs exp with Must have informatica PowerCenter/IICS development experience.
- 8+yrs exp with Knowledge and experience of managing reference data systems
- 8+yrs exp with Provide technical mentorship to junior ETL developers; establish coding standards, templates, and best practices.
- 8+yrs exp with Experience in Python with data science libraries
- 8+yrs exp with Experience in SQL programming and writing stored procedures, functions, views, SQL queries
- 8+yrs exp with Experience working with HIPAA regulations and handling protected health information (PHI) and personally identifiable information (PII).
- 8+yrs exp with Strong organizational and time management skills.
- 8+yrs exp with Data warehouse development experience
- 8+yrs exp with Experience with Snowflake
- 4+yrs exp with 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+yrs exp with Experience in implementing and supporting automation for managing Snowflake accounts, databases, and access roles.
- 4+yrs exp with Experience and understanding in proposing and implementing database and Snowflake query performance optimizations.
- 4+yrs exp with Experience with Git hub integration with snowflake and load data.