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.
Assi st other development teams , including application development, by supporting code reviews and/or development efforts
The Minimum Qualifications
The Ideal Qualifications
What to Expect as Part of MassMutual and the Team
#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....disciplinary team of architects, designers, engineers, managers, and environmental scientists work every day to make our world more functional,... ...sector. Bachelors Degree in Geology, Environmental Science, Engineering, or closely related field. Minimum of ten (10...
...individual to join the OD Family as a Local P&D or City Driver. In this role, you'll... ...available for new graduates of an approved trucking school. If you enjoy working in a... ...be able to enter and exit the vehicle's cab many times a day. Cab floor level is generally 36 to 66...
Sanitation EngineerThe Engine team is responsible to ensure that all of the ships main systems are working and maintained at all times. Although the Engine team is primarily responsible to keep the ship's power plant and propulsion systems running at all times, their...
Job Description Job Description Accounts Payable Clerk - Part Time Qualified candidates must be lawfully authorized to work in the U.S. Mutualink believes an unpredictable world does not have to be unprepared. Our company is committed to elevating our ability...
...Chesapeake Protective Services is currently accepting applications for Unarmed Guards in the Upper Marlboro area. All candidates must have: Active Maryland Guard Card. Smart Phone with Good Data Plan for our Work App. Maryland Driver's License for more than...