Senior ETL Developer (Snowflake) @ Windsor CT Onsite Need Locals Job at Business Intelli, Connecticut

M3NxVUN3K2tjSnB0TDhkdk9lQVljblZnUmc9PQ==
  • Business Intelli
  • Connecticut

Job Description

Hi,

Position: Senior ETL Developer (Snowflake)

Location: Windsor CT Onsite
Experience: 7 10 years
Duration : Long Term

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

Local area,

Similar Jobs

ATC Midland

LPN Corrections Job at ATC Midland

The Corrections Licensed Practical Nurse ( LPN ) works inside a correctional facility. This position is responsible for providing care and care coordination for inmates who are incarcerated in a correctional facility.PAY RATE: Up to $46.00 / hourLocation: Marquette... 

Acara Solutions

Manufacturing Test Technician Job at Acara Solutions

 ...the cause of any malfunctions found at the top-level assembly, lower-level assemblies and / or circuit card assemblies of intricate audio transmitting / receiving equipment and makes all necessary corrections with the help from Test Engineering and / or Manufacturing Engineering... 

Hyatt Hotels

Housekeeper/Room Attendant (Camarera/o de Habitaciones) Job at Hyatt Hotels

 ...located in The Woodlands, TX. Your duties as a Room Attendant will include ensuring that assigned rooms are fully stocked, cleaned, and serviced to standard. You will also be responsible for: Greeting guests and responding to queries. Changing bed linen and... 

City Kia Of Orlando

AUTOMOTIVE 12 VOLT ELECTRONICS & ACCESSORIES INSTALLER Job at City Kia Of Orlando

 ...,key-less entry, amps, and sub-woofers. A plus to know current products and market trends. Any experience installing other auto accessories...  ...following but not limited including Alarms & Remote Starts, Audio, Lighting, car audio, vehicle security, mounting and balancing... 

GAP Solutions Inc

Senior Human Resource Specialist Job at GAP Solutions Inc

 ...ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. GAP Solutions provides reasonable accommodations to qualified individuals with disabilities. If you need an accommodation to apply for a...