Data Warehouse Developer (Talend ETL)

Purple Drive

Princeton, NJ

Overview:

Role: Data Warehouse Developer (Talend ETL)

Location: Boston, MA / Princeton, MA

Experience: 8-10 Years

Job Summary

We are seeking an experienced Data Warehouse Developer with strong expertise in Talend ETL and data warehousing to design, build, and optimize scalable data solutions. The ideal candidate will have hands-on experience in data integration, transformation, and pipeline development , supporting enterprise analytics and reporting needs.

Key Responsibilities

Data Warehousing & ETL Development

Design, develop, and maintain data warehouse solutions to support business intelligence and analytics
Build and optimize ETL/ELT pipelines using Talend (Talend Open Studio)
Extract, transform, and load data from multiple heterogeneous sources

Data Integration & Processing

Integrate data from various systems including:
- Relational databases
- Flat files and external data sources
Ensure data consistency, quality, and integrity across systems
Develop reusable ETL components and frameworks

Performance Optimization

Optimize ETL jobs and data pipelines for performance and scalability
Tune queries and transformations for efficient data processing
Handle large volumes of structured and semi-structured data

Data Modeling & Design

Design and maintain data models (star/snowflake schemas)
Support data architecture aligned with business requirements
Collaborate with data architects and analysts on data design

Maintenance & Support

Monitor ETL jobs and troubleshoot failures
Perform root cause analysis and implement fixes
Support production deployments and ongoing enhancements

Collaboration & Documentation

Work with business stakeholders to understand data requirements
Collaborate with BI, analytics, and engineering teams
Maintain documentation for ETL processes, workflows, and data mappings

Required Skills

Strong hands-on experience with Talend ETL (Talend Open Studio)
Solid experience in data warehousing concepts and architecture
Proficiency in SQL and database technologies
Experience designing and developing ETL/ELT pipelines
Strong understanding of data modeling techniques
Experience handling large-scale data processing

Preferred Skills

Experience with cloud data platforms (AWS, Azure, or GCP)
Knowledge of data quality and data governance practices
Familiarity with BI tools (Tableau, Power BI, etc.)
Experience with performance tuning and optimization

Apply

Vacancy posted 5 days ago

Similar jobs that could be interesting for youBased on the Data Warehouse Developer (Talend ETL) in Princeton, NJ vacancy

