About the Company Greetings from TATA Consultancy Services! About the Role We are seeking an experienced Snowflake & dbt Data Engineer with 6–12 years of experience in designing and implementing scalable cloud data warehouse solutions. The ideal candidate should possess robust expertise in Snowflake, dbt, SQL, Python, and cloud-based data transformation frameworks. The role involves building data pipelines, transforming data models, optimizing performance, and supporting enterprise analytics and reporting initiatives. Responsibilities Design and develop scalable data warehouse solutions using Snowflake. Build and maintain dbt models, macros, tests, and documentation. Develop and optimize ELT pipelines for enterprise data platforms. Create dimensional models, fact tables, and business data marts. Implement data quality checks and automated testing using dbt. Optimize Snowflake performance, storage, and compute costs. Develop reusable frameworks and standards for data engineering projects. Collaborate with business stakeholders, solution architects, and analytics teams to gather requirements. Support production deployments, troubleshooting,
and performance tuning activities. Ensure adherence to data governance, security, and compliance standards. Qualifications BE / B.Tech / MCA / M.Tech or equivalent qualification. Required Skills Hands-on experience with Snowflake Data Cloud Strong expertise in dbt (Data Build Tool) Advanced SQL programming and query optimization Experience in Data Warehousing and Dimensional Modeling Strong Python programming skills Experience with ETL/ELT development and optimization Knowledge of Snowflake features such as: Virtual Warehouses Streams & Tasks Time Travel Zero Copy Cloning Snowpipe Secure Data Sharing Experience working with cloud platforms (AWS/Azure/GCP) Git/GitHub version control Preferred Skills PySpark Databricks Airflow AWS Glue Kafka Terraform CI/CD Pipelines Data Governance and Data Quality frameworks Pay range and compensation package Experience: 6 – 12 Years Location: Pune / Bangalore / Hyderabad / Chennai / Mumbai Equal Opportunity Statement We are committed to diversity and inclusivity.