The Opportunity
As an ETL Developer you will work in a fast paced, innovative, and collaborative environment on exciting assignments that are focused on the adoption of leading-edge technologies, implementation patterns, and data management standards and controls.
The Team
The MMLIS Technology Delivery (MTD) Team, under MMFA Technology, supports very dynamic business needs for MMLIS (broker dealer) and the wealth management organization. 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”. The culture is grounded in quality and managing customer expectations.
The Impact:
Work assignments will span support for business as usual (BAU) for ongoing production delivery, defect resolution, and support; or “must do” audit or regulatory requests; or an allocation to a project(s).
The Minimum Qualifications
5+ years Informatica development experience in a team setting
2+ years using Informatica Cloud (IDMC/IICS)
Design, develop and maintain Informatica cloud data integration processes using the appropriate data load techniques
Analyze the impact of changes on existing ETL/ELT processes and systems, assess the compatibility with goals in all areas, and analyze cost effectiveness and feasibility
Debug and tune data integration processes; analyze data warehouse architecture, normalized/de-normalized, troubleshoot and recommend improvements and alternate methodologies
Design, develop and maintain database objects (tables, views, stored procedures, etc.) and SQL scripts.
Strong experience creating and maintaining UNIX/LINUX scripts
Participate in code reviews and ensure that all solutions are aligned to pre-defined architectural and requirement specifications
Provide L2 and L3 support of ETL/ELT processes to ensure timely completion and availability of data in data warehouse for reporting use. Analyze and resolve problems and provide technical assistance as necessary.
Prepare or review product documentation, written instructions or technical literature for accuracy and completeness
Implement Data Quality management standards and best practices
Maintain business rules associated with data integration
Participate in the fulfillment of ad-hoc data requests from internal business skateholders
Participate in design reviews and provide input to the design recommendations; provide input to information/data flow
The Ideal Qualifications
Outstanding communication skills and the ability to lead a team
Strong knowledge of architecture principles, development standards, and best practices
Can do attitude, with the ability to drive to success in both independent and group projects
Demonstrated experience with data integration architectures, data analysis and implementation
Demonstrated experience with ETL tools, including Informatica Cloud IICS
Demonstrated experience with Enterprise level Data Warehousing
Demonstrated experience with various databases and SQL scripting
Able to be agile in thinking and approach to solve the problem at hand.
Full Life Cycle Development
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
Experience with Insurance and/or wealth management projects a strong plus
#LI-RK1
Salary Range:
$113,100.00-$148,400.00
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.

#J-18808-Ljbffr