Snowflake Developer (Long Term Contract)

Acetech Group Corporation • United State
Visa Sponsorship
Apply
AI Summary

Design, build, and maintain data pipelines for Snowflake using Kafka, MS Azure, and Databricks. Collaborate with data architect to ensure efficient reporting. Create comprehensive documentation of data pipelines and ETL processes.

Key Highlights
Implement data synchronization between on-premises Oracle databases and Snowflake using Kafka and CDC tools
Develop and optimize the data model for Snowflake to support analytics and reporting requirements
Design, build, and manage data pipelines for ETL process using Airflow and Python
Collaborate with data architect to ensure efficient and insightful reporting
Create and maintain comprehensive documentation of data pipelines, ETL processes, and data models
Technical Skills Required
Snowflake Kafka MS Azure Databricks Airflow Python Oracle CDC
Benefits & Perks

Job Description


Role: Snowflake Developer

Location: Chicago, IL (Onsite)

Duration: Long Term Contract


Top Skills:

1. Snowflake Development

2. Kafka

3. MS Azure

4. Databricks


Key Responsibilities:

Data Integration:

Implement and maintain data synchronization between on-premises Oracle databases and Snowflake using Kafka and CDC tools.

Support Data Modeling:

Assist in developing and optimizing the data model for Snowflake, ensuring it supports our analytics and reporting requirements.

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.

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.


Subscribe our newsletter

New Things Will Always Update Regularly