ETL IDMC Developer

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)  or other similar data warehousing tools
• 2 + years of experience using IDMC  or similar data management platforms
• 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, Maestro (Dynamic Workload console), or others
• Due to the nature of this position, as part of our background check process, candidates must be able to pass a non-registered fingerprint background check to qualify as fingerprinted person under FINRA

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

Salary Range:

At MassMutual, we focus on ensuring fair equitable pay, by providing competitive salaries, along with incentive and bonus opportunities for all employees. Your total compensation package includes either a bonus target or in a sales-focused role a Variable Incentive Compensation component.

Why Join Us.

We’ve been around since 1851. During our history, we’ve learned a few things about making sure our customers are our top priority. In order to meet and exceed their expectations, we must have the best people providing the best thinking, products and services. To accomplish this, we celebrate an inclusive, vibrant and diverse culture that encourages growth, openness and opportunities for everyone. A career with MassMutual means you will be part of a strong, stable and ethical business with industry leading pay and benefits. And your voice will always be heard.

We help people secure their future and protect the ones they love. As a company owned by our policyowners, we are defined by mutuality and our vision to put customers first. 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. At MassMutual, we Live Mutual.

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.

At MassMutual, we focus on ensuring fair, equitable pay by providing competitive salaries, along with incentive and bonus opportunities for all employees.  Your total compensation package includes either a bonus target or in a sales-focused role a Variable Incentive Compensation component.  For more information about our extensive benefits offerings please check out our Total Rewards at a Glance.