Mass Mutual Life Insurance Company
ETL IDMC Developer
Mass Mutual Life Insurance Company - Boston, Massachusetts, us, 02298
Work at Mass Mutual Life Insurance Company
Overview
- View job
Overview
Join to apply for the
ETL IDMC Developer
role at
Mass Mutual Life Insurance Company
Get AI-powered advice on this job and more exclusive features.
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. Our mission is to “provide exceptional service and support to project workstreams and business stakeholders by meeting or exceeding expectations”, with a culture 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, working closely with 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 custom 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 support for implementation.
Guide and mentor junior team members in best practices for IICS/IDMC.
Build reusable tools and components to accelerate pipeline development and improve maintainability.
Participate in all project phases, producing artifacts per SDLC audit requirements.
Collaborate with data engineers, analysts, scientists, and platform engineers to enable seamless data flow.
Document technical specifications, data lineage, and transformation logic for audit and compliance.
Support other development teams through code reviews and development efforts.
The Minimum Qualifications
Bachelor’s degree in computer engineering, computer science, or related field
8+ years of software engineering/development experience
5+ years of ETL/ELT development experience with Informatica (PowerCenter, IDMC) or similar tools
2+ years of experience with IDMC or similar data management platforms
5+ years of advanced SQL experience across multiple DBMS technologies
5+ years of Python development experience (pandas, pySpark, data validation, transformation scripting)
3+ years of experience with AWS Cloud services (S3, Redshift, Glue, Lambda, Step Functions)
5+ years of experience with workflow orchestration tools such as Apache Airflow
Must be able to pass a non-registered fingerprint background check under FINRA requirements
The Ideal Qualifications
Experience with Java 17+, Spring Boot, Kafka, Docker, Kubernetes, GitHub, Jenkins
Experience in wealth management or financial services projects
Strong knowledge of architecture principles and development standards
Experience with Data Governance, MDM, and data modelling for enterprise data warehouses
Knowledge of data lake technologies like Data Bricks
Experience supporting business-critical custom applications
Proficiency in database architecture, design, security, and backup standards
Experience with unit testing and test-driven development
Strong troubleshooting, analytical, and leadership skills
Excellent communication and ability to mentor junior developers
Highly organized, self-driven, with a focus on continuous improvement
What to Expect as Part of MassMutual and the Team
Team meetings, collaboration sessions, and weekly training
Technical troubleshooting and operational support
One-on-one meetings with your manager
Access to learning content and development resources
A dynamic and collaborative work environment
MassMutual is an Equal Employment Opportunity employer. We welcome all persons to apply. Veterans are encouraged to apply regardless of discharge status.
If you need accommodations during the application process, please contact us with your needs.
Salary Range: $144,800.00-$190,000.00
Additional Information
Seniority level: Mid-Senior level
Employment type: Full-time
Job function: Business Development and Sales
Referrals increase your chances of interviewing at Mass Mutual Life Insurance Company. Get notified about new ETL Developer jobs in Boston, MA.
#J-18808-Ljbffr
ETL IDMC Developer
role at
Mass Mutual Life Insurance Company
Get AI-powered advice on this job and more exclusive features.
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. Our mission is to “provide exceptional service and support to project workstreams and business stakeholders by meeting or exceeding expectations”, with a culture 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, working closely with 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 custom 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 support for implementation.
Guide and mentor junior team members in best practices for IICS/IDMC.
Build reusable tools and components to accelerate pipeline development and improve maintainability.
Participate in all project phases, producing artifacts per SDLC audit requirements.
Collaborate with data engineers, analysts, scientists, and platform engineers to enable seamless data flow.
Document technical specifications, data lineage, and transformation logic for audit and compliance.
Support other development teams through code reviews and development efforts.
The Minimum Qualifications
Bachelor’s degree in computer engineering, computer science, or related field
8+ years of software engineering/development experience
5+ years of ETL/ELT development experience with Informatica (PowerCenter, IDMC) or similar tools
2+ years of experience with IDMC or similar data management platforms
5+ years of advanced SQL experience across multiple DBMS technologies
5+ years of Python development experience (pandas, pySpark, data validation, transformation scripting)
3+ years of experience with AWS Cloud services (S3, Redshift, Glue, Lambda, Step Functions)
5+ years of experience with workflow orchestration tools such as Apache Airflow
Must be able to pass a non-registered fingerprint background check under FINRA requirements
The Ideal Qualifications
Experience with Java 17+, Spring Boot, Kafka, Docker, Kubernetes, GitHub, Jenkins
Experience in wealth management or financial services projects
Strong knowledge of architecture principles and development standards
Experience with Data Governance, MDM, and data modelling for enterprise data warehouses
Knowledge of data lake technologies like Data Bricks
Experience supporting business-critical custom applications
Proficiency in database architecture, design, security, and backup standards
Experience with unit testing and test-driven development
Strong troubleshooting, analytical, and leadership skills
Excellent communication and ability to mentor junior developers
Highly organized, self-driven, with a focus on continuous improvement
What to Expect as Part of MassMutual and the Team
Team meetings, collaboration sessions, and weekly training
Technical troubleshooting and operational support
One-on-one meetings with your manager
Access to learning content and development resources
A dynamic and collaborative work environment
MassMutual is an Equal Employment Opportunity employer. We welcome all persons to apply. Veterans are encouraged to apply regardless of discharge status.
If you need accommodations during the application process, please contact us with your needs.
Salary Range: $144,800.00-$190,000.00
Additional Information
Seniority level: Mid-Senior level
Employment type: Full-time
Job function: Business Development and Sales
Referrals increase your chances of interviewing at Mass Mutual Life Insurance Company. Get notified about new ETL Developer jobs in Boston, MA.
#J-18808-Ljbffr