| Snowflake Consultant || Dallas, TX at Dallas, Texas, USA |
| Email: [email protected] |
|
http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=1185772&uid= From: Akash, smart it frame [email protected] Reply to: [email protected] Hi, Greetings from Smart IT Frame, Hope you are doing well!!! Smart IT Frame specializes in enabling you with your most critical line of resources. Whether its for permanent staffing, contract staffing, contract-to-hire or executive search, we understand the importance of delivering the most suitable talent; on time and within budget. With our Core focus in emerging technologies, we have provided global technology workforce solutions in North America, Canada & India. We take pride in delivering specialized talent, superior performance, and seamless execution to meet the challenging business needs of customers worldwide. Role: Snowflake Consultant Location: Dallas, TX Exp : 15+ Years Certified Snowflake Snowpro Core (Must) Certified Snowflake cloud data warehouse Architect (Desirable). Onsite from day one at Comerica Dallas office Skill Snowflake Consultant As an Architect need Someone who has vast Data Architect experience and adopted Snowflake with Data Modelling and Admin exposure. This is going to be a key position for the team, and this person is expected to guide team on the approach when onboarding new data sources or Analytics use case in terms of Security, best practices and optimum uses Responsibilities Deep understanding of relational as well as NoSQL data stores, methods and approaches (star and snowflake, dimensional modelling). Experience with data security and data access controls and design in Snowflake. Proficiency in complex SQL, Unix /Python Scripting, performance tuning and database optimization techniques. Must have expertise in AWS Platform as a Service (PAAS) model and its integration with Snowflake to load/unload data. Implement cloud-based Enterprise data warehouse solutions with multiple data platforms along with Snowflake and NoSQL environment to build data movement strategy. Lead in Developing Project requirements for end-to-end Data integration process using ETL for Structured, semi-structured and Unstructured Data. Make necessary on-going updates to modeling principles, processes, solutions, and best practices to ensure that the Snowflake is aligned with business needs of the environment. Act as Data domain expert for Snowflake in a collaborative environment to provide demonstrated understanding of data management best practices and patterns. Required Knowledge and Level of Experience 15+ years of experience implementing data management solutions (Required). Management consulting experience (Highly Desired). Expertise in Snowflake concepts like setting up Resource monitors, RBAC controls, scalable virtual warehouse, SQL performance tuning, zero copy clone, time travel and automating them. Experience in handling semi-structured data (JSON, XML), columnar PARQUET using the VARIANT attribute in Snowflake. Experience in in re-clustering of the data in Snowflake with good understanding on Micro-Partitions. Experience in Migration processes to Snowflake from on-premises database environment. Experience in designing and building manual or auto ingestion data pipeline using Snowpipe. Experience in Cloud technologies such as AWS S3, SQS, EC2, Lambda, Redshift, RDS Design and Develop automated monitoring processes on Snowflake using combination of Python, PySpark, Bash with SnowSQL. SnowSQL Experience in developing stored Procedures writing Queries to analyze and transform data. Warm Regards, Akash Smart IT Frame LLC akash @smartitframe.com www.smartitframe.com https://www.linkedin.com/in/akash-s-332905212/ -----WBENC------ Keywords: sthree information technology Texas http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=1185772&uid= |
| [email protected] View All |
| 03:09 AM 06-Mar-24 |