Snowflake dbt Engineer
Must Have Technical/Functional Skills
Mandatory Technical skills - Snowflake, dbt, SQL, Python, Data Engineering, Data Modeling
•5+ years of overall Data Engineering experience.
•3+ years of hands-on Snowflake development experience in production environments.
•2+ years of hands-on dbt Core or dbt Cloud development experience.
•Strong hands-on experience with Advanced SQL, ELT/ETL pipelines, data modeling, performance tuning, and production support.
•Recent coding and development experience is mandatory. Profiles that are mainly architecture-focused should not be considered.
Roles & Responsibilities
•Design, develop, test, deploy, and support ELT pipelines using Snowflake and dbt.
•Build dbt models across staging, intermediate, and mart layers using reusable and maintainable development standards.
•Create and manage dbt incremental models, snapshots, tests, documentation, sources, seeds, macros, and packages.
•Develop Snowflake objects including databases, schemas, tables, views, secure views, streams, tasks, and Snowpipe pipelines.
•Write and optimize complex SQL queries, stored procedures, and transformation logic.
•Perform source-to-target mapping and implement transformation rules based on business and technical requirements.
•Build dimensional data models, data marts, facts, dimensions, and analytics-ready datasets.
•Implement data quality checks, reconciliation controls, exception handling, and monitoring mechanisms.
•Troubleshoot production data issues, pipeline failures, performance bottlenecks, and data discrepancies.
•Optimize Snowflake warehouse usage, query performance, clustering, and cost efficiency.
•Work with business analysts, data architects, application teams, and reporting teams to deliver trusted data products.
•Support CI/CD and DataOps practices for Snowflake and dbt deployments Education: Bachelor’s degree
TCS Employee Benefits Summary
•Discretionary Annual Incentive.
•Comprehensive Medical Coverage: Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans.
•Family Support: Maternal & Parental Leaves.
•Insurance Options: Auto & Home Insurance, Identity Theft Protection.
•Convenience & Professional Growth: Commuter Benefits & Certification & Training Reimbursement.
•Time Off: Vacation, Time Off, Sick Leave & Holidays.
•Legal & Fin ancial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.
Salary Range: $100000 - 120000 a year
#LI-JH1
More Information
Application Details
- Organization DetailsTCS / Tata Consultancy Services
Recommended Comments
There are no comments to display.
Join the conversation
You are posting as a guest. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.