Overview
Skills
Job Details
Hi,
Greetings from IFlowSoft Inc
Title: ETL Informatica Lead
Type: Contract
Location: Austin, TX - Hybrid
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.
Minimum Requirements: | ||
Years | Required/Preferred | Experience |
8 | Required | Extensive experience in designing, implementing, and managing Informatica IICS/snowflake solutions. |
8 | Required | E2E implementation experience involving phases from design, realization, testing, to go-live |
8 | Required | Deep understanding of Informatica data modeling, workflow, and integration capabilities and technologies, APIs, web services, and Informatica ETL tools. |
8 | Required | Strong knowledge of data governance, data quality, and data integration principles. |
8 | Required | Expertise in Azure Cloud and Snowflake Cloud Datawarehouse |
8 | Required | Strong knowledge in SQL Queries and Query optimization |
8 | Required | Ability to interact at a technical and non-technical level with Infrastructure, Network, Development, BA and QA |
8 | Required | Development experience in high transaction/high availability systems. |
8 | Required | Experience with analyzing and recommending solutions for Production issues short-term and long term. |
8 | Required | Must have informatica PowerCenter/IICS development experience. |
8 | Required | Knowledge and experience of managing reference data systems |
8 | Required | Provide technical mentorship to junior ETL developers; establish coding standards, templates, and best practices. |
8 | Required | Experience in Python with data science libraries |
8 | Required | Experience in SQL programming and writing stored procedures, functions, views, SQL queries |
8 | Required | Experience working with HIPAA regulations and handling protected health information (PHI) and personally identifiable information (PII). |
8 | Required | Strong organizational and time management skills. |
8 | Preferred | Data warehouse development experience |
8 | Preferred | Experience with Snowflake |
4 | Preferred | 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 | Preferred | Experience in implementing and supporting automation for managing Snowflake accounts, databases, and access roles. |
4 | Preferred | Experience and understanding in proposing and implementing database and Snowflake query performance optimizations. |
4 | Preferred | Experience with Git hub integration with snowflake and load data. |
Iflowsoft is an Equal Opportunity Employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, disability, military status, national origin or any other characteristic protected under federal, state, or applicable local law