Tredence Analytics Solutions - Snowflake DB Developer - Python

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) (ref:hirist.tech)

Location: in, IN

Posted Date: 11/22/2024