Subcontractor

Area(s) of responsibility

• 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.