Greetings from TCS!
Job Title: Snowflake Data Engineer
Experience Range: 5-10 yrs
Location: PAN India
TCS has always been in the spotlight for being adept in the next big technologies. What we can offer you is a space to explore varied technologies and quench your techie soul.
Key Responsibilities
- Strong Experience and understanding of Data warehouse, Data Lake platforms architecture and design aspects
- Design and build scalable ELT pipelines and data models on Snowflake using SQL, DBT and Python.
- Develop data warehousing solutions (star schema, SCD, Data Vault) supporting enterprise analytics and reporting.
- Implement Snowflake-native features – Snowpipe, Streams & Tasks, Time Travel, Data Sharing and Cortex AI functions.
- Lead / support migrations from legacy platforms (Teradata, Oracle, Exadata, GreenPlum, Hadoop) to Snowflake.
- Optimise workloads through warehouse sizing, query tuning, clustering and cost-management best practices.
- Implement data security and governance – dynamic masking, RBAC, row/column-level security and secure data sharing.
- Build CI/CD and automation for Snowflake deployments using DBT, Liquibase and Git-based pipelines.
- Integrate Snowflake with ETL tools (Informatica, DataStage, Matillion) and BI tools (Power BI, Tableau).
TECHNICAL SKILLS
Core / Must-Have
- Snowflake Data Cloud (multi-cloud: AWS/Azure/GCP)
- SQL, PL/SQL, Python; DBT for transformations
- ELT pipeline design & data modelling (Star, SCD, Data Vault)
- Snowpipe, Streams & Tasks, Time Travel, Data Sharing
- Warehouse sizing, query tuning & cost optimisation
- Data security & governance (masking, RBAC)
Complementary / Good-to-Have
- Migration from Teradata / Oracle / Exadata / GreenPlum
- ETL tools – Informatica, IBM DataStage, Matillion
- CI/CD – DBT, Liquibase, Git-based deployments
- BI & visualisation – Power BI, Tableau, Streamlit
- Cloud services – AWS S3, Azure, Snowpark
- Snowflake Cortex AI / GenAI for data
Minimum Qualification: 15 years of full-time education
