Hello,
Greetings!
This is Vanna from Stonegate Technologies. We are currently seeking a Sr.Snowflake Data Engineer. Please find the job description below. If you are interested, kindly forward your resume, Visa status, Current Location and contact details for further processing. Additionally, if you know someone who might be looking for a new opportunity, feel free to share this with them.
Role: Sr. Snowflake Data Engineer 12+ Needed
Location : Chicago, IL (Onsite)
Visa : No H1B ,H1BT
Please note that we require a passport number for this position. If you are not comfortable sharing this information, we respectfully ask that you do not submit your resume.
Project Overview:
This project aims to modernize our data architecture by leveraging cloud technologies, specifically Snowflake and Databricks, to enhance our data storage, processing, and analytics capabilities. It involves migrating application data from an on-premises Oracle database to a more scalable, flexible and secure cloud-based environment, optimizing data flows and analytics to support real-time decision-making and insights.
Key Responsibilities:
Data Pipeline Development:
Design, build, and manage data pipelines for the ETL process, using Airflow for orchestration and Python for scripting, to transform raw data into a format suitable for our new Snowflake data model.
Data Integration:
Implement and maintain data synchronization between on-premises Oracle databases and Snowflake using CDC tools.
Support Data Modeling:
Assist in developing and optimizing the data model for Snowflake, ensuring it supports our analytics and reporting requirements.
Reporting Support:
Collaborate with data architect to ensure the data within Snowflake is structured in a way that supports efficient and insightful reporting.
Technical Documentation:
Create and maintain comprehensive documentation of data pipelines, ETL processes, and data models to ensure best practices are followed and knowledge is shared within the team.
Qualifications
Experience: Total 10+ years of experience as data engineer; proven experience as a Snowflake data engineer for 5+ years.
Skills : Strong knowledge of SQL writing complex queries, performance tuning, Strong experience with Oracle, Snowflake, ETL/ELT tools
Data engineering: proven track record of developing and maintaining data pipelines and data integration projects
Orchestration Tools: Experience in Airflow for managing data pipeline workflows.
Programming: proficiency in Python and SQL for data processing tasks.
Data Modeling: Understanding of data modeling principles and experience with data warehousing solutions.
Cloud Platforms: Knowledge of cloud infrastructure and services, preferably Azure, as it relates to Snowflake integration.
Collaboration Tools: Experience with version control systems (like Git) and collaboration platforms.
CI/CD Implementation: Utilize CI/CD tools to automate the deployment of data pipelines and infrastructure changes, ensuring high-quality data processing with minimal manual intervention.
Communication: Excellent communication and teamwork skills, with a detail-oriented mindset. Strong analytical skills, with the ability to work independently and solve complex problems.
Certifications: Snowflake certification is a plus.
Education: Bachelor’s degree in Computer Science, Information Technology, or a related field.
Thanks & Regards
Vanna Rengasamy
Business Development Manager
Call: (732) 444-4857
Email: [email protected]
Address:4400 Route 9 South Suite 1000,Freehold,NJ,07728
WWW.stonegatetechnologies.com
The content of this email is confidential and intended for the recipient specified in message only. It is strictly forbidden to share any part of this message with any third party, without a written consent of the sender. If you received this message by mistake, please reply to this message and follow with its deletion, so that we can ensure such a mistake does not occur in the future.