Snowflake Data Engineer

The opportunity

Were looking for a candidate with overall 4-7 years of experience and he/she should have strong expertise into cloud data engineering using Snowflake.

Key skills required for the role (Primary):

• Expertise in designing and implementing a fully operational solution on Snowflake Data Warehouse in Snowflake on AWS/Azure
• Monitoring health, tuning, and growth of such on-premises and cloud databases
• Experience in managing security and maintenance of snowflake databases
• Manage and monitor user access to the snowflake database
• Hands on exposure to ETL using Snowflake native services
• Hands on exposure to SQL & scripting
• Good understanding of Snowflake Internals and integration of Snowflake with other data processing and reporting technologies
• Design and Develop ETL pipelines in and out of data warehouse using Snowflakes Snow SQL
• Deep understanding of relational as well as NoSQL data stores methods and approaches star and snowflake dimensional modelling
• Experience in designing and deploying virtual warehouse, schema, views, zero-copy clone in Snowflake cloud data warehouse
• Good to have experience working with AWS services like Lambda, S3, DynamoDB, Glue, etc.
• Good to have experience working with Azure services like – Azure Functions, Blob, ADF, DevOps, etc.
• Good to have experience working with PL-SQL & ETL tools like Informatica or DataStage
• Strong Communication skills
• Work experience with banking clients is an added advantage
• Hands on experience with Mattilion, Python, DBT preffered

Your role:

• Perform business/data analysis to investigate various business problems and propose the solution working closely with clients and team
• Get involved in business development activities like creating proof of concepts (POCs), point of views (POVs
• Interface and communicate with the onsite teams directly to understand the requirement and determine the optimum solutions
• Provide product and design level functional and technical expertise along with best practices
• Ability to think clearly, plan effectively, organize and develop action plans leading to resolving problems and achieving specific goals

Skills and attributes for success

• Strong communication, presentation and team building skills and experience in producing high quality deliverables.

What we look for

• A Team of people with technical experience and enthusiasm to learn new things in this fast-moving environment
• An opportunity to be a part of market-leading, multi-disciplinary team of 1400 + professionals
• Opportunities to work with EY Advisory practices globally with leading businesses across a range of industries