- 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
- 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
- Strong communication, presentation and team building skills and experience in producing high quality deliverables.
- 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 professionals
- Opportunities to work with EY Advisory practices globally with leading businesses across a range of industries
- Support, coaching and feedback from some of the most engaging colleagues around
- Opportunities to develop new skills and progress your career
- The freedom and flexibility to handle your role in a way that's right for you
GDS Consulting-AI and DATA-Snowflake-Manager - Thiruvananthapuram, India - EY
Description
The opportunity
We're looking for a Manager with overall 8 – 11 years of experience and he/she should have strong expertise into cloud data engineering using Snowflake.
Key skills required for the role (Primary):
Your role:
Skills and attributes for success
What we look for
What working at EY offers
At EY, we're dedicated to helping our clients, from start–ups to Fortune 500 companies — and the work we do with them is as varied as they are.
You get to work with inspiring and meaningful projects. Our focus is education and coaching alongside practical experience to ensure your personal development. We value our employees and you will be able to control your own development with an individual progression plan. You will quickly grow into a responsible role with challenging and stimulating assignments. Moreover, you will be part of an interdisciplinary environment that emphasizes high quality and knowledge exchange. Plus, we offer:
EY | Building a better working world