Snowflake Data Engineer

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 parsing and semi-structured data processing

• Handle ingestion from flat files and JSON files through Snowflake external stages and COPY commands

• Monitor pipeline health, resolve replication lag, and maintain ingestion SLAs

• Design data models using Star Schema and Fact/Dimension structures aligned to business reporting needs

• Build and maintain business-ready data marts for consumption by Spotfire and downstream applications

• Collaborate with analytics and BI teams to understand data requirements and deliver optimized datasets

• Document data models, lineage, and mart structures for ongoing maintenance and onboarding

• Use AWS S3 for staging raw data files as part of the ingestion workflow

• Configure IAM roles and policies to manage access between AWS services and Snowflake

• Use AWS Lambda for lightweight data transformation or pipeline trigger automation where applicable

What You'll Need

Required:

• Proven 3-4 Yrs of experience in Snowflake development and optimization

• Strong expertise in ETL/ELT pipeline design and development using Pentaho Data Integration (PDI/Kettle)

• Hands-on experience with AWS DMS and AWS services including S3, Lambda, and IAM policies

• Solid understanding of data modeling concepts including Star Schema and Fact/Dimension structures

Preferred:

• Familiarity with Spotfire for BI and analytics

• Experience with API-based data ingestion and JSON processing

Physical Demands

• Ability to safely and successfully perform the essential job functions

• Sedentary work that involves sitting or remaining stationary most of the time with occasional need to move around the office to attend meetings, etc.

• Ability to conduct repetitive tasks on a computer, utilizing a mouse, keyboard, and monitor

Reasonable accommodation statement

If you require a reasonable accommodation in completing this application, interviewing, completing any pre-employment testing, or otherwise participating in the employment selection process, please direct your inquiries to application.accommodations@cai.io or (888) 824 – 8111.