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

Bassett Healthcare

$50K Sign-on- Bonus - PA or NP - Nocturnist Hospitalist - A.O. Fox Hospital Job at Bassett Healthcare

 ...Subspecialty services are available in Cardiology, General Surgery, Infectious disease, Pulmonary, Orthopedics and a burgeoning telemedicine service including Psychiatry, Palliative Care, and Neurology. Bassett is an EPIC EMR Network. Job Summary: Join an established... 

St. Mary Catholic Church

Organist and Music Director Job at St. Mary Catholic Church

ORGANIST/DIRECTOR OF MUSIC MINISTRY - ST. MARY OF THE IMMACULATE CONCEPTION CATHOLIC CHURCHSt. Mary Roman Catholic Church in Marshall, Michigan, is seeking an Organist and Director of Music. Our National Historic Landmark District community is committed to economic growth... 

Confidential

On-Site Staffing Coordinator Job at Confidential

 ...activity to produce quality results? Great news - Randstad is looking for an energetic recruiter to join our team! As an On-Site Staffing Coordinator you will act as a partner to our Inhouse Services clients, performing various aspects of the recruitment cycle including... 

Snelling Staffing DFW

Inventory Specialist Job at Snelling Staffing DFW

 ...Snelling is hiring for Inventory Specialists in the Mesquite area on 1st and 3rd shift. The Inventory Associate is responsible for maintaining accurate inventory records and supporting inventory control processes. This role ensures product accuracy, proper labeling,... 

NIVA Health

Mobile Wound Care Nurse (RN) Job at NIVA Health

 ...Exciting Opportunity: Mobile Wound Care Nurse (RN) Are you passionate about providing exceptional patient care and eager to advance your career in an innovative, supportive environment? NIVA Health is seeking dedicated and compassionate Registered Nurse to join our...