Informatica IDMC Database Engineer

Informatica IDMC Data Engineer

Location: Onsite – Andover, MA
Type: Contract-to-Hire
Industry: Insurance / Enterprise IT
Compensation: Competitive hourly rate + full-time conversion with excellent benefits

About the Company
Join a 100+ year-old, highly stable insurance company known for its long-term vision, supportive culture, and rock-solid employee retention. This is a contract-to-hire role offering the opportunity to grow into a long-term position with excellent benefits and career security.

As part of the Data Engineering team, you’ll help modernize and scale their enterprise data platform using Informatica Intelligent Data Management Cloud (IDMC).

What You’ll Do

• Build and maintain data pipelines and integration workflows using Informatica IDMC

• Work closely with business analysts and data architects to transform business requirements into technical solutions

• Support the migration of legacy ETL processes to cloud-native Informatica IDMC services

• Ensure data quality, lineage, and governance standards are maintained across platforms

• Collaborate with cross-functional IT and business teams to support analytics and reporting needs

What We’re Looking For

• 3–6 years of data engineering or ETL development experience

• Hands-on expertise with Informatica IDMC / Cloud Data Integration

• Strong SQL skills and familiarity with relational databases (Oracle, SQL Server, or PostgreSQL)

• Understanding of data modeling, data quality, and metadata management

• Comfortable working onsite in Andover, MA 4–5 days a week

• Strong communication and documentation skills

Nice-to-Haves

• Experience with other Informatica modules (Data Quality, MDM, etc.)

• Familiarity with cloud platforms (AWS, Azure, or GCP)

• Previous experience in insurance or financial services environments

Why This Role?

• Join a stable, legacy company with a strong commitment to employee development

• Path to full-time hire with generous benefits, pension plan, and job security

• Be part of a data modernization journey with real business impact

• Work in a collaborative, well-established IT team

You will receive the following benefits:

• Medical Insurance - Four medical plans to choose from for you and your family
• Dental & Orthodontia Benefits
• Vision Benefits
• Health Savings Account (HSA)
• Health and Dependent Care Flexible Spending Accounts
• Voluntary Life Insurance, Long-Term & Short-Term Disability Insurance
• Hospital Indemnity Insurance
• 401(k) including match with pre and post-tax options
• Paid Sick Time Leave
• Legal and Identity Protection Plans
• Pre-tax Commuter Benefit
• 529 College Saver Plan

Motion Recruitment Partners (MRP) is an Equal Opportunity Employer. All applicants must be currently authorized to work on a full-time basis in the country for which they are applying, and no sponsorship is currently available. Employment is subject to the successful completion of a pre-employment screening. Accommodation will be provided in all parts of the hiring process as required under MRP’s Employment Accommodation policy. Applicants need to make their needs known in advance.