Snowflake Administrator

We are seeking an experienced Snowflake Administrator with strong hands-on Snowflake Development expertise to manage, optimize, and enhance our enterprise data warehouse environment. The ideal candidate will have extensive experience administering Snowflake, developing scalable data solutions, and working with ETL tools (Informatica) and Amazon Redshift in AWS environments. This role requires a combination of administration, performance tuning, data engineering, and cloud data warehouse expertise.

Key Responsibilities

• Administer, configure, and maintain Snowflake environments across Development, QA, and Production.
• Monitor Snowflake performance, optimize warehouses, storage, and query execution.
• Design, develop, and optimize Snowflake databases, schemas, tables, views, and data pipelines.
• Build and maintain Snowflake objects including:
  • Stored Procedures
  • Tasks
  • Streams
  • Snowpipe
  • Materialized Views
  • Secure Views
• Develop complex SQL queries and optimize data models for analytical workloads.
• Design and implement ELT/ETL processes using Informatica PowerCenter or Informatica Intelligent Cloud Services (IICS).
• Integrate data from multiple sources including Amazon Redshift, relational databases, cloud storage, and APIs.
• Perform data migration between Redshift and Snowflake while ensuring data quality and integrity.
• Implement role-based security, access controls, masking policies, and governance within Snowflake.
• Monitor system health, resource utilization, and cost optimization.
• Automate administrative tasks using SQL, Python, or Shell scripting.
• Collaborate with Data Engineers, BI Developers, Architects, and Business teams to deliver scalable data solutions.
• Troubleshoot production issues and provide performance tuning recommendations.
• Participate in disaster recovery planning, backup strategies, and environment management.

Requirements

• Strong experience with Snowflake administration and development.
• Experience working with ETL tools such as Informatica PowerCenter or Informatica Intelligent Cloud Services.
• Knowledge of Amazon Redshift and AWS environments.
• Proficiency in SQL, Python, or Shell scripting.
• Ability to collaborate with cross-functional teams and stakeholders.
• Strong analytical and problem-solving skills.
• Excellent communication and teamwork abilities.
• Relevant certifications in Snowflake or related technologies is a plus.