Snowflake+DBT Developer

Job Description

About Company : Our client is a global technology cons,ulting and digital solutions company, resulting from the merger . It focuses on helping businesses leverage digital technologies to reimagine business models, accelerate innovation, and drive growth. The company provides services across various industries, including digital transformation, consulting, and application development. Role:Snowflake+DBT Developer Location:Pan India I nterview Mode : virtual Work mode : Hybrid Job type : C2H Immediate Joiner's :15 Day's Experience:6-12 Mandatory Skills:Snoflake,DBT,Azure, Azure DevOps, JD: NBFC seeking for a snowflake + DBT developers with strong knowledge in DBT. Candidate should have real time experience in creating and maintaining models, snapshots in DBT based on the client requirement. Experience with Azure DevOps, Command-D, python are added advantages. Job Description: 1. Strong SQL skills in window functions, CTEs, unions, DDL, Optimization techniques. 2. Create and maintain DBT models in staging, intermediate and data marts layers. 3. Collaborate with data analysts, engineers and business analysts to understand the data needs. 4. Implement data quality checks and automates testing using DBT. 5. Proficient in DBT (SCD type 1, type 2 concepts, incremental load, historical load, surrogate keys). 6. Good knowledge in snowflake concepts (Sequences, Time travel, Debugging the scripts). 7. Good Communication skill and consistently meets deadlines. Note: Ability to understand the requirement, developing the models and interpreting the logics and debugging the models and unit testing and implementing the functionality are required skill.