Snowflake Data Engineer

Req number:

Employment type:

Worksite flexibility:

CAI is a global services firm with over 9000 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 rightwhatever 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

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 Youll 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 Youll 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 or (888).