Senior Snowflake Developer | Snowflake DW, Advanced SQL, Python

Tata Consultancy Services; Khordha, Hyderabad, Bengaluru; On-site; INR 1,800,000 - 3,200,000; Full time

Job summary

Tata Consultancy Services is seeking a Snowflake Data Engineer to design, build, and optimize scalable Snowflake Data Warehouse solutions for analytics. You will develop ETL/ELT pipelines, write and tune complex SQL, and implement Snowpipe alongside data governance measures.

The role requires modeling, RBAC, and data-masking controls in a cloud environment. Ideal candidates have 4–10 years IT experience with 3+ years in Snowflake, strong SQL skills, and hands-on experience with semi-structured

Qualifications

• 4 to 10 years of overall IT experience with at least 3+ years of hands-on experience in Snowflake Data Warehouse.
• Strong expertise in Advanced SQL, query optimization, stored procedures, views, tasks, streams, and window functions.
• Solid understanding of Data Warehousing concepts, dimensional modeling, Star/Snowflake schemas, SCD, and ETL/ELT frameworks.
• Proven experience designing and implementing large-scale data pipelines and data integration solutions on Snowflake.

Responsibilities

• Design, develop, and maintain scalable Snowflake Data Warehouse solutions to support business and analytics requirements.
• Build and optimize ETL/ELT pipelines for ingesting, transforming, and loading data into Snowflake.
• Develop and tune complex SQL queries, stored procedures, tasks, streams, and views for high performance.
• Implement and manage Snow pipe, stages, and data ingestion frameworks for real-time and batch loading.
• Collaborate with architects, data engineers, analysts, and stakeholders to deliver data solutions.
• Develop automation using Python (or Scala) for data processing, orchestration, validation, and monitoring.

Skills

Snowflake DW

Advanced SQL

Data modeling

ETL/ELT

Python

Scala

JSON/XML/Parquet/Avro

Kafka

AWS S3

RBAC

Data masking

Cortex AI/ML

Time Travel

Zero-Copy Cloning

Data Sharing

Performance tuning

Tools

Snowflake

Python

Scala

AWS S3

Kafka

Job description

• Design, develop, and maintain scalable Snowflake Data Warehouse (DW) solutions to support business and analytics requirements.
• Build and optimize ETL/ELT pipelines for ingesting, transforming, and loading data from multiple source systems into Snowflake.
• Develop and tune complex SQL queries, stored procedures, tasks, streams, and views to ensure high performance and efficient data processing.
• Implement and manage Snow pipe, stages, and continuous data ingestion frameworks for real-time and batch data loading.
• Work with structured and semi-structured data (JSON, XML, Parquet, Avro) and develop scalable data transformation solutions.
• Design and implement data models including Star Schema, Snowflake Schema, Dimensions, and Fact Tables.
• Collaborate with architects, data engineers, analysts, and business stakeholders to understand requirements and deliver data solutions.
• Develop automation and scripting solutions using Python (or Scala) for data processing, orchestration, validation, and monitoring.
• Integrate Snowflake with cloud platforms and services such as AWS S3, Kafka, and other enterprise data sources.
• Monitor, troubleshoot, and optimize Snowflake workloads, warehouses, caching mechanisms, and overall platform performance.
• Implement data governance, data quality, security, RBAC, masking policies, and compliance controls across the Snowflake ecosystem.
• Perform data validation, reconciliation, and completeness checks to ensure accurate and reliable data delivery.
• Support data migration initiatives and resolve challenges associated with migrating legacy data warehouse workloads to Snowflake.
• Leverage advanced Snowflake capabilities such as Time Travel, Fail-safe, Data Sharing, Dynamic Tables, Cortex AI/ML, and Zero-Copy Cloning where applicable.
• Participate in architecture discussions, code reviews, and best practice adoption to ensure scalable and maintainable data solutions.
• Create technical documentation, operational runbooks, and deployment procedures while providing production support and issue resolution.

Preferred candidate profile

• 4 to 10 years of overall IT experience with at least 3+ years of hands-on experience in Snowflake Data Warehouse.
• Strong expertise in Advanced SQL, query optimization, stored procedures, views, tasks, streams, and window functions.
• Solid understanding of Data Warehousing concepts, dimensional modeling, Star/Snowflake schemas, SCD implementation, and ETL/ELT frameworks.
• Proven experience designing and implementing large-scale data pipelines and data integration solutions on Snowflake.
• Hands-on experience with Snowflake features such as Snow pipe, Time Travel, Zero-Copy Cloning, Dynamic Tables, Data Sharing, RBAC, and Data Masking.
• Strong programming skills in Python (preferred) or Scala for automation, data processing, and orchestration.
• Experience working with semi-structured data such as JSON, XML, Parquet, and Avro.
• Good knowledge of streaming technologies such as Kafka and real-time data ingestion patterns.
• Experience with cloud storage platforms such as AWS S3 and cloud-native data architectures.
• Strong understanding of Data Governance, Data Quality, Security, and Compliance practices.
• Experience in performance tuning, troubleshooting, and optimizing Snowflake workloads and warehouses.
• Exposure to AI/ML capabilities within Snowflake, including Snowflake Cortex, will be an added advantage.
• Excellent problem-solving, communication, and stakeholder management skills.
• Ability to work in a fast-paced, cross-functional, and client-facing environment.