Senior Snowflake Developer - Noida, India - Anika Technologies
Description
Job Title: Snowflake Developer
6 Months Contract
Location: Noida (Work from office) Sector 15
Exp - 5 Plus
Payroll - Anika Technologies
End Client - Kpmg
Responsibilities:
1. Snowflake Development:
• Designing and building scalable and efficient data storage solutions meeting data warehousing design standards and using Snowflake's architecture.
• Strong experience in SQL & PL/ SQL – Hands-on .
• Writing, optimizing, and troubleshooting complex SQL queries and Stored Procedures to extract and analyze data within the Snowflake environment.
• Integrating Snowflake with various data sources and third-party tools to facilitate data flow.
• Staying up-to-date with the latest features and best practices for Snowflake development.
2. Data Modeling and Integration: Collaborate with data engineers and business analysts to understand data sources, perform data modeling, and ensure the availability of clean and accurate data for analysis. Integrate data from various sources into Snowflake, ensuring data quality and consistency.
3. Performance Optimization: Optimize Snowflake solutions for performance by fine-tuning data models, queries, and visuals. Implement performance optimization techniques to ensure efficient data retrieval with less computation Cost.
1. Data Governance and Security: Implement data governance and security best practices within Snowflake solutions. Define and enforce data access controls, data encryption, and other security measures to protect sensitive information.
2. Collaboration and Stakeholder Management: Collaborate closely with business stakeholders to gather requirements, understand their needs, and translate them into effective data visualizations. Conduct regular meetings and presentations to demonstrate the capabilities and value of Data Models solutions.
3. Documentation and Knowledge Sharing: Create technical solution design and unit test cases. Document data models, report specifications, and development processes to ensure knowledge sharing and maintainability. Create user guides and training materials to enable self-service analytics for end-users.
4. Quality Assurance and Troubleshooting: Conduct thorough testing and validation of developed Snowflake solutions to ensure accuracy, functionality, and adherence to business requirements. Troubleshoot and resolve any issues or bugs that arise during testing or production.
Qualifications:
• Bachelor's degree in Computer Science, Information Systems, or a related field.
• Minimum of 5 years of experience in Snowflake development.
• Extensive knowledge and expertise in SQL & PL/SQL.
• Prior knowledge working with SAP & JDE Systems would be preferred.
• Proven experience in designing and developing complex Business Scenarios and meaningful use cases.
• Strong understanding of data modeling concepts and best practices.
• Proficiency in SQL for data retrieval and manipulation.
• Solid understanding of data governance and security principles within Snowflake.
• Excellent analytical and problem-solving skills with the ability to translate business requirements into effective visualizations.
• Strong communication and stakeholder management skills, with the ability to effectively collaborate with stakeholders at all levels of the organization.