ODM Enterprise Data warehouse migration from Big Data Environment to Snowflake Environment
Requirements
- Proficiency in Data Warehousing, Data migration, and Snowflake
- Strong Experience in the implementation, execution, and maintenance of Data Integration technology solutions
- Minimum (4-6) years of hands-on experience with Cloud databases
- Minimum (2-3) years of hands-on data migration experience from the Big Data environment to the Snowflake environment
- Minimum (2-3) years of hands-on experience with the Snowflake platform, along with Snowpipe and Snowpark
- Strong experience with Snow SQL, PL/SQL, and expertise in writing Snowflake procedures using SQL/Python/Java
- Experience with optimizing Snowflake database performance and real-time monitoring
Responsibilities
- Participate in Team activities, Design discussions, stand-up meetings, and planning reviews with the team
- Provide Snowflake database technical support in developing reliable, efficient, and scalable solutions for various projects on Snowflake
- Ingest the existing data, framework, and programs from the ODM EDW IOP Big data environment to the ODM EDW Snowflake environment using the best practices
- Design and develop Snowpark features in Python, understand the requirements, and iterate
- Create, monitor, and maintain role-based access controls, Virtual warehouses, Tasks, Snowpipe, and Streams on Snowflake databases to support different use cases
- Performance tuning of Snowflake queries and procedures
- Recommending and documenting the best practices of Snowflake
Other
- BS/BA degree or combination of education & experience
- Effective communication, presentation, and organizational skills
- Ability to establish priorities and follow through on projects, paying close attention to detail with minimal supervision
- Familiar with Project Management methodologies like Waterfall and Agile
- Ability to work independently, as well as part of a team
