Snowflake Engineer, Informatica
SAN R&D Business Solutions
contract
Posted on:
Location Type: Remote
Location: United States
Visit company websiteExplore more
Tech Stack
About the role
- 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 (ACCOUNT_USAGE, INFORMATION_SCHEMA)
- 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
Requirements
- 10–12+ 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.
Benefits
- Remote Job
- 4+ Months Contract (Possible Extension)
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
Informatica PowerCenterInformatica CloudETLELTSnowflakeSnowSQLSQLdata modelingperformance tuningmetadata analysis
Soft Skills
communicationcollaborationindividual contributor