Snowflake Informatica Engineer

San R&D Business Solutions LLC

Job Location:

San Francisco, CA - USA

Monthly Salary: Not Disclosed

Experience Required: 5years

Posted on: 2 hours ago

Vacancies: 1 Vacancy

Job Summary

This is a remote position.

Job Title: Snowflake Informatica Engineer

Work Type: Remote
Employment Type: Contract (C2C)

Duration: 4 Months Contract (Possible Extension)
Visa: USC / GC / GC EAD only

Job Description:

We are looking for a Senior Snowflake Informatica Engineer with strong hands-on experience in Informatica PowerCenter Informatica Cloud (IICS) and Snowflake. This role focuses on migrating legacy ETL pipelines to cloud-based solutions on Azure and optimizing Snowflake data warehouse performance.

The ideal candidate is a hands-on individual contributor with expertise in data migration metadata management and performance tuning capable of working independently in a fast-paced Agile environment.

Key Responsibilities:

Migrate Informatica PowerCenter ETL workflows to Informatica Cloud (IICS) on Azure
Redesign and optimize ETL/ELT pipelines for cloud scalability and performance
Perform end-to-end development testing and validation of migrated data pipelines
Analyze and clean up Snowflake metadata and unused objects
Optimize Snowflake performance and cost using metadata (ACCOUNTUSAGE INFORMATIONSCHEMA)
Monitor and fine-tune query performance and warehouse utilization
Collaborate with architects operations and cross-functional teams
Support deployment planning and ensure smooth handoff to support teams
Prepare technical documentation and knowledge transfer artifacts

Required Skills:

1012 years of overall IT experience
5 years of experience in Informatica PowerCenter (ETL development)
Hands-on experience with Informatica Cloud (IICS/IDMC) migration
Strong expertise in Snowflake (SnowSQL metadata performance tuning)
Experience with Snowflake metadata analysis and optimization
Strong SQL and data modeling skills (ETL/ELT concepts)
Experience with Azure cloud platform (preferred but highly desired)
Strong communication skills and ability to work as an individual contributor

Preferred Skills:

Experience with Azure Data Factory / Azure Data Lake
Familiarity with DevOps CI/CD and Git
Experience with Power BI or other BI tools
Agile/Scrum experience
Snowflake Certification (SnowPro Core)
Experience working with distributed/global teams

This is a remote position.Job Title: Snowflake Informatica EngineerWork Type: Remote Employment Type: Contract (C2C)Duration: 4 Months Contract (Possible Extension) Visa: USC / GC / GC EAD only Job Description: We are looking for a Senior Snowflake Informatica Engineer with strong hands-on experi...