Senior ETL Developer (Snowflake) Job at Ohm Systems, Connecticut

a0dXcnp4bC9OR0Y3eUpZWHpQVjVwM3B2cHc9PQ==
  • Ohm Systems
  • Connecticut

Job Description

Role Overview
We are looking for a Senior ETL Developer to design, develop, and maintain data integration pipelines feeding into our Snowflake Data Warehouse. The ideal candidate will work with diverse data sources, build efficient and scalable ETL/ELT processes, and ensure reliable, high-quality data delivery to support analytics and reporting needs.

Key Responsibilities
Design, develop, and maintain ETL/ELT processes to load data into Snowflake.
Integrate data from multiple sources (databases, APIs, SaaS platforms, flat files, cloud services).
Write and optimize SQL queries, stored procedures, and transformations.
Work closely with the ETL Architect to implement best practices for data integration and performance.
Conduct data profiling, validation, and quality checks to ensure accuracy and completeness.
Monitor and troubleshoot ETL workflows, ensuring timely resolution of issues.
Collaborate with data architects, BI developers, and business stakeholders to deliver reliable datasets.
Participate in performance tuning, cost optimization, and workload management in Snowflake.
Contribute to process automation and continuous improvement initiatives.



Required Skills & Qualifications
7 10 years of experience in ETL/ELT development.
Strong hands-on experience with ETL tools (Informatica, Talend, Matillion, SSIS, AWS Glue, DBT, Fivetran).
Expertise in Snowflake including query tuning, warehouse optimization, and data loading techniques.
Strong proficiency in SQL and relational database concepts.
Experience with varied data sources such as Oracle, SQL Server, SAP, Salesforce, REST APIs, flat files.
Solid understanding of data warehousing concepts (star schema, snowflake schema, dimensional modeling).
Hands-on experience with at least one cloud platform (AWS/Azure/GCP).
Good communication and problem-solving skills.



Nice to Have
Experience with real-time/streaming pipelines (Kafka, Kinesis, Snowpipe).
Familiarity with data governance and cataloging tools.
Exposure to BI tools (Power BI, Tableau, Qlik).
Basic knowledge of scripting (Python, Shell) for automation.

Job Tags

Hourly pay,

Similar Jobs

Satori Mortgage (NMLS: 4190)

Mortgage Loan Officer Job at Satori Mortgage (NMLS: 4190)

 ...takes" to smash your goals, showing you know what's up in the mortgage game and have the grit to stick it out. This is one of the...  ...weekend doesn't work, gear up to visit 10, 25, or 50! Our Loan Officers grind beyond "banking hours" and pick up the phone after 5 pm... 

Securitas Security Services USA, Inc.

Security Officer Job at Securitas Security Services USA, Inc.

**Security Officer - Join Our Team!****Wage:** $15.00/hour**Your Role:**Do you want a role that's more than just a job? As a Security...  ...to a safe and positive living environment+ No prior experience? No problem! Retail, hospitality, or food service backgrounds... 

Rapsodo

Unity Developer Job at Rapsodo

Rapsodo is a sports technology company that designs computer vision and machine learning products to help athletes maximize their performance. With offices strategically located in Singapore, Turkey, the USA, Japan, and the UK. Rapsodo is the undisputed leader in sports...

Esferasoft Solutions Pvt. Ltd.

Android Developer Job at Esferasoft Solutions Pvt. Ltd.

# Design and build advanced applications for the Android platform using Kotlin or Java . # Collaborate with cross-functional teams...  ...# Work on bug fixing and performance optimization to improve app stability. # Ensure app compatibility across different Android... 

GreatAuPair LLC

Senior Caregiver Job at GreatAuPair LLC

Looking for someone to help take care of my elderly father who has dementia. We are looking for a live in caregiver. My mother still lives in the home and needs help taking care of my father who has a hard time standing and taking general care of himself.