Cloud Data Engineering -Professional

Job Description

Snowflake (Cloud Data Warehouse): Good understanding of Snowflake ECO system Good experience on Data modeling and Dimensional Modeling and techniques and will be able to drive the Technical discussions with IT & Business and Architects / Data Modelers Need to guide the team and provide the technical solutions Need to prepare the technical solution and architectures as part of project requirements Virtual Warehouse (Compute) - Good Understanding of Warehouse creation & manage Data Modeling & Storage - Strong knowledge on LDM/PDM design Data Loading/Unloading and Data Sharing- Should have good knowledge SnowSQL (CLI)- Expertise and excellent understanding of Snowflake Internals and Integration Strong hands on experience on SNOWSQL queries and Stored procedures and performance tuning techniques Good knowledge on SNOWSQL Scripts preparation the data validation and Audits SnowPipe - Good knowledge of Snow pipe implementation Expertise and excellent understanding of S3 - Internal data copy/movement Good knowledge on Security & Readers and Consumers accounts Good knowledge and hands on experience on Query performance tuning implementation techniques SQL Knowledge: Advance SQL knowledge and hands on experience on complex queries writing using with Analytical functions Strong knowledge on stored procedures Troubleshooting, problem solving and performance tuning of SQL queries accessing data warehouse Ability to participate in RFI/RFPs discussions and provide technical solutions and effort estimations Excellent presentation and communication skills, both written and verbal Ability to problem solve and architect in an environment with unclear requirements Candidate should have good work attitude and ability to work in Onshore/Offshore model. Nice to have skills: SnowPro-Core - Certification - Snowflake Five Tran knowledge is an added advantage Good to have Hi-Tech Manufacturing domain experience. Control M understandig Snowflake (Cloud Data Warehouse): Good understanding of Snowflake ECO system Good experience on Data modeling and Dimensional Modeling and techniques and will be able to drive the Technical discussions with IT & Business and Architects / Data Modelers Need to guide the team and provide the technical solutions Need to prepare the technical solution and architectures as part of project requirements Virtual Warehouse (Compute) - Good Understanding of Warehouse creation & manage Data Modeling & Storage - Strong knowledge on LDM/PDM design Data Loading/Unloading and Data Sharing- Should have good knowledge SnowSQL (CLI)- Expertise and excellent understanding of Snowflake Internals and Integration Strong hands on experience on SNOWSQL queries and Stored procedures and performance tuning techniques Good knowledge on SNOWSQL Scripts preparation the data validation and Audits SnowPipe - Good knowledge of Snow pipe implementation Expertise and excellent understanding of S3 - Internal data copy/movement Good knowledge on Security & Readers and Consumers accounts Good knowledge and hands on experience on Query performance tuning implementation techniques SQL Knowledge: Advance SQL knowledge and hands on experience on complex queries writing using with Analytical functions Strong knowledge on stored procedures Troubleshooting, problem solving and performance tuning of SQL queries accessing data warehouse Ability to participate in RFI/RFPs discussions and provide technical solutions and effort estimations Excellent presentation and communication skills, both written and verbal Ability to problem solve and architect in an environment with unclear requirements Candidate should have good work attitude and ability to work in Onshore/Offshore model. Nice to have skills: SnowPro-Core - Certification - Snowflake Five Tran knowledge is an added advantage Good to have Hi-Tech Manufacturing domain experience. Control M understandig