• US Citizen

• Green Card

• EAD (OPT/CPT/GC/H4)

• H1B Work Permit

• Corp-Corp

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 18th Apr 2022

Roles & Responsibilities:
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.