Data Architect
...Role :: Data Architect Location :: New Jersey Key Roles &... ...Strong experience in designing , developing Data solutions both on premise and on... ...developing projects using traditional ETL tools like Informatica, Talend Nifi etc. Big Data tool stack using...
Suggested
Work experience placement
E-Solutions
Princeton, NJ
2 days ago
Junior Cloud & Data Architect Remote & ETL Focus
...implement enterprise cloud solutions. You will work closely with the Enterprise Architecture team on tasks like architecting data pipelines, developing ETL utilities, and ensuring data quality. Qualified candidates should have a Master's degree in Computer Applications or...
Suggested
Remote work
Flexible hours
Quantum Integrators Group
West Windsor, NJ
1 day ago
Data Modeller
...Data Modeller Sonsoft, Inc. is a USA based corporation duly organized under the laws... ...Knowledge of Industry Standard Reporting/ETL tools. • Having good PL SQL Skills • Have... ...documenting, publishing to Team. • Experience in developing, validating, publishing, maintaining...
Suggested
Permanent employment
Full time
H1b
SonSoft
Princeton, NJ
3 days ago
Data Solution Architect
...Job Title: Data Solution Architect Skills: sales and Data architecture Experience: 16-18+ Years Location: Princeton... ...skills to own and lead solutions for clients. ? Excellent ETL skills, Data Modeling Skills ? Excellent communication skills...
Suggested
Full time
E-Solutions
Princeton, NJ
4 days ago
Data Architect
...Role :: Data Architect Location :: Skillman, NJ Job... ...modeling, data pipelines, ETL/ELT, data governance, cloud... ...# Data Modeling: ~ Develop and maintain comprehensive data... ...solutions, managing data lakes and warehouses to ensure data integrity and...
Suggested
E-Solutions
Skillman, NJ
2 days ago
Data Modeler
...Role: Data Modeler Location: NJ Long Term Need to go into office at least 1 - 3 days per week Data Modeling - Erwin Azure: Data Factory, Storage (Blob or Data Lakes) a plus Insurance or Reinsurance a must MUST be a proactive...
Work at office
3 days per week
1 day per week
Maintec Technologies
Princeton, NJ
3 days ago
NJDHS-DFD ASAPM3 - Database Architect
...Database Modeler/Developer Location: Hamilton, NJ (Hybrid) Duration... ...appropriate database architecture, data storage, and indexing... ...database design, data warehousing, ETL development, and performance... ...designing and maintaining data warehouses, with large-scale repositories...
CapLeo Global
Trenton, NJ
3 days ago
Principal Data Architect: Data Movement, Enrichment, and Orchestration
$142k
...SUMMARY We are seeking a hands-on Principal Data Architect to serve as a leader in our... ...technologies (ie lakehouse, iceberg, ELT vs ETL, and open source trends and tradeoffs),... ...s evolving needs and strategic direction. Develop and maintain comprehensive architectural documentation...
Temporary work
For contractors
Work at office
Local area
Remote work
Highmark Health
Trenton, NJ
2 days ago
Data Mesh Architect-US
...Data Mesh Architect Location: Skillman NJ Duration: 6+ Months... ...· Strong knowledge in ETL methods and tools · Experience... ...Experience working with Data Warehouse technologies (e.g. Redshift, Snowflake... ...governance implementations Develop and recommend modern...
Zortech Solutions
Skillman, NJ
3 days ago
Data Modeler
...Data Modeler Data Modeler with strong Insurance domain expertise to design, develop, and maintain enterprise-level data models that support underwriting, policy administration... ...modeling for transactional systems, data warehouses, data lakes, and analytics platforms....
Omni Inclusive
Princeton, NJ
3 days ago
Data Governance Architect
...Job Title : Purview Data Governance Architect Location : Remote or Onsite in Minneapolis , Minnesota Duration : Long term... ...enhance data transparency and trust. Data Governance Strategy: Develop and implement comprehensive data governance frameworks aligned with...
Long term contract
Remote work
Kasmo Global
Plainsboro, NJ
2 days ago
Data Architect
$165k
...seeking a highly experienced Data Architect with deep healthcare... ...and maintain enterprise data warehouse (EDW) architecture environments... ...management and other stakeholders. Develop architectures that support the... ...building and supporting ETL/ELT pipelines for high-volume...
Remote work
MAXIMUS
Trenton, NJ
5 days ago
Database Architect
...Database Architect to design and develop efficient, scalable, and... ...experience in building new relational data models and ensuring rigorous... ...dimensional data modeling and ETL development Lead DB... ...designing and maintaining data warehouses and large-scale data repositories...
Full time
Work at office
Local area
Apollo ITS
Trenton, NJ
3 days ago
Senior Database Architect & Performance Lead
...A software services company in Princeton is seeking a skilled database developer. This role involves designing databases, coding access specifications, and optimizing performance using Oracle, Sybase, and SQL. The ideal candidate will have experience in database management...
Compunnel
Princeton, NJ
1 day ago
Senior Data Architect R
...nurturing their full potential consistently garners them the Great Place to Work certification year after year. Senior Data Architect Primary Skills ~ ETL Fundamentals SQL SQL (Basic Advanced) Python Data Warehousing Modern Data Platform Fundamentals Data Modelling...
Full time
Brillio
Princeton, NJ
10 days ago
Senior Data Architect - Oracle Health
$97.5k - $199.5k
...efficiency and adoption metrics to peer benchmarks, presenting actionable insights via dynamic visualizations, and enabling collaborative, data-driven improvement projects across the enterprise. Candidates must be US Citizens and be able to obtain a Federal Security...
Temporary work
Work experience placement
Flexible hours
Oracle Defunct
Trenton, NJ
5 days ago
Data Modeler
...Senior Data Modeler (SOM) Specialist Location: Trenton, NJ (Hybrid) Duration: 12+ Months... ...variances across source systems Develop best practices for standard naming conventions... ...Exposure to Snowflake's Cloud Data Warehouse Knowledge of modern data management trends...
Apollo ITS
Trenton, NJ
3 days ago
Data Analysis Architect
...Job Tile: Data Analysis Architect Location: Trenton, NJ Duration: 6 months **Hybrid onsite-three times per week** *... ...to identify gaps and opportunities in existing data systems Develop clear plans and roadmaps for improving data management and integration...
Full time
Contract work
Work at office
Local area
3 days per week
Apollo ITS
Trenton, NJ
5 days ago
Senior Data Modeler-Trenton, NJ
...Senior Data Modeler Duration: 6 Months Location: Trenton, NJ - 80% Remote This SDM... ...design, development & implementation of Data Warehouse database structures and Analytical... ...Warehouse and DataMart. Should be capable of developing structured and unstructured data model...
For contractors
Work experience placement
Work at office
Remote work
Georgia IT Inc
Trenton, NJ
1 day ago
APP DEV&TST - Data Architect
...Ontologist/Semantic Data Architect This role involves FAIRification of data and is part of the FAIR Data Services team. This role... ...data more Findable, Accessible, Interoperable, and Reusable. Develop semantic ontologies and taxonomies to graph and harmonize research...
Omni Inclusive
Lawrence, NJ
5 days ago
Data Architect W Ecommerce
...Data Architect The Data Architect excels at understanding and developing a strategy focused on business goals while capitalizing on technology insights to improve the value of analytical data, improve effectiveness of collected data and streamline the flow of and integration...
Temporary work
For contractors
Flexible hours
Cardinal Integrated
Monmouth Junction, NJ
8 days ago
Sr. Azure Data Architect
...Experience with Azure data factory, Azure SQLDB, Azure SQLDB Managed Instance, and Azure Synapse. Stay up-to-date with the latest Power BI and data platform technologies and trends. Proven experience in Power BI development, performance optimization, and...
PALNAR
Princeton, NJ
5 days ago
Climate Data-Driven Education Architect (NGSS)
Rutgers University in North Brunswick Township seeks a lead architect for developing sophisticated, data-driven instructional units focused on New Jersey's climate patterns. This full-time role involves integrating localized datasets into curricula for educational use...
Full time
Rutgers University
North Brunswick, NJ
22 hours ago
Data Architect - Aerospace, Defense & Mobility - Senior Manager- Consulting - Location OPEN
$144k - $329.1k
...go. Join EY and help to build a better working world. AI & Data - Data Architecture – Senior Manager – Power & Utilities Sector... ...and aerospace sector. You will have the opportunity to lead and develop your skill set to keep up with the ever-growing demands of the modern...
Summer holiday
Flexible hours
EY
Trenton, NJ
3 days ago
Sr Azure Data Engineer/Architect
...Responsibilities Assure that data is cleansed, mapped, transformed, and otherwise optimised... ...business and technical requirements Develop and maintain innovative Azure solutions... ...in destinations including data warehouse, high speed indexes, real-time reporting...
ATYETI
Princeton, NJ
3 days ago
Data Analyst/Data Modeler-Pennington, NJ
...Data Analyst/Data Modeler Location: 1700 American Blvd, Pennington, NJ 08534 Duration: 10 months Rate: DOE US Citizens and Green... ...5. Knowledge of NoSQL data stores such as MongoDB, Neo4J, Cassandra, Redis, etc. 6. Experience with Data Warehouse and Data Marts...
Staffing the Universe
Pennington, NJ
3 days ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Data Warehouse Developer (Talend ETL). Be the first to apply!