Senior Snowflake Developer (Azure)--Downtown ChicagoOnsite at Snowflake, Arizona, USA |
Email: [email protected] |
http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=1897997&uid= From: Vicky Kumar, Altitude Technology Solutions [email protected] Reply to: [email protected] Key Responsibilities: Design & Develop Data Solutions: Develop scalable and efficient data models, tables, and views in Snowflake, ensuring the performance and reliability of data solutions. ETL/ELT Process Development: Design and implement ETL/ELT pipelines to extract, transform, and load data into Snowflake from various sources (e.g., APIs, databases, flat files). Optimize data flows for performance and scalability. Snowflake Data Modeling: Develop and maintain dimensional and relational data models in Snowflake, ensuring proper indexing, partitioning, and optimization techniques are applied. Performance Optimization: Monitor and optimize Snowflake queries and database performance using techniques like clustering, materialized views, and query optimization strategies. Address performance bottlenecks and improve overall efficiency. Data Transformation: Write and optimize complex SQL queries to transform data for reporting and analytics. Ensure proper use of Snowflakes features, such as time travel, zero-copy cloning, and multi-cluster warehouses. Integration with Other Tools: Integrate Snowflake with various third-party tools, data lakes, and data warehouses (e.g., AWS S3, Azure Blob Storage, Google Cloud Storage). Use data integration platforms like Matillion, Talend, or Informatica for data workflows. Collaboration with Teams: Collaborate with data engineers, analysts, and stakeholders to gather requirements, define solutions, and deliver high-quality, scalable data products. Data Governance & Security: Implement data governance practices by managing user roles, access controls, and security policies in Snowflake. Ensure compliance with data privacy regulations and internal standards. Testing & Debugging: Develop unit and integration tests for Snowflake data processes to ensure data quality and reliability. Identify and troubleshoot data issues and bugs effectively. Required Skills & Experience: Snowflake Expertise: Proven experience in developing and managing data solutions in Snowflake, including creating databases, schemas, tables, stages, file formats, and virtual warehouses. SQL Expertise: Strong SQL development skills, with experience writing and optimizing complex queries, stored procedures, and user-defined functions (UDFs). ETL/ELT Tools & Technologies: Experience with ETL/ELT tools like Matillion, Talend, Informatica, or Apache NiFi. Experience with cloud-based ETL processes is a plus. Cloud Platforms: Strong understanding of cloud platforms (AWS, Azure, Google Cloud) and their integration with Snowflake, particularly cloud storage services (e.g., S3, Azure Blob, Google Cloud Storage). Scripting & Automation: Proficiency in scripting languages like Python, JavaScript, or Bash for data automation, orchestration, and integration tasks. Performance Tuning: Experience in optimizing Snowflake resources and queries to improve system performance and reduce costs. Data Warehousing & Modeling: Strong background in data warehousing principles, dimensional modeling, and best practices for managing large datasets. Version Control & CI/CD: Familiarity with version control systems (e.g., Git) and experience in integrating Snowflake development processes with CI/CD pipelines. Thanks and Regards, Vicky Kumar Altitude Technology Solutions Inc Email : [email protected] Keywords: continuous integration continuous deployment sthree Senior Snowflake Developer (Azure)--Downtown ChicagoOnsite [email protected] http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=1897997&uid= |
[email protected] View All |
10:03 PM 04-Nov-24 |