Sr DBT Developer- Chennai- 27th F2F drive

We are looking for Senior Data Engineer candidates Face to Face Drive on 27th June @ World Trade center, Chennai Role: Senior DBT Developer Experince; 7years to 13 years Notice period : Immediate to 45 days only Primary Skillset: DBT, Airflow, Python, AWS Glue, Snowflake, Databricks and Data Modelling WORK Location: Chennai-Work From Office Drive Address : Perungudi, Chennai, Tamil Nadu 600096 Date and Time: 27th June'26 from 10.30 AM- 3.30PM Key Responsibilities Data Modeling & DBT Development Develop and maintain DBT models (staging, intermediate, mart layers) following modular design and best practices. Implement dbt tests, documentation, sources, macros, and packages. Build reusable and scalable data transformation frameworks. Data Pipeline Engineering Design and optimize ELT workflows using DBT integrated with orchestrators (Airflow, Dagster, Prefect, etc.). Work with cloud data environments - AWS and Snowflake Develop and optimize Snowflake schemas, warehouses, and SQL performance Ensure high performance of SQL transformations and warehouse queries. Data Quality & Governance Implement and maintain data quality tests within DBT (unique, not null, referential integrity). Contribute to version control, CI/CD, documentation standards, and best practices. Implement data quality checks, monitoring, and failure handling Apply RBAC, secure views, and cost/performance optimization in Snowflake Collaboration & Stakeholder Support Work with analysts and business teams to understand requirements and convert them into scalable data models. Support data consumers with well_structured data and documentation (dbt docs). Participate in code reviews and provide engineering guidance. 8+ years experience in Data Engineering / ELT development. Strong SQL proficiency, with experience writing optimized queries. 2+ years of Hands_on experience with DBT Cloud. Experience with AWS cloud data warehouse: AWS Datawarehouse: Snowflake - Develop and optimize Snowflake schemas, warehouses, and SQL performance Familiarity with Git, CI/CD pipelines, and modern data stack principles. Understanding of data modeling techniques (Kimball, Data Vault, Star/Snowflake Experience integrating DBT with orchestrators (Airflow, Dagster, Prefect, etc.). Required Skills AWS Cloud - AWS Glue, S3, Lambda, Step Functions, IAM Strong Python and SQL Hands-on Snowflake experience (performance, security, cost),; Pyspark/Snowpark Programming Data Modelling Production dbt experience (models, tests, macros) Apache Airflow for orchestration Solid understanding of ELT, dimensional modeling, and data quality If Interested please apply using the given link and directly apply to the job.And you will recieve call from our recruiter to book your slot. This job is posted by Aishwarya K HRBP - India Operations Cortex Consultants LLC (US) | Cortex Consulting Pvt Ltd (India) | Tcell (Canada)