

KPG99 INC
Snowflake Informatica Engineer
⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is for a Snowflake Informatica Engineer with a contract length of "unknown" and a pay rate of "unknown." Key skills include 5+ years in ETL/Power Center, Snowflake optimization, and strong SQL. SnowPro certification is preferred.
🌎 - Country
United States
💱 - Currency
$ USD
-
💰 - Day rate
Unknown
-
🗓️ - Date
March 26, 2026
🕒 - Duration
Unknown
-
🏝️ - Location
Unknown
-
📄 - Contract
Unknown
-
🔒 - Security
Unknown
-
📍 - Location detailed
United States
-
🧠 - Skills detailed
#BI (Business Intelligence) #Documentation #SQL (Structured Query Language) #ADLS (Azure Data Lake Storage) #Azure #SnowSQL #Cloud #Informatica Cloud #Data Modeling #Deployment #GIT #Data Integrity #Informatica #Metadata #Migration #ADF (Azure Data Factory) #Microsoft Power BI #Agile #"ETL (Extract #Transform #Load)" #IICS (Informatica Intelligent Cloud Services) #DevOps #Snowflake
Role description
Role Summary
We are looking for an experienced Informatica + Snowflake Engineer to support a migration from Informatica Power Center to IICS on Azure and optimize Snowflake performance. This is a hands-on, individual-contributor role working closely with architects and operations teams.
Key Responsibilities
Informatica Migration (60%)
• Migrate and redesign Power Center ETL workflows to Informatica Cloud (IICS/IDMC)
• Develop, test, validate, and ensure data integrity for all migrated pipelines
Snowflake Optimization (30%)
• Tune Snowflake warehouses, queries, and performance
• Use metadata tables (ACCOUNT_USAGE, INFORMATION_SCHEMA) for analysis and cost optimization
Collaboration & Handoff (10%)
• Work with operations/support teams for deployments
• Prepare documentation and perform knowledge transfer
Required Skills
• 5+ years ETL/Power Center (9.x or higher)
• Hands-on experience migrating Power Center → IICS
• Strong Snowflake + SnowSQL skills (SnowPro certification preferred)
• Strong SQL, data modeling, ETL/ELT experience
• Excellent communication; able to work independently in a fast-paced environment
Preferred Skills
• Experience with Azure (ADF, ADLS)
• Knowledge of CI/CD, Git, DevOps for ETL
• Experience with Power BI or other BI tools
• Agile project experience
Role Summary
We are looking for an experienced Informatica + Snowflake Engineer to support a migration from Informatica Power Center to IICS on Azure and optimize Snowflake performance. This is a hands-on, individual-contributor role working closely with architects and operations teams.
Key Responsibilities
Informatica Migration (60%)
• Migrate and redesign Power Center ETL workflows to Informatica Cloud (IICS/IDMC)
• Develop, test, validate, and ensure data integrity for all migrated pipelines
Snowflake Optimization (30%)
• Tune Snowflake warehouses, queries, and performance
• Use metadata tables (ACCOUNT_USAGE, INFORMATION_SCHEMA) for analysis and cost optimization
Collaboration & Handoff (10%)
• Work with operations/support teams for deployments
• Prepare documentation and perform knowledge transfer
Required Skills
• 5+ years ETL/Power Center (9.x or higher)
• Hands-on experience migrating Power Center → IICS
• Strong Snowflake + SnowSQL skills (SnowPro certification preferred)
• Strong SQL, data modeling, ETL/ELT experience
• Excellent communication; able to work independently in a fast-paced environment
Preferred Skills
• Experience with Azure (ADF, ADLS)
• Knowledge of CI/CD, Git, DevOps for ETL
• Experience with Power BI or other BI tools
• Agile project experience






