Snowflake Developer

Snowflake Developer (W2 Position)
Location: Remote
Duration: 6+ Months

Job Description:
Need 8+ years of experience as a Snowflake Developer
Migrating data processing workflows from Informatica to Snowflake, leveraging Snowflake stored procedures and AWS Glue scripts. 
The role involves analyzing existing Informatica PowerCenter workflows, understanding transformation logic, and rebuilding those workflows in Snowflake with a focus on performance, scalability, and cost efficiency.
Skills required
Knowledge of Informatica to read through workflows in power center, extract the logic and convert them required. Mastery in Informatica or IDMC is ok but not mandated.
Ability to created stored procedures in Snowflake in the most optimal way. Master is needed in this to minimize warehouse usage and maximize throughput.
Ability to create glue scripts in AWS when needed is good to have. Overall good working knowledge on AWS.
Ability to analyze and understand data schemas, recommending inputs, enhancements, and structural improvements to optimize snowflake usage with large volume tables. 
Strong SQL and data querying expertise to efficiently extract, join, and validate data from relational databases. 
Experience working with provider data is good to have but not a deal breaker