Job Title: Snowflake Developer
Key Responsibilities
Design, develop, and maintain data pipelines and ELT workflows using Snowflake
Write and optimize complex SQL queries for data transformation, validation, and performance tuning
Develop and manage Snowflake objects (tables, views, schemas, streams, tasks, and stored procedures)
Build scalable data ingestion frameworks from multiple sources (databases, APIs, cloud storage)
Implement data modeling techniques (dimensional modeling, star/snowflake schemas)
Ensure data quality, integrity, and consistency through validation and reconciliation processes
Optimize Snowflake performance using query tuning, warehouse sizing and clustering, partitioning and caching strategies
Work with cross-functional teams to support reporting, analytics, and downstream applications
Participate in code reviews, testing, and deployment activities across environments (Dev, QA, Prod)
Mandatory Skills & Experience
4–8 years of experience in data engineering / data warehousing
Strong proficiency in SQL (complex joins, window functions, CTEs, subqueries, performance tuning and query optimization)
Hands‐on experience in Snowflake development (streams, tasks, time travel, stored procedures & UDFs)




Experience with data warehousing concepts and ETL/ELT pipelines
Exposure to cloud platforms (AWS / Azure / GCP)
Experience with data integration tools (Informatica, ADF, DBT, or similar)
Strong understanding of data validation and reconciliation techniques
Benefits
Highly competitive salary package aligned with the Australian market, complemented by performance-based incentives and recognition programs
Global exposure with local impact – work with leading Australian enterprises and collaboration with our global network of experts
Empowering leadership and supportive environment fostering initiative, innovation, and career growth
Inclusive, collaborative culture valuing diversity, inclusion, and respect
Continuous learning & cutting-edge innovation: structured learning programs, global certifications, leadership development and opportunities to work with emerging technologies
Equal Chance Employer
TCS is an equal opportunity employer.
All qualified applicants will be considered without regard to race, colour, religion, gender, gender identity, sexual orientation, national origin, disability, veteran status, or any other characteristic protected by applicable law.
#J-*****-Ljbffr

📌 Snowflake Developer (New South Wales)
🏢 Tata Consultancy Services
📍 New South Wales