Senior Principal Consultant / Architect
Skills – Snowflake in depth Snowflake, Matillion Cloud and AWS Cloud Services, workflow on these technologies.
Job Description:
Primary Skillset: Snowflake, Matillion (end-to-end) and AWS.
Job Details:
14+ years of experience - 6A/6B Grade
- 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-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 trouble shoot the issue quickly.
- Experience in SnowSQL, Snowpipe, and Snowpark.
