Overview
On Site
$50 - $60
Contract - W2
Contract - Independent
Contract - 12 Month(s)
Skills
ELT
PL/SQL
SQL
Snowflake
Extract
Transform
Load
Business Intelligence
Cloud Computing
Data Quality
Data Warehouse
Informatica
Job Details
Role: ETL Developer
Location: Windsor, CT (onsite from Day 1) (Need local only)
Type: 12+ Months Contract
Role Overview
- Design and implement ETL/ELT architecture with Snowflake as the enterprise data warehouse.
- Integrate data from diverse sources (RDBMS, APIs, SaaS apps, flat files, streaming platforms, cloud services) into Snowflake.
- Define data integration best practices, including reusability, scalability, and cost optimization.
- Lead and mentor ETL/ELT developers in building robust pipelines.
- Optimize Snowflake performance (virtual warehouses, clustering, query tuning).
- Establish data quality, governance, and lineage frameworks.
- Collaborate with data architects, BI developers, and business stakeholders for end-to-end data delivery.
- Evaluate and implement ETL/ELT tools and automation frameworks suited for multiple source systems.
- Troubleshoot integration issues and define long-term solutions.
- Keep up to date with Snowflake features and emerging data integration technologies.
Required Skills & Qualifications
- 13+ years in ETL/ELT development.
- Strong expertise in Snowflake (warehouses, streams, tasks, snowpipe, data sharing).
- Proficiency in multiple ETL/ELT tools: Informatica, Talend, Matillion, SSIS, AWS Glue, DBT, Fivetran.
- Strong SQL and performance optimization skills.
- Experience working with varied data sources: Oracle, SQL Server, SAP, Salesforce, REST APIs, flat files, cloud-native systems.
- Solid understanding of data modeling (star schema, snowflake schema, data vault) and data warehousing principles.
- Hands-on experience with cloud platforms (AWS/Azure/Google Cloud Platform) for data integration.
- Strong leadership and communication skills for onsite stakeholder management.
Regards,
Karthick Ramasamy
Client Relationship Manager / Talent Acquisition
Rohnium Inc
MBE, DBE & SBE Certified Company
Ph -
E-
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.