Technical Lead-Data Engg

Area(s) of responsibility

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