Snowflake & SQL Professional

We are looking for an experienced Snowflake / SQL Developer with 6-10 years of experience in Data Engineering, Data Warehousing, ETL/ELT development, and cloud-based data platforms.

The ideal candidate should have strong hands-on expertise in Snowflake and Advanced SQL, with experience in developing scalable data warehouse solutions, building ETL/ELT pipelines, optimizing queries, implementing data security, and supporting analytics and reporting requirements.

Experience with AWS and Python is preferred but not mandatory.

Key Responsibilities

• Design, develop, and maintain scalable Snowflake data warehouse solutions.
• Develop complex and optimized SQL queries, stored procedures, functions, and data transformations.
• Work extensively with Snowflake databases, schemas, tables, views, stages, warehouses, and file formats.
• Develop and maintain ETL/ELT data pipelines for batch and incremental data processing.
• Implement and manage Snowflake Streams, Tasks, and Snowpipe.
• Perform SQL and Snowflake query optimization and performance tuning.
• Implement data loading, transformation, validation, and reconciliation processes.
• Design and maintain data models including Star Schema, Snowflake Schema, fact and dimension tables.
• Implement appropriate Snowflake security, RBAC, and access controls.
• Troubleshoot data pipeline failures and performance issues.
• Collaborate with Data Engineers, Architects, Analysts, and business stakeholders.
• Follow Git, CI/CD, Agile, and DevOps practices.
• Develop Python scripts for automation and data processing where required.
• Work with AWS services such as S3, Glue, IAM, and Lambda where applicable.
• Prepare technical documentation and participate in knowledge-sharing activities.

Required Skills

• 6+ years of experience in Data Engineering, ETL, or Data Warehousing.
• Strong hands-on experience with Snowflake.
• Excellent proficiency in Advanced SQL.
• Strong knowledge of:
  • Complex joins
  • CTEs
  • Subqueries
  • Window functions
  • Stored procedures
  • Query optimization
  • Performance tuning
• Hands-on experience with Snowflake Streams, Tasks, Snowpipe, stages, and file formats.
• Strong understanding of ETL/ELT concepts and data pipeline development.
• Experience with data warehousing and data modeling concepts.
• Knowledge of batch, incremental, and CDC-based data ingestion.
• Understanding of Snowflake security and RBAC.
• Experience with Git and CI/CD practices.
• Strong analytical and problem-solving skills.

Good to Have

• Python scripting and automation experience.
• AWS experience, particularly:
  • S3
  • AWS Glue
  • IAM
  • Lambda
• Experience with ETL/ELT tools such as Informatica, Matillion, Talend, dbt, or AWS Glue.
• SnowPro Core or SnowPro Advanced certification.
• Experience working in the Healthcare domain.

Education

Bachelors/Master s degree in Computer Science, Information Technology, Engineering, or equivalent experience.

Soft Skills

• Strong communication and interpersonal skills.
• Good analytical and problem-solving capabilities.
• Ability to work independently and within a team.
• Strong stakeholder collaboration skills.
• Good documentation and knowledge-sharing abilities.

Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.