Primary Skillset: Snowflake, Matillion and AWS
Work experince: 12-14 yrs
- Experience in end-to-end data analytics strategy, design and architecture for Snowflake, Matillion 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 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 SnowSQL
- Experience in working on migrating data from on-premise 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 trouble shoot the issue quickly
- Experience in Snowsql, Snowpipe, and Snowpark
