Job Title: Snowflake developer
Location : RTP/San Jose
Contract
Key Responsibilities:
• Design, develop, and maintain data pipelines and ELT workflows in Snowflake using DBT, Python, and other tools.
• Implement and optimize data models, Snowflake schemas, and SQL transformations for scalable analytics solutions.
• Develop and manage user-defined functions (UDFs), stored procedures, and SnowSQL scripts for automation and advanced data processing.
• Integrate data from multiple sources (e.g., Oracle, Teradata, APIs, streaming platforms) into Snowflake with high performance and reliability.
• Optimize query performance, storage usage, and compute resources in Snowflake.
• Implement data quality, monitoring, and governance best practices.
• Collaborate with cross-functional teams including Data Analysts, Architects, and BI developers to deliver robust end-to-end data solutions.
Required Skills:
• 4–10 years of overall experience in Data Engineering.
• Strong hands-on experience in Snowflake — including data load, schema design, performance tuning, and SnowSQL scripting.
• Strong programming experience in Python for data ingestion, transformation, and automation.
• Proficiency in DBT (Data Build Tool) for modeling, transformations, and workflow orchestration.
• Excellent command over SQL (complex queries, optimization, window functions, etc.).
• Experience working with large-scale data sets and performance optimization techniques.
Good to Have:
• Exposure to real-time data ingestion frameworks (Kafka, Kinesis, Spark Streaming, etc.) and streaming analytics.
• Experience with ETL/ELT tools (Informatica, Talend, Airflow, etc.).
• Understanding of data warehousing best practices and cloud platforms (AWS, Azure, GCP).
• Knowledge of JavaScript for Snowflake stored procedures.
Soft Skills:
• Strong problem-solving and analytical mindset.
• Excellent communication and collaboration skills.
• Ability to work in a fast-paced, customer-focused environment.