Experience- 6+Years
Key Responsibilities ● Design, develop, and maintain modular DBT models following industry best practices. ● Build scalable transformation pipelines using DBT Core or DBT Cloud. ● Convert complex business requirements into reusable SQL models. ● Develop incremental models, snapshots, seeds, and macros. ● Create and maintain DBT source configurations and model documentation. ● Implement comprehensive data quality tests using built-in and custom DBT tests. ● Optimize model execution performance and dependency management. ● Design dimensional models including facts, dimensions, and aggregate tables. ● Implement Medallion Architecture (Bronze, Silver, Gold) using DBT transformations. ● Perform query optimization and improve warehouse performance. ● Participate in code reviews and enforce DBT development standards. ● Collaborate with Data Engineers, Data Architects, BI Developers, and Business Analysts. ● Support CI/CD deployment pipelines for DBT projects. ● Troubleshoot production issues and resolve data pipeline failures. Core DBT Skills ● DBT Core / DBT Cloud (3+ Years) ● Advanced DBT Model Development ● Incremental Models ● Snapshots ● Seeds ● Macros & Jinja Templates ● Source Configuration ● Model Documentation ● Data Lineage Management ● Package Management ● Custom DBT Tests ● Schema.yml Configuration ● Project Structure & Best Practices SQL & Data Transformation ● Advanced SQL (4+ Years) ● Complex Joins ● Common Table Expressions (CTEs) ● Window Functions ● Stored Procedures (Preferred) ● Query Optimization ● Execution Plan Analysis ● Data Cleansing & Transformation Data Modeling ● Dimensional Data Modeling ● Star Schema ● Snowflake Schema ● Fact & Dimension Tables ● Slowly Changing Dimensions (SCD Type 1 & 2) ● Data Vault (Preferred) ● Medallion Architecture Cloud Data Warehousing Hands-on experience with one or more: ● Snowflake ● Databricks SQL Warehouse ● Google BigQuery ● Amazon Redshift ● Azure Synapse Analytics Data Quality & Governance
Pay: ₹1,000,000.00 - ₹1,200,000.00 per year
Work Location: Remote
