Mutual Opportunities
ETL Developer
Springfield, Massachusetts; Boston, Massachusetts; New York, New York
Thank you to our employees for voting us one of the top places to work in Massachusetts for five consecutive years!
Overview
A career with us means you’ll work alongside exceptional people and be empowered to reach your professional and personal goals. Our employees are at the foundation of what enables MassMutual to deliver on our purpose to help people secure their futures and protect the ones they love.
We embrace the idea that we all are stronger and better through our support for one another. We strive to create a culture where employees feel valued and are celebrated for who they are.
“Since our founding in 1851, mutuality has put our policyowners at the center of everything we do. At our core, we’re a company of people helping people in their time of need, and that spirit extends to the culture we’ve built at our company. Our employees support and rely on each other each day, collaborating to deliver the best solutions for our customers and help millions more secure their future and protect the ones they love.”
Job Description
ETL Developer – Mastery Level
Wealth Management Technology
Full-time, Hybrid, Springfield, MA
The Opportunity
We are seeking a Mastery-Level ETL Developer to lead the design, build, and optimization of scalable ELT/ETL pipelines that deliver business-critical data to the MassMutual Data Platform. This is a highly technical leadership role requiring hands-on experience with Informatica (IICS/IDMC), Python, advanced SQL, cloud data platforms, orchestration frameworks, and data governance. You will be a key contributor to MassMutual’s next-generation data engineering ecosystem, ensuring performance, reliability, security, and future scalability.
The Team
The Wealth Management Technology Team is global with team members located in 3 countries. We support a complex and very dynamic business for product delivery, financial planning services, lending services, and investment operations. The team’s mission statement is to “provide exceptional service and support to project workstreams and business stakeholders by meeting or exceeding expectations”; and a guiding principle is to “deliver the best quality solution as quickly as possible without compromising best practices or strategic goals”. Our culture is grounded in quality and managing customer expectations.
The Impact - Key Responsibilities & Accountabilities
Design and develop complex ELT/ETL pipelines using Informatica IICS/IDMC, Python, and SQL to extract, transform, and load data from relational databases, flat files, and APIs.
Translate high-level business requirements into detailed technical solutions and data workflows, Work very closely with both business and technical stakeholders.
Ingest and integrate data from disparate sources into centralized data lakes and data warehouses using cloud-native architecture.
Ensure data quality through robust cleansing, validation, and profiling techniques, including the implementation of custom and reusable validation rules.
Implement high-quality, cost-effective and sustainable solutions.
Implement best practices for performance tuning, error handling, failover recovery, job logging, and alerting mechanisms.
Perform Unit testing, system testing, and implementation support.
Guide and mentor junior team members in best practices for IICS/IDMC
Build reusable tools and components to accelerate pipeline development, streamline migration efforts, and improve maintainability.
Participate in all phases of project planning, execution and testing, producing artifacts per SDLC audit requirements.
Collaborate with data engineers, data analysts, data scientists, and platform engineers to enable seamless data flow and pipeline observability.
Document technical specifications, data lineage, and transformation logic for audit, compliance, and handover purposes.
Assist other development teams, including application development, by supporting code reviews and/or development efforts
The Minimum Qualifications
- Bachelor’s degree in computer engineering, computer science or related technical field
- 8 + years of software engineering/development
- 5 + years of ETL/ELT development experience with Informatica (PowerCenter writing Unix shell scripts, IDMC)
- 2 + years of experience using IDMC
- 5 + years of advanced SQL experience on multiple DBMS technologies, such as MS SQL Server, Teradata, and Vertica, including performance tuning, window functions, CTEs, and indexing strategies
- 5 + years of experience developing ETL/ELT logic using Python (pandas, pySpark, data validation, transformation scripting)
- 3 + years of experience working with AWS Cloud, including S3, Redshift, Glue, Lambda, Step Functions, etc.
- 5 + years of experience with workflow orchestration tools such as Apache Airflow, Control-M, or Maestro (Dynamic Workload console
The Ideal Qualifications
- Additional development experience in Java 17+, Spring Boot, Kafka, React.js, Docker, Kubernetes, GitHub, and Jenkins
- Experience with wealth management or financial services projects
- Strong knowledge of architecture principles, development standards, and best practices
- Advanced knowledge and experience with Data Governance and MDM technologies and methodologies
- Experience data modelling in support of an enterprise data warehouse and custom application databases
- Experience with data lake technologies such as Data Bricks
- Experience maintaining and supporting business critical custom build applications
- Experience maintaining and publishing standards and best practices with respect to DB architecture, design, naming, back-up, security, and usage
- Designs and develops packages, stored procedures, functions, views, queries and other related jobs to facilitate application access to data
- Knowledge and experience unit testing using test driven development
- Assist in troubleshooting, analyzing, and optimizing DB performance issues
- Can do attitude, with the ability to drive to success in both independent and group projects
- Demonstrated experience and ability to deliver results quickly in a fast-paced environment on multiple projects
- Ability to work with other IT groups and business users
- Excellent communication and presentation skills with the ability to translate technical solutions to non-technical stakeholders
- Strong problem-solving, analytical, and troubleshooting capabilities
- Proven leadership experience and the ability to mentor junior developers
- Highly organized, self-driven, and accountable with a focus on continuous improvement
What to Expect as Part of MassMutual and the Team
- Team meetings, as appropriate, to track and drive individual and team accountability
- Ad hoc collaboration sessions to define and adopt standards and best practices
- A weekly team training session focused on comprehension of the delivery model
- Conduct technical troubleshooting, maintenance, and operational support for production code
- Focused one-on-one meetings with your manager
- Access to learning content
- Code! Code! Code!.
#LI-RK1
MassMutual is an Equal Employment Opportunity employer Minority/Female/Sexual Orientation/Gender Identity/Individual with Disability/Protected Veteran. We welcome all persons to apply. Note: Veterans are welcome to apply, regardless of their discharge status.If you need an accommodation to complete the application process, please contact us and share the specifics of the assistance you need.
MassMutual will accept applications on an ongoing basis until such time as a candidate has been offered employment. The job description includes the main duties of this position, which may evolve over time. You may be required to perform other duties not listed.
It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment.
Salary Range: $144,800.00-$190,000.00
Hiring Process
Explore
Explore our open jobs by clicking 'search jobs' to find a position that aligns with your experience and skills. You may also consider joining our Talent Network.
Apply
Click the “apply” button on that job posting to complete and submit your application. Your application will be reviewed by a recruiter, which, due to the volume of applications received, may take some time as we carefully consider each application.
Screen
After your application has been reviewed, if you meet the qualifications for the role, a recruiter will reach out to you to start a conversation.
Interview
If you are invited for an interview, you will be scheduled to meet with the hiring manager and hiring team.
Offer
If you are extended an offer to join MassMutual and accept, your start will be contingent upon a satisfactory background check.
Hire
If you accept the offer, we will be so excited to welcome you to the MassMutual community!
If you need an accommodation to complete the application process, please contact us and share the specifics of the assistance you need.
By the numbers*
- 88% of employee respondents say they are proud to work at MassMutual
-
90
% of employee respondents say they feel encouraged to bring forth new ideas - 86% of employee respondents say MassMutual cares about and supports the well-being of their employees
*Source: 2024 MassMutual employee engagement survey
Award-Winning Culture
MassMutual is guided by a single purpose: We help people secure their future and protect the ones they love. As a company operated for the benefit of our members and participating policyowners, we are defined by mutuality and our vision to provide financial well-being for all Americans. It’s more than our company structure — it’s our way of life. We are a company of people protecting people. Our company exists because people are willing to share risk and resources and rely on each other when it counts.
We strive to build a thriving community where everyone is valued, included, and feels that they belong.
At MassMutual, we Live Mutual.
How We Work
MassMutual’s flexible workplace approach combines the importance of connecting in person and the flexibility of working remotely. Our hybrid model puts collaboration first with employees coming in at least three days per week to our spectacular campus settings and also enjoying the flexibility of remote Fridays, company-wide remote weeks, and a bank of flexible remote weeks to use throughout the year.
Benefits for the whole you (and your loved ones)
There’s more to your life than your job and there’s more to your aspirations than a paycheck. We take a holistic view of compensation and benefits that provides the flexibility to create a healthy balance in your life for work, family, and community. We offer the benefits you’d expect, like medical, dental, 401(k), and generous vacation time, but we also offer ones you might not expect, like three paid days for volunteering, a $1,250 annual Well-Being Wallet, and up to 320 hours of caregiver leave.
Explore some of our offerings below. Benefit details can be found here.
Why MassMutual?
Kevin
Compliance Consultant
Seth
Service Management Consultant
Kymberly
Head of Experience Journey Mapping
where we work
Springfield Office
1295 State Street, Springfield, MA
Boston Office
10 Fan Pier Blvd, Boston, MA
New York Office
2 Park Ave,
New York, NY
Virtual
New Job Openings
Sign up for job alerts
Don't see what you're looking for? Sign up for job alerts and we'll notify you when jobs become available.
Job recruiter fraud is a scam by impostors posing as recruiters or representatives of a company promoting fake job opportunities to job seekers.
MassMutual will never ask job candidates to pay any kind of fee, make cash or check advancements, cash checks or make an investment in any product or service or provide information such as credit card numbers or banking PIN numbers as part of our hiring process.
If you are contacted by anyone asking for information outlined above, it is likely fraudulent. If you have any concerns about the veracity of a request, please contact us to verify its legitimacy.
Share This Job