Data Engineer (Engineer Database )

MassMutual - Hartford, CT

Full-time - Mid Level

Hartford, CT

Insurance Carriers and Related Activities

About the position

As an MDM Data Engineer at MassMutual, you will be part of a dynamic team focused on data management initiatives. Your role will involve designing, building, and measuring complex Informatica Power Center and MDM processes to ensure the integrity of master data across various domains. You will work on projects that include batch pipelines, data modeling, and Master Data solutions, contributing to the development of robust data collection and processing pipelines that meet business needs. This position is crucial for driving data-driven decisions within the organization.

Responsibilities

• Design and build complex Informatica Power Center and MDM processes for master data management.
• Develop Master Data Management (MDM) solutions across various domains to ensure data consistency and reliability.
• Manage data ingestion, master record creation, outbound data extracts, and API integration.
• Implement data modeling policies and procedures to enhance efficiency and consistency in data processes.
• Engage with teams to understand emerging data patterns and translate business needs into technical specifications.
• Establish data quality benchmarks and develop tools/processes to ensure data accuracy.

Requirements

• Bachelor's degree in computer science or engineering.
• 5+ years of experience with Informatica Power Center.
• 5+ years of experience in data analytics, data modeling, and database design.
• 3+ years of coding and scripting experience in Python, Java, or Scala.
• 3+ years of experience with the Informatica MDM platform in the customer/party subject area.
• 3+ years of experience in ELT methodologies, SQL tuning, and troubleshooting.
• 3+ years of experience with Oracle database and AWS.
• 2+ years of experience with basic UNIX commands and shell scripts.

Nice-to-haves

• Master's degree in computer science or engineering.
• Familiarity with agile project delivery processes.
• Proficiency in SQL and data access/analysis.
• Experience with Python, Kafka, and database technologies like Vertica or Redshift.

Benefits

• Networking opportunities with various Business Resource Groups.
• Access to learning content on Degreed and other informational platforms.