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 2 days ago
Similar jobs that could be interesting for youBased on the ETL Architect in Parsippany, NJ vacancy
- ...issues to ensure real-time synchronization. The role emphasizes performance tuning, disaster recovery testing, and integration with MQ/ETL platforms. Knowledge of Q Replication is preferred; located in NJ/Plano/US locations with potential travel. #J-18808-Ljbffr...Suggested
- ...differentiate 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...SuggestedFull timeWork experience placementLive inWork at officeLocal area
$116.2k - $229.1k
...clients, combining strategic thinking with deep industry knowledge to solve complex business problems in a team-based environment. We architect operating models and processes that enable growth, optimize capital, and maximize operational efficiency. We implement innovative...SuggestedVisa sponsorship- ...Architect Role: Architect Skill: ASP.NET MVC Location: Parsippany NJ (3 days onsite) prefer local candidates. Strong knowledge in C++, C#,.Net and Java, MQ, AMQ, Kafka, SQL, WebLogic, OpenShift, Web API's (SOAP and REST) & Web technologies. Should have strong exposure...SuggestedLocal area
Keylent Inc
Parsippany, NJ15 hours ago - ...Project Architect 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...SuggestedWork at officeRemote work
NK Architects
Morristown, NJ3 days ago $150k - $170k
Job Summary Position MDM Architecture Experience 10+ years (5+ Informatica MDM) Platform Focus Informatica MDM • GCP Location: Remote Role Description Own the enterprise MDM architecture and the move...Full timeRemote workTech Mahindra
Florham Park, NJ2 days ago- ...Salesforce Architect Design and architect end-to-end Salesforce solutions across Sales Cloud, Service Cloud, Experience Cloud, and other... ...and third-party applications using APIs, middleware, and ETL tools. Ensure adherence to Salesforce best practices, governance...
E-Solutions
Passaic, NJ2 days ago - ...Job Title AEM Architect Job Description About StatusNeo: StatusNeo is a global AI-native transformation firm helping enterprises design, engineer, and govern AI-led systems with trust at the core. We work with global enterprises across BFSI, retail, healthcare...
Statusneo
Parsippany, NJ1 day ago $160k - $170k
A Bachelor’s or Higher Degree is the minimum entry required for the position Own integration architecture across source systems (Epic, ELMS, Oracle ERP/HR/Finance, terminology), Informatica MDM, TopBraid, Collibra, GCP and downstream consumers. Key Responsibilities Define...Tech Mahindra
Florham Park, NJ3 days ago$100k - $200k
...compliant commercial content, and multi-channel CRM.As a Senior Architect in the Veeva Commercial Technology Architecture group, you will... ...following technical disciplines: Data Warehousing, Web Services, ETL, SQL, Force.com, FTP, and Batch CSV integrationsInterviewing with...Permanent employmentFull timeWork experience placementWork at officeLocal areaRemote workWork from home3 days per week$122k - $240.5k
Position Summary Google AI Architect/AI and EngineeringJoin our AI & Engineering team in transforming technology platforms, driving innovation, and helping make a significant impact on our clients' success. You’ll work alongside talented professionals reimagining...Local areaVisa sponsorshipFlexible hours- Company DescriptionSonsoft , Inc. is a USA based corporation duly organized under the laws of the Commonwealth of Georgia. Sonsoft Inc. is growing at a steady pace specializing in the fields of Software Development, Software Consultancy and Information Technology Enabled...Contract workH1bShift work
$150k - $190k
PositionPosition OverviewJoin our dynamic team as an Enterprise Architect (EA), where you'll be at the forefront of shaping our global omnichannel... ..., IBM Integration Bus, Fivetran, Informatica PowerCenter ETL, and IBM MQ). Experience with ERP implementations (e.g....- ...We are hiring an Infrastructure Architect to support the design, implementation, and operational readiness of a new data center build across primary and secondary sites.This role will work closely with senior architects, infrastructure engineering teams, facilities/colo...
2T Consulting
Morris Plains, NJ4 days ago $124.5k - $239k
When you join VerizonYou want more out of a career. A place to share your ideas freely — even if they’re daring or different. Where the true you can learn, grow, and thrive. At Verizon, we power and empower how people live, work and play by connecting them to what brings...Full timeTemporary workPart timeWork experience placementShift work$99k - $232k
...audit guidance), the Firm's code of conduct, and independence requirements.The OpportunityAs part of the Data Management team you architect end-to-end MDM solutions, including integration patterns and workflows. As a Manager, you lead teams and manage client accounts, facilitating...Full timeH1b- ...at The Lighthouse. KPMG is currently seeking a Manager, Boomi Architect in for our Consulting practice. Responsibilities: Client... ...and recommend appropriate integration tools (iPaaS, ESB, ETL, API Gateways) based on specific use cases and scalability requirements...H1bLocal area
$141.2k - $278.3k
Position Summary Google AI Lead Architect/AI & Engineering:Join our AI & Engineering team in transforming technology platforms, driving innovation, and helping make a significant impact on our clients' success. You’ll work alongside talented professionals reimagining...Local areaVisa sponsorshipFlexible hours$124k - $280k
...audit guidance), the Firm's code of conduct, and independence requirements.The OpportunityAs part of the Data Management team, you architect and manage master data management solutions to enhance business processes. As a Senior Manager, you lead large projects and...Full timeH1b$144.2k - $265.6k
Position Summary ServiceNow Platform Architect - Manager Our Deloitte Cyber team understands the unique challenges and opportunities businesses face in cybersecurity. Join our team to deliver powerful solutions to help our clients navigate the ever-changing threat...Local areaImmediate startVisa sponsorship- SharePoint Developer Strong understanding of SharePoint Application Architecture, Green Field Installation, Migrations and Upgrades and Integrations Experience in Installation and configuration of SP 2013 and SP 2016 and Ability to diagnose complex SharePoint setup...
ClifyX
Parsippany, NJ2 days ago $65 per hour
...AWS Architect Location: Hybrid - Parsippany, New Jersey Job Type: C2C Hourly Rate: $65 Visa Type: H1b, GC or USC Required Skills: ~10+ years designing scalable, secure, and highly available AWS architectures. ~ Expert in core AWS services including...Hourly payH1bArgyle Infotech
Parsippany, NJ2 days ago$68k - $88.5k
...Landscape Architect Location: Parsippany, NJ, US, 07054-2172 Princeton, NJ, US, 08540 Langan provides expert land development engineering and environmental consulting services for major developers, renewable energy producers, energy companies, corporations, healthcare...Hourly payFull timeTemporary workWork experience placementInternshipWork at officeLocal areaWorldwideFlexible hoursLangan
Parsippany, NJ1 day ago- ...Landscape Architect We are currently seeking an experienced Landscape Architect looking to bring their creative talents and technical expertise to our seasoned team. For 20 years Edward Clark Landscape Design has had the privilege of designing the exterior elements...Work at office
Wicklow & Laurano
Morristown, NJ15 hours ago $141.2k - $278.3k
Position Summary Integrated Manufacturing Ops Architect Manager Position Summary We are a team of strategic advisors, architects, and implementers who drive business transformations. Our diverse talent energizes clients' business functions and technology to maximize...Local areaVisa sponsorship- ...Position: AEM Architect Location: Parsippany NJ(Hybrid Open for Remote) Employment Type: Contract Job Description-: We are looking for an experienced AEM Architect to design and lead enterprise-scale Adobe Experience Manager (AEM) solutions. The role focuses...Contract workRemote work
Apetan Consulting llc
Parsippany, NJ1 day ago - ...Zelis Healthcare Inc. is seeking a Principal Solutions Architect to set the technical direction for the Price Optimization platform. You will lead solution and platform architecture across the business unit, aligning capabilities, shared services, and data to deliver...
- Zelis, a leader in healthcare financial solutions, seeks a senior technical leader to set the direction for the Price Optimization platform. You will partner with Product, Engineering, Design, Data, Security, and Enterprise Architecture to craft end‑to‑end solutions that...
- ...Services.Job DescriptionExtensive 8.6 or Higher Version- Informatica PowerCenter Technical ExperienceExperience in Informatica Complex ETL jobs DevelopmentExperience in Informatica Complex Transformations, Partitioning, PushDown OptimizationExperience in Informatica Tasks...
- ...DescriptionJob Description: Principal, Business Consulting -Solution Architect The vision of the Data &Analytics team is to help our clients... ..., Snowflake, Databricks. ., Managed Lakehouse Solutions, ETL/ELT Pipelines, Orchestration…Data Modeling & Governance: Schema...Full timeTemporary workWork experience placementLocal area
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to ETL Architect. Be the first to apply!
