Sign upLog in

Data Integration Engineer

LABUR LLC

Andover, MA

Apply
JOB DETAILS
SALARY
$95–$100 Per Hour
SKILLS
Amazon Web Services (AWS), Application Programming Interface (API), Best Practices, Change Control, Change Management, Cloud Computing, Code Reviews, Computer Science, Continuous Deployment/Delivery, Continuous Integration, Data Description Language (DDL), Data Management, Data Warehousing, Database Extract Transform and Load (ETL), Design Patterns Programming Methodologies, DevOps, Documentation, Git, Informatica, Java Message Service (JMS), PostgreSQL, Problem Solving Skills, Production Control, Production Support, Property and Casualty Insurance, REST (Representational State Transfer), Refactoring, Regulatory Compliance, Risk, Root Cause Analysis, SQL (Structured Query Language), Sarbanes-Oxley Act (SOX), Service-Oriented Architecture (fka Distributed Object Architecture), Stored Procedures, System Integration (SI), Systems Engineering, Technical/Engineering Design
LOCATION
Andover, MA
POSTED
25 days ago

We respectfully request that 3rd parties refrain from contacting us regarding this posting.

Overview

LABUR is partnering with a client to identify a Data Integration Engineer who will design, develop, and maintain modern data pipelines on the Informatica Data Management Cloud platform. This role enables data ingestion, transformation, and integration in support of a cloud-first data architecture and enterprise data warehouse. The ideal person needs to bring hands-on IDMC expertise, strong SQL and AWS Redshift proficiency, and a DevOps mindset for managing change and deployment across environments.

Responsibilities

  • Build complex, reusable IDMC integration pipelines leveraging Mass Ingestion, Application Ingestion, Taskflows, and REST APIs
  • Develop high-quality ETL pipelines that source, transform, and deliver data into AWS Redshift and other targets
  • Optimize and refactor mappings and workflows for performance, scalability, and operational efficiency
  • Perform root cause analysis on failed jobs and implement long-term remediation to improve pipeline resiliency
  • Create and maintain source-to-target mappings, technical specifications, and integration documentation
  • Support deployment pipelines and participate in data lifecycle management and change control processes to ensure high-quality, low-risk promotions across environments
  • Participate in code reviews, technical design discussions, and the evolution of integration best practices and reusable design patterns
  • Provide production support including monitoring, issue resolution, job reruns, and incident tracking

Qualifications

  • Bachelor's degree in computer science, information systems, engineering, or a related field (or equivalent experience)
  • 5+ years of ETL development experience, including 2+ years with Informatica PowerCenter or IDMC
  • 2+ years of hands-on experience with AWS products, preferably Redshift, along with proficiency in PostgreSQL, DDL/DML, and stored procedures
  • 2+ years of experience with DevOps tools and practices (e.g., Git, CI/CD, automated deployments)
  • Expertise in IDMC Data Integration components including Mass Ingestion, Application Ingestion, Taskflows, and API-based integration
  • Experience with RESTful services, JMS messaging, or other integration patterns (SOA, EDA)
  • Background in property and casualty insurance or other regulated industries with compliance requirements (e.g., SOX, audit readiness) preferred

Compensation

$95-$100/hr - Dependent on fit and experience

About the Company

L

LABUR LLC