ETL Architect

Kasmo Global

Job Title: ETL Architect
Location: Windsor, CT
Type : Contract
Role Overview
We are seeking a seasoned ETL Architect to design and lead scalable data integration solutions for our enterprise Snowflake Data Warehouse . This role requires expertise in Snowflake along with hands-on experience in working with diverse data sources and ETL/ELT technologies. The architect will ensure efficient data movement, transformation, and governance across heterogeneous systems to support analytics and business intelligence initiatives.
Key Responsibilities
• 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
• 10+ years in ETL/ELT architecture and 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.

Apply

Vacancy posted 5 days ago

Similar jobs that could be interesting for youBased on the ETL Architect in Parsippany, NJ vacancy

Sr. ETL Architect with Pyspark@ Whippany, NJ
Hybrid - 3 days onsite every week Skills - ETL, Ab Initio and Py Spark Client is migrating from Ab Initio to PySpark and needs an architect who could look at the Ab Initio architecture and come up with recommended design in PySpark location.
Suggested
3 days per week
PALNAR
Whippany, NJ
7 days ago
Senior DW/BI ETL Architect — Informatica & Teradata
A US-based technology firm is seeking an experienced professional for a full-time, permanent role focused on Software Development and Data Warehousing. Candidates should possess strong knowledge in Dimensional Modelling and Informatica, with at least 11 years of relevant...
Suggested
Permanent employment
Full time
Sonsoft Inc
Whippany, NJ
2 days ago
Lead ETL Architect — Informatica PowerCenter
A leading technology firm in Morristown, NJ is seeking an experienced Lead ETL Developer to enhance and support data warehouse solutions. You will develop ETL processes using Informatica PowerCenter and lead a team of developers both onshore and offshore. Ideal candidates...
Suggested
TechDigital Group
Convent Station, NJ
1 day ago
Senior Snowflake Architect (Platform & Administration)
$139k - $186k
.... Position Overview We are seeking a Senior Snowflake Architect to design, build, and operate our Snowflake data platform. This... ...Dimensional and analytical data models Batch and near real-time ELT/ETL pipelines Data integration and Snowflake Data Sharing...
Suggested
Full time
Work at office
Local area
Remote work
Visa sponsorship
Flexible hours
Zelis Healthcare
Morristown, NJ
4 days ago
Graph (Neo4j) and ETL Developer
...Job Title: Graph (Neo4j) and ETL Developer Job ID: 2023-12156 Job Location: Austin, TX; Morris Plains, NJ Job Travel Location(s): 0% # Positions: 1 Employment Type: W2 Candidate Constraints: Duration: Long Term # of Layers: 0 Work Eligibility: All Work Authorizations are...
Suggested
Highbrow
Morris Plains, NJ
2 days ago
ETL Developer
...NAVA Software solutions is looking for an ETL Developer Details: ETL Developer Location: Whippany, NJ (Remote to start) Duration: 6-12 months What You Will Do: Participate and contribute in the full project life cycle, including...
Remote work
Nava Software Solutions
Whippany, NJ
5 days ago
Accenture Life Insurance and Annuity Industry (ALIP) Integration Architect Lead
$132.5k - $338.3k
...and scale business growth. You Are: The Integration Lead Architect playing a pivotal role in ensuring that diverse software... ...implementing REST APIs, asynchronous/event-based integrations, ETL/data transformation pipelines, and enterprise integration solutions...
Work experience placement
Live in
Work at office
Local area
Accenture
Morristown, NJ
3 days ago
ETL Informatica Developer
...Position: ETL Informatica Developer Location: Florham Park, NJ (Locals/Onsite) NY/NJ/ CT Duration: 9 Months Contract... ..., and analytics solutions. You'll work closely with data architects, product teams, and stakeholders to ensure clean, consistent, and...
Contract work
Local area
Equiliem
Florham Park, NJ
4 days ago
Informatica ETL Developer
...ROLE TITLE ETL Developer ROLE LOCATION(S) Florham Park, NY; Purchase, NY; Conshohocken, PA TEAM... ...from specs (source to target mappings) Work closely with data architects, reporting team and application team on ETL development efforts...
Full time
Work at office
Local area
Remote work
Relocation
Monday to Friday
Futran Tech Solutions Pvt. Ltd.
Florham Park, NJ
3 days ago
Technology / Innovation Architect
...businesses-and their customers-to achieve more through innovation, automation, and intelligent insights. The Role As a Software Architect, you will have an impeccable record of working with engineering teams to deliver successful products in a fast-paced environment....
For contractors
Local area
Presidio
Morristown, NJ
7 days ago
ETL/Informatica Developer /Admin
...hybrid schedule. Role Details: Role: Senior ETL Developer - SR-373504 Location: Onshore, In-Office Required:... ...unit test programs from specs (source to target mappings) Architect, design, and document ETL/Informatica solutions for projects estimate...
For contractors
Work at office
Local area
Immediate start
Remote work
Relocation
Monday to Friday
Futran Tech Solutions Pvt. Ltd.
Florham Park, NJ
5 days ago
Architecture / architect
...AEM Architect Location: Parsippany, NJ– Onsite Job Description: Total Experience: 14–20 years overall AEM Experience: 7–10 years with AEM 6.x and/or AEM as a Cloud Service (AEMaaCS) AEM Solution Architecture, AEM 6.x / AEMaaCS, CDN (Akamai/CloudFront/Cloudflare...
United IT
Parsippany, NJ
5 days ago
Architect monitoring
...Mobile Architect Location: Parsippany, NJ We are seeking a highly skilled Full Stack Engineer with proven experience in developing and maintaining Android applications (Kotlin, Jetpack Compose) / iOS applications (Swift, SwiftUI), and RESTful APIs built with Java...
Yantran LLC
Parsippany, NJ
3 days ago
Database Engineer- Qlik Replicate/ETL
...Connect) solution. Manage Mainframe replication support with Qlik. Solid understanding for batch and real-time replication. Lite ETL for replication Support Monitor and tune performance of databases, replication tasks, and reporting services. Develop and...
Work experience placement
Remote work
1 day per week
Cedent Life Talent
Morristown, NJ
2 days ago
Senior Database Engineer - ETL, SQL & BI Focus
...has 4-5 years of experience, a Bachelor's degree in Computer Science, and expertise in SQL and relational databases. Familiarity with ETL tools and BI platforms is beneficial. A competitive salary and opportunities for professional growth are offered. #J-18808-Ljbffr...
3M Consultancy
Parsippany, NJ
2 days ago
Fully Remote Project Architect
...About NK Architects: Founded in 1972, NK Architects is a regional firm with offices in New Jersey, New York City and Pennsylvania, with a staff of approximately 70 employees working with clients throughout the country. We value diversity, equity and inclusion and strive...
Work at office
Remote work
NK Architects
Morristown, NJ
6 days ago
Solution Architect
...Solution Architect 1 Minimum 5 years of professional experience working as Solution Architect with 15 IT industry experience 2 Strong... ...financial institutions Good to Have 1 Experience in Peoplesoft ETL 2 Bachelors degree Computer Science Engineering or related...
Futran Tech Solutions Pvt. Ltd.
Morristown, NJ
5 days ago
Salesforce Solution Architect / Functional Lead
...Role Overview: The Onshore Solution Architect / Functional Lead will serve as the strategic and hands-on bridge between business objectives... ...: Salesforce Data Loader, Workbench, Salesforce Inspector, ETL tools, Snowflake, Data Fabrics. Process Mapping: Lucidchart...
Immediate start
Shift work
Night shift
Day shift
VDart
Florham Park, NJ
6 hours ago
Senior architecture architect
...Senior Product Architect Engineering and Product | Architecture Available in multiple locations including: Atlanta, Georgia, United States Austin, Texas, United States Baltimore, Maryland, United States Birmingham, Alabama, United States Boston,...
Deloitte Digital
Morristown, NJ
4 days ago
IT Architect/Developer
$87.5 per hour
...maintaining competitive advantages when executed as part of an overall sourcing strategy. NTT DATA Services currently seeks an OKTA Architect to join our team in Texas. The position is remote but must be in Texas. We are looking for a Sr‑Level Okta IAM Developer &...
Hourly pay
Temporary work
Remote work
Flexible hours
NTT DATA North America
Parsippany, NJ
13 days ago
Architect - health
$200k - $250k
A renowned health and nutrition company is looking for a Global Talent Director in Parsippany, New Jersey. This role will be pivotal in developing a robust global talent ecosystem and implementing innovative talent management strategies. The ideal candidate has over 12 ...
Reckitt Benckiser LLC
Parsippany, NJ
4 days ago
Camunda SME AVP: Workflow & Onboarding Architect
慨正橡扯 is seeking a Camunda SME - AVP to join the Wholesale Onboarding group in Whippany, New Jersey. In this role, you will design and develop solutions that enhance client onboarding processes while ensuring compliance with regulatory requirements. The ideal candidate will...
慨正橡扯
Morristown, NJ
4 days ago
Technical Data Architect
...Technical Data Architect Our client, a IT Services and Consulting company, is looking for a Technical Data Architect for their Parsippany... ...(Azure/AWS/GCP) and data engineering patterns (lakehouse, ELT/ETL orchestration, metadata management). ~ Exposure to syndicated...
Contract work
ICONMA
Parsippany, NJ
7 days ago
Senior Okta IAM Architect Remote (TX)
A leading IT services company is seeking an experienced OKTA Architect to design and implement Identity and Access Management solutions. This remote position requires 5-7 years of experience in Okta solutions and strong development skills in Java, Python, or .NET. The ideal...
Hourly pay
Remote work
NTT DATA North America
Parsippany, NJ
3 days ago
ARCHITECT - Facilities Planning
$82k - $105k
...strive to make the everyday places people occupy more inspiring, more resilient, and more impactful. Your Role As a Gensler Architect, it's your job to work within a team of architects and designers to deliver unparalleled architectural projects. Leverage your...
For contractors
Local area
Gensler
Morristown, NJ
3 days ago
SAP S/4HANA SCM Architect for MRP & Inventory
...AdvanSix is seeking a seasoned SAP Supply Chain Solution Architect to join the Enterprise Platforms team. The role involves acting as the product owner for Supply Chain planning and execution processes, overseeing SAP S/4HANA solutions. Ideal candidates will have over...
AdvanSix
Lake Hiawatha, NJ
2 days ago
Architect - React Native - NJ
...React Native Architect As a React Native Architect, you will be responsible for designing and implementing high-quality, scalable, and maintainable mobile applications using React Native framework. You will collaborate with cross-functional teams including developers...
Photon
Parsippany, NJ
2 days ago
AWS Architect - Cloud, FinOps
...Duration: 6 Months (Contract) Job Summary: We are seeking an experienced Data Architect for a 6-month contract engagement to lead the architecture, design, and initial build-out of a data visualization and analytics environment. This is a senior-level, hands-on...
Contract work
Local area
Remote work
Softcom Systems
Florham Park, NJ
2 days ago
MDS & Care Plan Architect
Cheshire Home in Florham Park, NJ is seeking a skilled Registered Nurse (R.N.) responsible for the completion of care plans, assessments, and compliance with state and federal guidelines. You will oversee Minimum Data Set/Care Plans and serve as the primary contact for...
Cheshire Home
Florham Park, NJ
3 days ago
IT Industrial COE Architect
$122.85k - $163.81k
...We are looking for an IT CoE Industrial Architect to join our Industrial Center of Excellence, supporting manufacturing operations across our plants in America. The role is focused on the support, design, evolution, and governance of industrial IT solutions mainly related...
Ferrero International S.A.
Parsippany, NJ
2 days ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to ETL Architect. Be the first to apply!