Snowflake Data Engineer
Req number:
R8079
Employment type:
Full time
Worksite flexibility:
Onsite
Who we are
CAI is a global services firm with over 9,000 associates worldwide and a yearly revenue of $1.3 billion+. We have over 40 years of excellence in uniting talent and technology to power the possible for our clients, colleagues, and communities. As a privately held company, we have the freedom and focus to do what is right—whatever it takes. Our tailor-made solutions create lasting results across the public and commercial sectors, and we are trailblazers in bringing neurodiversity to the enterprise.
Job Summary
We are looking for a motivated Snowflake Data Engineer ready to take us to the next level If you have strong experience in designing, developing, and maintaining scalable data solutions using Snowflake and associated technologies and are looking for your next career move, apply now.
Job Description
We are looking for a Snowflake Data Engineer to help build robust data pipelines, optimize data warehouse performance, and develop business-ready data models and marts.



This position will be Full time and Onsite – Gurugram.
What You’ll Do
Build and maintain scalable data pipelines and transformation layers within Snowflake
Design and develop Snowflake objects including tables, views, stages, tasks, streams, and stored procedures
Apply Snowflake best practices for warehouse sizing, clustering, caching, and query optimization
Ensure data quality, consistency, and availability across the warehouse layers
Support performance tuning and scalability improvements as data volumes grow
Design and develop ETL/ELT pipelines to ingest data from Oracle, PostgreSQL, and MySQL databases
Design, develop, and maintain ETL/ELT jobs and transformations using Pentaho Data Integration (PDI/Kettle) for loading data into Snowflake
Configure and manage AWS DMS tasks for Full Load and CDC-based data ingestion into Snowflake
Build ingestion pipelines for API-based sources including JSON

📌 Snowflake Data Engineer (Gurugram)
🏢 CAI
📍 Gurugram