A. Lead effort to design, build/migration and configure applications, acting as primary POC
B. Snowflake Architecture Experience in designing and architecting Snowflake migration & build projects.
C. Should be front ending all the customer, architecture, technical discussions and lead the entire team
D. Responsible for solution workshop & Contribute in area i.e. estimation, building PoV, offerings development, training and capability building
Technical experience:
- Must have total 10+ yrs. in IT and 3+ years’ experience working as a snowflake Data Architect and 8+ years in Data warehouse, ETL, BI projects.
- Must have experience at least two end to end implementation of Snowflake cloud data warehouse migration projects and 3 end to end data warehouse
- implementations on-premise & cloud.
- Should have very good hands on experience in ETL tools like Informatica, Talend , SAP BODS
- Should have very good hands on experience in API handling, Java, Python
- Should be well versed in Data modelling & architecture
- Expertise in Snowflake data modelling, ELT using Snowflake SQL, implementing complex stored Procedures and standard DWH and ETL concepts
- Expertise in Snowflake advanced concepts like setting up resource monitors, RBAC controls, virtual warehouse sizing, query performance tuning, Zero copy clone, time travel and understand how to use these features
- Expertise in deploying Snowflake features such as data sharing, events and lake-house patterns
- Hands-on experience with Snowflake utilities, SnowSQL, SnowPipe, Big Data model techniques using Python
- Experience in Data Migration from RDBMS to Snowflake cloud data warehouse
- Deep understanding of relational as well as NoSQL data stores, methods and approaches (star and snowflake, dimensional modelling)
- Experience with data security and data access controls and design
- Build processes supporting data transformation, data structures, metadata, dependency and workload management
- Proficiency in RDBMS, complex SQL, PL/SQL, Unix Shell Scripting, performance tuning and troubleshoot
- Provide resolution to an extensive range of complicated data pipeline related problems, proactively and as issues surface
- Certified Snowflake cloud data warehouse Architect (Desirable).
- Should be able to troubleshoot problems across infrastructure, platform and application domains.
- Resolve technical issues of projects and Explore alternate designs
- Good to have SAP HANA experience & Cloud technology skillsets
Professional Attributes:
- Participates as a team member and fosters teamwork by inter-group coordination within the modules of the project.
- Effectively collaborates and communicates with the stakeholders and ensure client satisfaction
- Train and coach members of project groups to ensure effective knowledge management activity
- Should be able to identify areas of risk and escalation points and proactively provide solution to team
- Should have worked in offshore & onshore model.