Senior Snowflake Developer

PETADATA is looking for a Snowflake Developer to work with one of our clients.

Job Location: Raleigh, NC (Onsite).

Work Authorization: W2 Only.

Experience: 10 years of experience.

Job Description:

PETADATA is looking for a Snowflake Developer who works with the Data Services teams to build and maintain the Snowflake SaaS service for building advanced data solutions throughout the organization. We need hands-on experience in this role using the Snowflake platform.

Roles & Responsibilities:

• Should be able to develop, build & maintain mission-critical centralized data platforms using Snowflake.
• Must be able to Design, implement and test cloud computing solutions using Snowflake technology.
• Should be able to Monitor and optimize ETL/ELT processes, migrating solutions from on-premises to public cloud platforms.
• You should be able to identify & perform the core administration for the snowflake environment.
• Must be able to build the automation to optimize the environment, build pipelines to define metrics-related things in Snowflake, and be the key central point of contact for a Snowflake within the organization.
• Should be able to diagnose and troubleshoot Snowflake database errors.
• You must have prior experience with multiple internal user groups including analytics and data science.
• Should be able to implement the Snowflake user /query log analysis and alerts.
• Work with heterogeneous user groups from data engineers to data scientists.
• Must be able to implement data encryption/decryption/masking policies to protect PII/PCI data.
• Should demonstrate proficiency in index design, query plan optimization, and analysis required.
• Support security audits for the user implementation/support automation for production deployment in the Snowflake platform.
• Should actively work with Snowflake support for raising support tickets and triaging outages.
• Able to create a Snowflake utilization and capacity plan.
• Must take On-call responsibilities on a rotational basis for Snowflake database administration.

Required Skills:

• The ideal person should know about Data storage, query processing, and cloud services Layers.
• Should have good experience with Snowflake / SNOW SQL.
• Must know Python, and TIDAL.
• Should be an expert in Microsoft SQL Server, Oracle, and process automation.
• Expertise in Data Integration tools like Informatica, and SSIS.
• Must have experience in AWS/ Azure Cloud DevOps, and Data Bricks.
• Should have good experience in Data Factory, GIT, and CI/CD.
• Experience on Database like SQL, Oracle, PL/SQL, XML
• Migration to AWS or Azure Snowflake platform.
• SQL performance measuring, query tuning, and database tuning.
• Ability to build analytical solutions and models & Integration with third-party tools.
• Coding in languages like Python, Java, JavaScript.
• Root cause analysis of models with solutions.
• Hadoop, Spark, and other warehousing tools.
• Managing sets of XML, JSON, and CSV from disparate sources.
• SQL-based databases like Oracle SQL Server, Teradata, etc.
• Snowflake warehousing, architecture, processing, administration.
• Data ingestion into Snowflake.
• Enterprise-level technical exposure to Snowflake applications

If you are interested and meet the above job requirements, please submit your resume to:

After carefully reviewing your experience and skills, one of our Hiring team members will contact you on the next steps.