Tredence Analytics Solutions - Snowflake DB Developer - Python (5-10 yrs)

Role : Snowflake DBT Developer

Experience : 5+ years

Preferred : Data Engineering Background

Required Skills : Snowflake, DBT, SQL, Python

Hybrid role from : Bangalore, Chennai, Pune, Gurgaon, Kolkata

Skills and Qualifications :

- Bachelor's and/or master's degree in computer science or equivalent experience.

- Must have total 5+ yrs. of IT experience and 3+ years' experience in Data warehouse/ETL projects.

- Should have experience at least in 1 end to end implementation of Snowflake cloud data warehouse and 2 end to end data warehouse implementations on-premise.

- Expertise in Snowflake - data modelling, ELT using SQL, implementing stored Procedures and standard DWH and ETL concepts

- Hands-on experience with Snowflake utilities, SnowSQL, SnowPipe

- Experience in Data Migration from RDBMS to Snowflake cloud data warehouse

- Deep understanding of Star and Snowflake dimensional modelling

- Proficiency in RDBMS, complex SQL, PL/SQL, Python, Unix Shell Scripting, performance tuning and troubleshoot

- Certified in Snowflake (SnowPro Core) (Desirable).

- Comfortable working in a dynamic, fast-paced, innovative environment with several ongoing concurrent projects

- Should have experience working in Agile methodology

- Strong verbal and written communication skills.

- Strong analytical and problem-solving skills with a high attention to detail.

- Self-motivated, collaborative, innovative, eager to learn, and hands on

- Good to have python coding knowledge

Primary Roles and Responsibilities :

- Collaborate with DW/BI leads to understand new ETL pipeline development requirements

- Triage issues to find gaps in existing pipelines and fix the issues

- Work with business to understand the need in reporting layer and develop data model to fulfill reporting needs

- Help joiner team members to resolve issues and technical challenges.

- Drive technical discussion with client architect and team members

- Orchestrate the data pipelines in scheduler (UC4 and Airflow)