Location: INDIA - PUNE - BIRLASOFT OFFICE - HINJAWADI
Title: Subcontractor
Description:
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 setting 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