Job description
Job Title: Snowflake DBT Lead/Architect
Location: Frisco TX (Onsite)
Skills
Mandatory Skills : Snowflake-Data Science, Snowpark Container services
Key Responsibilities
Design comprehensive migration plans and solutions tailored to the customers needs and architecture ensuring a seamless transition to Snowflake Partner with our customers acting as the technical expert for all aspects of Snowflake during implementation
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 semistructured data JSON XML columnar PARQUET using the VARIANT attribute in Snowflake
Experience in in reclustering of the data in Snowflake with good understanding on MicroPartitions
Experience in Migration processes to Snowflake from onpremises database environment
Experience in designing and building manual or auto ingestion data pipeline using Snow pipe
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
Snow SQL Experience in developing stored Procedures writing Queries to analyze and transform data
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 ShellPython Scripting performance tuning and database optimization techniques
Must have expertise in AWS Platform as a Service PAAS model and its integration with Snowflake to loadunload data
Implement cloudbased 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 endtoend Data integration process using ETL for Structured semistructured and Unstructured Data
Make necessary ongoing 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
Qualifications
Bachelors degree in computer science Information Technology or a related field
8-15 years of experience in implementing data management solutions and Snowflake Teradata AWS Redshift RDS MySQL
Strong proficiency in SQL and experience with SQL Server
Indepth knowledge of data warehousing concepts and data modeling
Excellent problemsolving skills and attention to detail
Strong communication and collaboration skills
Familiarity with Agile development methodologies
Preferred Skills
Experience with other Database tools such as SQL Oracle Teradata and AWS Redshift
Certification in any Database Architect Tool or Microsoft SQL Server or related technologies.
...We are seeking to hire a full-time home health recruiter to actively source talent to our organization. TheRecruitment & Onboarding Coordinator is responsible for the overall recruitment, compliance, and initial onboarding of all new hires for our agency. Our agency is...
...Managed Care Specialist (RN or LPN) oversees case management for managed care and commercial insurance, acting as a vital link between healthcare providers and insurance companies. The role includes negotiating payment levels, communicating care plans, and conducting...
...include case management, correspondence with clients and counsel, legal research, and law firm logistics and operations. This position... ...case with the attorney. T his position works in tandem with a remote paralegal, who also handles initial consultations with potential...
Looking for a pharmaceutical sales rep or medical sales person calling on doctors offices with at least minimum of 2 YEARS experience to cover COLUMBUS . Will look at other specialties in medical sales.
...celebrate care and quality to craft a business, careers and brands we are proud of. Join us, and you could be one of them.Nutella Cafe focuses on spreading Nutella's positive energy in families to bring more optimism to the world. We believe that today will be better...