Key Responsibilities:
Database Design and Development: Design and develop scalable database systems using Snowflake, ensuring data integrity and performance optimization.
Data Warehousing: Build, optimize, and maintain Snowflake-based data warehouses for handling vast datasets.
ETL Development: Create efficient ETL (Extract, Transform, Load) processes for data ingestion, transformation, and storage.
SQL Querying: Write complex SQL queries to retrieve, update, and manage data across various databases.
Performance Tuning: Optimize SQL queries and Snowflake performance for faster data processing and analysis.
Integration with BI Tools: Work with BI (Business Intelligence) tools to integrate and visualize data for decision-making.
Automation: Automate repetitive database processes and tasks, ensuring smooth operations.
Key Skills:
Snowflake: Expertise in cloud data warehousing with Snowflake, including database and schema design, performance tuning, and data sharing.
SQL: Strong proficiency in SQL for data manipulation, query optimization, and database management.
Data Warehousing Concepts: Solid understanding of dimensional modeling, data marts, and data lakes.
ETL Tools: Experience with ETL tools and processes like Informatica, Matillion, or Talend for data transformation and loading.
Cloud Platforms: Knowledge of cloud environments (AWS, Azure, or GCP) as Snowflake is typically deployed on these platforms.
Scripting Languages: Familiarity with Python or Shell scripting for automation and data handling.
Bachelor's degree