Proficiency in Snowflake Data Warehouse architecture and implementation.
Experience in designing and maintaining ELT/ETL pipelines using Python, DBT, and Snowflake SNOWSQL.
Knowledge of cloud storage technologies like Azure Blob, AWS S3, or GCP is advantageous.
Strong SQL skills with experience in writing and tuning complex queries.
Requirements:
Architect and implement business intelligence solutions using Snowflake.
Develop and maintain data pipelines and database objects in Snowflake.
Load data into Snowflake using Snow pipes and manage data transformations with DBT.
Support business intelligence functions through SQL query optimization and scripting.
Job description
Greetings from Coders Brain Technology Pvt. Ltd.
Let this Diwali burn all your bad times and enter you in good times with new job
Coders Brain is a global leader in its services, digital, and business solutions that partners with its clients to simplify, strengthen, and transform their businesses. We ensure the highest levels of certainty and satisfaction through a deepset commitment to our clients, comprehensive industry expertise, and a global network of innovation and delivery centers.
Location: REMOTE
Position: Permanent with Coders Brain Technology Pvt. Ltd.
Experience: 215 Years
Notice Period: Immediate
JOB DESCRIPTION:
Responsible for architecting and implementing business intelligence solutions around Snowflake Data Warehouse.
• Able to design, develop, and maintain ELTETL pipelines in and out of data warehouse using combination of Python, data build tools (DBT) and Snowflakes SNOWSQL.
• Good to have working knowledge on cloud storage technologies like Azure BlobAWS S3GCP.
• Should be worked on multiple onpremises relational databases like MYSQL, Oracle and MS SQL server etc.
• Design, Develop, and maintain data base objects like tables, views, functions, stored procedures, and scripts in snowflake.
• Good to have knowledge on Java Script to implement procedures in snowflake.
• Should load data in snowflake using Snow pipes.
• Should have knowledge on all newly added functionalities in snowflake.
• Recent experience in writing and tuning complex SQL queries and debugging to support business intelligence functions.
• Experience in Python code, shell scripts, and complex SQL.
• Experience building robust data pipelines beyond simple API pulls.
• Able to write complex Python scripts to automate various tasks in our day to day operations.
• Have good knowledge and experience in command line tool DBT.
• Able to do complex Transformations using DBT.
• Should have experience on multiple reporting tools.
• Excellent written and verbal communication skills.
