Source description
About the role
Must haves- Must have Snowflake Certification Must have administered an existing Snowflake environment. Must have experience with AWS and Snowflake environment. Responsibilities: • Manage snowflake utilities such as SnowSQL, SnowPipe, Big Data model techniques using Python • Setting up resource monitors, deploying RBAC controls, virtual warehouse sizing and query performance tuning • Deploy snowflake features such as data sharing • Configure Storage integration to access AWS S3 and create stage objects • Work with version control tools (Github) • Configure AWS PrivateLink to access Snowflake account • Applies SME knowledge to solve common & complex data issues within established guidelines & recommends appropriate actions • Supports Cloud migration teams projects with AWS Cloud expertise • Supports operation of the programs Cloud AWS environment • Provide user access/security/release/schedules management • Work with federal and contractor staff to identify cloud migration requirements • Follow established client standards for implementing cloud configurations • Collaborate and coordinates with the other contract Gov task leads as directed Requirements: • Bachelor’s degree with 8 years of relevant experience or Masters’ and 6 years, or PhD and 3 years. An additional 4 years of experience may be substituted in lieu of a degree. • Must have an active Snowflake certification • Experience with ETL concepts & DWH • Experience using Snowflake SQL and implementing stored procedures • Understanding of Snowflake TimeTravel concepts and zero copy cloning, network policies, clustering, and tasks • Experience with advanced concepts setting up RBAC Controls, Resource Monitors, Virtual Warehouse sizing, and Query performance tuning • Experience with Python connector & Spark connector for Snowflake, as well as Apache • Experience with AWS S3 data storage, privatelink, VPC, EC2 • Experience administering/sizing clusters such as Redshift/Snowflake/Databricks/Hadoop • Experience with version control tools (ideally GitHub) • Experience in CI/CD pipelines, agile methodologies and DevOps styled deployments • Must have a background managing Agile teams / projects (Scrum preferred) • Excellent organizational, communication (written & verbal), and time management skills Preferred experience: • Holds and active Public Trust clearance • Experience in consulting to CMS (Centers of Medicare & Medicaid), or Federal Health, or Enterprise Health companies • Experience migrating enterprise level data warehouses from Teradata to Snowflake / AWS Cloud, as well as On-Premises to Cloud. Thanks & Regards, PremTarun Palnati|Technical Recruiter Thoughtwave Software and Solutions 314 N. Lake St, Suite 6, Aurora IL 60506 Desk: 6306182581 Email: www.tarun@wavsols.com Website: https://www.thoughtwavessoft.com/
More at Thoughtwave Software and Solutions