Snowflake ETL / Data Engineer
Job Description

Location: Bengaluru / Kochi (Work from Office)
Working Hours: 8 A.M IST – 5 P.M IST (Australia Time Zone)
Experience: 2-3 years of hands-on Snowflake experience
Role Summary
We are seeking hands-on Snowflake Data Engineers to build and maintain data ingestion and transformation pipelines on the Snowflake Data Cloud. Engineer will support a client based in Australia, collaborating with distributed teams across time zones. The role involves moving data from source systems into Snowflake, transforming it into curated, analytics-ready models, and ensuring pipelines are reliable, performant, and cost-efficient.
Key Responsibilities
Design, build, and maintain ETL/ELT pipelines to load data into Snowflake from databases, files, APIs, and streaming feeds.
Implement ingestion using Snowflake-native features such as Snowpipe, COPY INTO, external/internal stages, Streams, and Tasks.
Develop transformation logic using SQL and dbt (or equivalent), following a layered architecture (raw → staging → curated / data marts).




Build and optimise Snowflake objects: databases, schemas, tables, views, materialized views, stored procedures, and user-defined functions.
Tune query and warehouse performance - clustering, warehouse sizing, query profiling, and caching.
Monitor and optimise Snowflake credit/compute consumption to keep the platform cost-efficient.
Integrate with orchestration/ingestion tools such as dbt, Fivetran, Matillion, Airflow, Informatica, or Talend as applicable.
Implement data quality checks and robust error handling within pipelines.
Collaborate with data architects, testers, and the client's business/BI teams to deliver requirements.
Maintain clear documentation for pipelines, data models, and data lineage.
Required Skills
2-3 years of hands-on experience building data pipelines on Snowflake.
Solid SQL - complex joins, window functions, CTEs, and performance tuning.
Practical knowledge of Snowflake features: virtual ware

📌 Data Engineer (Bengaluru)
🏢 Xencia Technology Solutions
📍 Bengaluru