Data Warehouse Developer (Talend ETL) Job at Purple Drive, Boston, MA

T29VQXl4aEZXOVo2RE41MjkrRHB5dTkwZ0E9PQ==
  • Purple Drive
  • Boston, MA

Job Description

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

 

Job Tags

Similar Jobs

SSM Health

Breast Imaging Physician - Flexible Schedule at SSM Health Saint Louis University Hospital Job at SSM Health

 ...SSM Health SLUCare Physician Group and Saint Louis University are currently seeking a breast imaging radiologist to join our breast...  ...provide exceptional medical services to patients at SSM Health Cardinal Glennon Childrens Hospital, SSM Health St. Marys Hospital, and,... 

KBR

LCV NORTHCOM: GS Site Manager (Contingency) Job at KBR

 ...management of government-sponsored programs, with a background in construction or facility maintenance. An additional 5 years of related...  ...expression, age, national origin, veteran status, genetic information, union status and/or beliefs, or any other characteristic protected... 

Flotilla Partners

Retail Lead Generator Costco Job at Flotilla Partners

 ...communication skills? Do you thrive in a social environment? EcoWater Systems is seeking Lead Generators/Appointment Setters to work inside Costco stores, engaging shoppers and setting appointments for water treatment services. We offer both full-time and Part-time positions!... 

Dialysis Clinic, Inc.

Dialysis Social Worker-LMSW Job at Dialysis Clinic, Inc.

 ...in our comfortable clinical setting with a lower caregiver-to-patient ratio than other providers. The Dialysis Social Worker (LMSW) is responsible for assessing and responding to the psychosocial needs of our dialysis patients to ensure the best possible outcomes... 

Aptyx

Manufacturing Operator 2nd shift Job at Aptyx

Position Summary Performs a variety of tasks involved in the manufacturing and assembly of medical devices in a regulated production environment. The Manufacturing Operator is trained on all assigned tasks and is responsible for following established written procedures ...