Jobs for Humanity is partnering with MassMutual to build an inclusive and just employment ecosystem. Therefore, we prioritize individuals coming from the following communities: Refugee, Neurodivergent, Single Parent, Blind or Low Vision, Deaf or Hard of Hearing, Black, Hispanic, Asian, Military Veterans, the Elderly, the LGBTQ, and Justice Impacted individuals. This position is open to candidates who reside in and have the legal right to work in the country where the job is located.

Company Name: MassMutual

Job Ad: Master Data Engineer

About Us:

MassMutual is a company that values diversity and inclusion. We believe in providing equal opportunities for all individuals in the workforce. We welcome applications from people from all walks of life, including elderly individuals, refugees, people with visible and invisible disabilities, LGBTQIA+ community, veterans, and more. Our goal is to create a workplace that is inclusive and supportive for everyone.

Job Objectives:

• Design, build, and measure complex data processes using Informatica Power Center and MDM to manage data in various domains at MassMutual.
• Collaborate with project teams to implement data collection and processing pipelines that meet specific business needs.

Daily and Monthly Responsibilities:

• Create ELT/ETL tasks to integrate data from different sources into a reliable data repository.
• Develop Master Data Management (MDM) solutions for various domains within MassMutual.
• Support MDM solutions, including data ingestion, master record creation, data extraction, and API integration.
• Implement data modeling policies, procedures, and standards.
• Document technical information, system flows, and database design.
• Ensure data accuracy and quality through data profiling and analysis.
• Collaborate with different departments to understand emerging data patterns.
• Translate business needs into technical specifications.
• Participate in the development and implementation of MDM solutions and other information management initiatives at MassMutual.

Basic Qualifications:

• Bachelor’s degree in computer science or engineering.
• 5+ years of experience with Informatica Power Center.
• 5+ years of experience with data analytics, data modeling, and database design.
• 3+ years of coding and scripting (Python, Java, Scala) and design experience.
• 3+ years of experience with Informatica MDM platform in customer/party subject area.
• Experience with ELT methodologies and tools.
• Expertise in tuning and troubleshooting SQL.
• Strong data integrity, analytical, and multitasking skills.
• Experience with Oracle database.
• Experience with AWS.
• Knowledge of basic UNIX commands and shell scripts.
• Experience with 3rd party job schedulers like Maestro.
• Experience with RESTful APIs.
• Experience with near real-time mastering via SIF.
• Experience with data profiling tools.
• Willingness to provide Level 2 support for batch processing cycles outside business hours.
• Excellent communication, problem-solving, organizational, and analytical skills.
• Able to work independently.
• Authorized to work in the USA with or without sponsorship.

Preferred Qualifications:

• Master’s degree in computer science or engineering.
• Familiarity with agile project delivery process.
• Knowledge of SQL and its use in data access and analysis.
• Ability to manage diverse projects impacting multiple roles and processes.
• Able to troubleshoot problem areas and identify data gaps and issues.
• Ability to adapt to a fast-changing environment.
• Experience with Python programming.
• Experience with Kafka.
• Basic knowledge of database technologies (Vertica, Redshift, etc.).
• Experience designing and implementing automated ETL processes.

MassMutual is an Equal Employment Opportunity employer.

We value diversity and welcome individuals from all backgrounds to apply, including minorities, females, individuals with disabilities, veterans, and those from the LGBTQIA+ community. If you require an accommodation to complete the application process, please contact us and let us know how we can assist you.

How to Apply:

To apply for this position, please fill out the application form below. If you have any questions or require any assistance, please do not hesitate to reach out to our hiring team using the contact information provided. Thank you for considering MassMutual as your potential employer. We look forward to reviewing your application.