Snowflake/Matillion consultant

Amazech Solutions • Contract • Birmingham, AL, US • 6d ago

Amazech Solutions is one of the fastest growing IT Solutions and Staffing companies in Dallas Fort Worth Metroplex. Established in 2007 at Frisco TX, we serve clients in DFW and across the nation. We are proud to be a trusted partner to various clients, and we are an employee-centric organization.

We are looking for a Snowflake/Matillion Consultant to work out of Birmingham, AL

Required skills/Experience:

Experience in end-to-end data analytics strategy, design and architecture for Snowflake, Medallion Cloud and AWS Cloud Services.
8+ years of experience in DWH, 4 years of experience in implementing DWH on Snowflake.
Design and Develop/Review ETL programs primarily using Matillion Cloud
Experience in Design and implementation of Data Platform projects in a large-scale enterprise data warehouse environment and at least 2 Successful implementation Matillion with Snowflake is a must.
Technical reviews, Data validation & end to end testing of ETL Objects, Source data analysis and data profiling.
Handle multiple projects in parallel, Participate and deliver Solution design, working closely with the architecture team • Understand business requirements and convert them into detail technical specifications for Data models and ETL programs
Collaborate with business users to create architecture in alignment with business need
Lead in Developing Project requirements for end-to-end Data integration process using ETL for Structured, semi-structured and Unstructured Data.
Experience with data security and data access controls and design in Snowflake.
Design the data warehouse and provide guidance to the team in implementation using Snowflake Snow SQL
Experience in working on migrating data from on-premises databases and files to Snowflake
Strong understanding of ELT/ETL and integration concepts and design best practices.
Experience in performance tuning of the snow pipelines and should be able to troubleshoot the issue quickly
Experience in Snow sql, Snowpipe, and Snowflake.