| Direct Client: 15+ ONLY - Senior Snowflake Developer (745571) : Local Preferred at Trenton, New Jersey, USA |
| Email: [email protected] |
|
Hello, Hope you are doing well, We have the below requirement open. Please send me your candidates updated Resume to [email protected] Role: Senior Snowflake Developer (745571) Location: 100 Riverview Plaza Trenton, NJ 08625 Hybrid - Local or Nearby ONLY Interview Type: iLinc Web Cam Interview Only Short Description: Design, implement, and optimize data solutions using the Snowflake cloud data platform. This role plays a pivotal part in architecting data warehouses, data lakes, and ETL processes to enable efficient data storage, processing, and analytics. Note: This is a Hybrid position - 3 Days On-Site, 2 Days Remote. A Senior Snowflake Developer is a highly skilled professional responsible for designing, implementing, and optimizing data solutions using the Snowflake cloud data platform. This role plays a pivotal part in architecting data warehouses, data lakes, and ETL processes to enable efficient data storage, processing, and analytics for the organization. Responsibilities 1. Data Architecture - Collaborate with data architects to design and develop Snowflake data models and schemas. - Create and maintain a well-structured data warehouse and data lake architecture. 2. Data Integration - Develop ETL (Extract, Transform, Load) processes to ingest data from various sources into Snowflake. - Ensure data integration processes are efficient, reliable, and scalable. - Design and implement data pipelines using Snowflake features like tasks and streams. 3. Performance Optimization - Optimize query performance by creating and maintaining appropriate indexes, materialized views, and clustering keys. - Identify and resolve performance bottlenecks in data processing. 4. SQL Development - Write complex SQL queries, stored procedures, and user-defined functions (UDFs) to support data analytics and reporting needs. - Ensure SQL code follows best practices for readability and performance. 5. Security and Access Control - Implement and manage security measures, including role-based access control (RBAC) and data encryption, to protect sensitive data. - Audit and monitor data access and user activities. 6. Data Quality Assurance - Define and implement data quality checks and validation processes to maintain data accuracy. - Establish data quality rules and alerts to proactively identify issues. 7. Documentation - Create and maintain technical documentation for data models, ETL processes, and data dictionaries. - Document best practices, standards, and guidelines for Snowflake development. 8. Version Control and Deployment - Use version control systems (e.g., Git) for managing Snowflake SQL scripts and objects. - Coordinate the deployment of changes to Snowflake environments. 9. Monitoring and Alerts - Set up monitoring and alerting for Snowflake environments to proactively detect and respond to issues. - Troubleshoot and resolve incidents related to data processing and performance. 10. Backup and Recovery - Implement backup and recovery strategies to ensure data integrity and availability. - Develop and test data recovery procedures. 11. Collaboration - Collaborate with data engineers, data scientists, and business analysts to understand data requirements and provide data solutions. - Work with cross-functional teams to support data-related projects and initiatives. Qualifications - Bachelor's or master's degree in computer science, data engineering, or a related field. - 7+ years of experience as a Snowflake developer or data engineer with a focus on data warehousing and ETL. - Snowflake certification(s) is a plus. - Strong SQL skills and proficiency in data modeling and database design. - Knowledge of cloud data warehousing concepts and best practices. - Familiarity with data integration tools and technologies. - Solid understanding of data governance, data security, and compliance requirements. - Experience with version control systems and deployment processes. - Excellent problem-solving and troubleshooting skills. - Strong communication and collaboration abilities. - Ability to work in an Agile or iterative development environment. Question 2 Please list candidate's email address HERE. Question 4 Is the candidate available for a round one, in-person interview Question 5 Where is the candidate currently geographically located Question 6 If the candidate resides more than 1 hour from the client site, will the candidate relocate for the position Question 7 Please provide link to LinkedIn profile if available. Skill Years Used Last Used Snowflake Data Warehouse Design & Development Required 7 Years | Cloud Computing, Preferably AWS (Azure, GCP) Required 7 Years | Data Modeling (Star Schema, Snowflake Schema) Required 7 Years | Continuous Integration/Deployment (CI/CD) Tools Required 7 Years | Performance Tuning & Optimization Required 7 Years | SQL for Data Querying & Manipulation Required 7 Years | Data Migration to Cloud Platforms Required 7 Years | Data Security & Governance in Cloud Environments Required 7 Years | Data Warehousing Best Practices Required 7 Years | Automation using Python/SnowSQL Required 7 Years | ETL/ELT Processes using Snowflake Required 5 Years | Snowflake Stored Procedures, UDFs, and Views Required 5 Years | Working with Snowflake Utilities (SnowPipe, Streams, Tasks) Required 5 Years | Data Integration (Informatica, Talend, Matillion, DBT - Preferable) Highly desired 5 Years | Bachelor's Degree minimum Required | Thanks & Regards Mohd Azhar Uddin Email: [email protected] LinkedIn: https://www.linkedin.com/in/azhar-uddin-13b7b7173/ -- Keywords: continuous integration continuous deployment information technology New Jersey Direct Client: 15+ ONLY - Senior Snowflake Developer (745571) : Local Preferred [email protected] |
| [email protected] View All |
| 08:31 PM 03-Feb-25 |