Lead Data Engineer/SnowSQL Developer: Required Skillsets:
- Snowflake Knowledge and SQL Proficiency: We need individuals with a profound understanding of Snowflake's architecture, features, and functionality. Additionally, advanced proficiency in SnowSQL is essential for crafting intricate queries and efficiently manipulating data within Snowflake.
- Scripting and Automation: These professionals should possess the ability to leverage scripting languages for automating SnowSQL tasks and ETL/ELT processes. Their proficiency should extend to optimizing SQL queries, data loading procedures, and data transformation processes to enhance performance.
- Data Integration: Familiarity with various data integration techniques, including batch and real-time data ingestion. Experience with Informatica Intelligent Cloud Services (IICS) and the capability to configure data connectors and pipelines using SnowSQL .
- Data Modeling: An understanding of data modeling concepts and the capacity to design effective database schemas within Snowflake.
- Communication and Collaboration Skills: Strong interpersonal and teamwork skills are essential for effective collaboration with other team members.
Skill Rating (0-10) Year of experience Snowflake SQL DBT Git Shell Scripting Jenkins ny IDE (preferably VS Code) ETL (Informatica Cloud IICS)