Senior Snowflake Data Engineer
- CAI
- 4 - 6 years
- Noida, Gurugram
- 2 months ago
- Email to a friend
- Report this job
Job Description
Senior Snowflake Data Engineer
Req number:
R6500
Employment type:
Full time
Worksite flexibility:
Onsite
Who we areCAI is a global technology services firm with over 8,500 associates worldwide and a yearly revenue of $1 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
We are looking for a motivated Snowflake Data Engineer ready to take us to the next level! If you understand Snowflake, ETL, Oracle (PL/SQL) and PostgreSQL, AWS, Azure and are looking forward to your next career move, apply now
Job Description
We are looking for Snowflake Data Engineer. This position will be full-time and onsite Gurugram.
What Youll Do
- Design, develop, and optimize ETL/ELT pipelines in Snowflake for data ingestion, transformation, and loading.
- Build and maintain CDC (Change Data Capture) pipelines to support incremental data updates and real-time data synchronization.
- Develop and maintain data marts to support Spotfire dashboards and other analytical workloads.
- Integrate and migrate data from Oracle and PostgreSQL databases into Snowflake.
- Write, review, and optimize complex SQL, PL/SQL, and PostgreSQL queries for data analysis and transformation.
- Collaborate with BI developers and business users to understand reporting requirements and deliver efficient data structures.
- Implement best practices for data modeling, query performance tuning, and warehouse optimization in Snowflake.
- Manage Snowflake environments, including warehouses, user roles, security, and cost optimization.
- Ensure data quality, accuracy, and consistency across all systems and pipelines.
- Work closely with data governance and operations teams to maintain compliance and metadata integrity.
What You'll Need
Required:
- Bachelors or masters degree in computer science, Information Technology, or a related field.
- 4+ years of experience in data engineering or data warehousing roles.
- Strong hands-on experience with Snowflake, including schema design, Snowpipe, Streams, Tasks, and CDC pipelines.
- Solid working experience with Oracle (PL/SQL) and PostgreSQL, including query writing, tuning, and data extraction.
- Advanced SQL skills for building, debugging, and optimizing complex queries.
- Experience designing data marts and preparing data models for Spotfire or other BI tools.
- Scripting knowledge in Python for automation and data processing.
- Understanding of cloud environments (AWS, Azure).
- Strong analytical thinking and problem-solving abilities.
Preferred Skills (Nice to Have):
- Experience with Spotfire data integration and dashboard optimization.
- Exposure to real-time/streaming data frameworks.
- Familiarity with CI/CD pipelines and DevOps practices for data workflows.
- Knowledge of data governance, lineage, and metadata management.
Physical Demands
- Sedentary work that involves sitting or remaining stationery 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 ap***********************s@***.io or (888) 824 8111.
Job Classification
Industry: IT Services & ConsultingFunctional Area / Department: Engineering - Software & QARole Category: Software DevelopmentRole: Data EngineerEmployement Type: Full timeContact Details:
Company: CAILocation(s): Noida, Gurugram
Keyskills: continuous integration data analytical ci/cd data warehousing snowpipe sql plsql database design data mart data modeling postgresql devops etl snowflake cd python oracle data analysis spotfire change microsoft azure data engineering data governance aws data integration
Similar positions
CAI
As a privately held company with a global footprint, our 9,500 associates have the freedom and the focus to do whats right for our clients, colleagues, and communities. We have a 41-year history of combining our dual strengths of talent and technology to deliver lasting results across the public and...
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in