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.
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.
Vacancy posted 5 days ago
Similar jobs that could be interesting for youBased on the ETL Architect in Parsippany, NJ vacancy
- 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.Suggested3 days per week
PALNAR
Whippany, NJ7 days ago - 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...SuggestedPermanent employmentFull time
- 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
$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...SuggestedFull timeWork at officeLocal areaRemote workVisa sponsorshipFlexible hoursZelis Healthcare
Morristown, NJ4 days ago- ...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, NJ2 days ago - ...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, NJ5 days ago $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 placementLive inWork at officeLocal areaAccenture
Morristown, NJ3 days ago- ...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 timeWork at officeLocal areaRemote workRelocationMonday to Friday
Futran Tech Solutions Pvt. Ltd.
Florham Park, NJ3 days ago - ...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 workLocal area
Equiliem
Florham Park, NJ4 days ago - ...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 contractorsLocal area
Presidio
Morristown, NJ7 days ago - ...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, NJ2 days ago - ...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 placementRemote work1 day per week
Cedent Life Talent
Morristown, NJ7 days ago - ...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 contractorsWork at officeLocal areaImmediate startRemote workRelocationMonday to Friday
Futran Tech Solutions Pvt. Ltd.
Florham Park, NJ5 days ago - ...Role : 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...
United IT Solutions
Parsippany, NJ6 days ago - ...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, NJ3 days ago - ...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, NJ5 days ago - ...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 officeRemote work
NK Architects
Morristown, NJ6 days ago - ...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 startShift workNight shiftDay shift
VDart
Florham Park, NJ5 days ago - ...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, NJ4 days ago $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 payTemporary workRemote workFlexible hoursNTT DATA North America
Parsippany, NJ13 days ago- 慨正橡扯 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...
$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 ...- ...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, NJ7 days ago - 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, NJ3 days ago $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, NJ2 days ago- ...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, NJ5 days ago - 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 payRemote work
NTT DATA North America
Parsippany, NJ3 days ago $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 contractorsLocal areaGensler
Morristown, NJ3 days ago- ...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, NJ2 days ago - ...Job Title : AI AWS Architect Location : Parsippany, NJ (ONSITE) Full Time ONLY Job Description Must Have Technical/Functional Skills • 10+ years of experience in Software Development & ML engineering, including 4+ years in Solution architecture...Full time
AceStack LLC
Parsippany, NJ6 days ago
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to ETL Architect. Be the first to apply!
