Objectives of the role

As an MDM Data Engineer, you will work in a fast-paced, innovative, and collaborative environment on exciting data management directives. You will design, build, and measure complex Informatica Power Center and MDM processes to master data for different Master Data domains in MassMutual. This role involves working on a range of projects including batch pipelines, data modeling, and Master Data solutions to implement robust data collection and processing pipelines to meet specific business needs.

The Team

The Data Platform Data Engineering team comprises a diverse group of data engineers, analysts, and data architects who are passionate about data integrity and innovation. The team is motivated by the opportunity to drive business decisions through accurate and reliable data. We foster a collaborative culture where knowledge-sharing and continuous learning are encouraged. Our MDM team is dedicated to mastering data management processes that are essential for MassMutual's data-driven strategies.

• Design, construct, and evaluate intricate ELT/ETL tasks: Assimilate data from diverse sources into a high-quality, reliable data repository, directly impacting the accuracy of MassMutual's data-driven decisions.
• Develop Master Data Management (MDM) solutions: Implement solutions across various master data domains within MassMutual, ensuring data consistency and reliability.
• Provide comprehensive support for MDM solutions: Manage data ingestion, master record creation, outbound data extracts, and API integration to maintain seamless data operations.
• Implement data modeling policies and procedures: Establish standards for data modeling, contributing to the efficiency and consistency of data processes.
• Collaborate across departments: Engage with various teams to understand emerging data patterns, translating high-level business needs into precise technical specifications.
• Actively engage in the development and rollout of MDM Solutions and other Information Management initiatives at MassMutual.
• Establish data quality benchmarks and develop tools/processes to ensure data accuracy.

• 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 (Python, Java, Scala) and design experience.
• 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.

• 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.
• Experience with RESTful APIs and near real-time mastering via SIF.
• Willingness to provide Level 2 support for batch processing cycles outside business hours.

• Regular collaboration with the Data Management Team.
• Focused one-on-one time with your manager.
• Access to mentorship opportunities.
• Networking opportunities, including access to Asian, Hispanic/Latinx, African American, women, LGBTQ, veteran, and disability-focused Business Resource Groups.
• Access to learning content on Degreed and other informational platforms.
• Your ethics and integrity will be valued by a company with a strong and stable ethical business, with industry-leading pay and benefits.