MDM Data Engineer

MassMutual - Hartford, WI

Full-time - Mid Level

Hartford, WI

Insurance Carriers and Related Activities

About the position

As an MDM Data Engineer at MassMutual, you will play a crucial role in designing, building, and measuring complex data management processes using Informatica Power Center and MDM. This position involves working on various projects related to batch pipelines, data modeling, and Master Data solutions, aimed at implementing robust data collection and processing pipelines to meet specific business needs. You will collaborate with a diverse team to ensure data integrity and drive business decisions through accurate data management.

Responsibilities

• Design, construct, and evaluate intricate ELT/ETL tasks to assimilate data from diverse sources into a reliable data repository.
• Develop Master Data Management (MDM) solutions across various master data domains, ensuring data consistency and reliability.
• Provide comprehensive support for MDM solutions, managing data ingestion, master record creation, outbound data extracts, and API integration.
• Implement data modeling policies and procedures to establish standards for data modeling and improve data processes.
• Collaborate with various departments to understand emerging data patterns and translate business needs into technical specifications.
• Engage in the development and rollout of MDM Solutions and other Information Management initiatives.
• 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.
• 3+ years of experience with RESTful APIs and near real-time mastering via SIF.

Nice-to-haves

• Master's degree in computer science or engineering.
• Familiarity with agile project delivery processes.
• Proficiency in SQL and data access/analysis.
• Ability to manage diverse projects impacting multiple roles and processes.
• Experience with Python, Kafka, and database technologies like Vertica or Redshift.
• Experience designing and implementing automated ETL processes.
• Willingness to provide Level 2 support for batch processing cycles outside business hours.

Benefits

• Regular collaboration with the Data Management Team.
• Focused one-on-one time with your manager.
• Access to mentorship opportunities.
• Networking opportunities with various Business Resource Groups.
• Access to learning content on Degreed and other informational platforms.