Knights of Columbus

Data Movement Engineer – Talend

Knights of Columbus

contract

Posted on:

Location Type: Hybrid

Location: New Haven • Connecticut • United States

Visit company website

Explore more

✨ AI Apply
Apply

Tech Stack

ETLInformaticaSQL

About the role

  • Complete full life cycle of ETL/ELT development including design, mappings, transformations, scheduling, and testing.
  • Translate data movement requirements into technical ETL design.
  • Design, develop, and maintain robust ETL workflows using Talend, Informatica (IICS, PowerCenter), and BODI.
  • Develop data extraction and transmissions to external vendors.
  • Develop test plans and perform unit testing.
  • Determine impacts to data warehouse structures and information flows due to changes in business or technical requirements.
  • Perform design and code reviews in support of organizational standards.
  • Contribute to architectural decisions to support business processes.
  • Perform data quality analysis, report data quality issues and propose solutions for data quality management.
  • Communicate issue status, impact, and resolution timelines effectively.

Requirements

  • Minimum of 5 years of relevant experience in data warehousing, business intelligence tools, and data analysis
  • Minimum of 3 years of SQL query development across multiple database platforms (Snowflake, SQL Server, DB2)
  • Expert-level proficiency in Talend Management Console and Talend Open Studio
  • Strong understanding of BODI (Business Objects Data Integrator) code and architecture
  • Proficiency in ETL/ELT concepts and tools (Informatica IICS, Talend, Boomi, PowerCenter)
  • Working knowledge of data warehousing concepts, dimensional modeling, and ETL best practices
  • Bachelor’s degree in computer science, Information Systems, or related field
Benefits
  • Competitive salary
  • Health insurance
  • Retirement plans
  • Paid time off
  • Flexible work arrangements
  • Professional development opportunities
  • On-call support

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills
ETL developmentELT developmentSQL query developmentdata analysisdata quality analysisdimensional modelingdata extractiondata transformationdata warehousingtest plans
Soft skills
communicationproblem-solvingcollaborationorganizational skills