ETL Developer

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 Wealth Management Technology Team supports 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:
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

• Bachelor's degree in computer engineering, computer science or related technical field
• 5+ years Informatica development experience in a team setting
• 2+ years using Informatica Cloud (IDMC/IICS)
• 1+ year experience of design, develop and maintain Informatica cloud data integration processes using the appropriate data load techniques
• 1+ year experience of design, develop and maintain database objects (tables, views, stored procedures, etc.) and SQL scripts.
• 1+ year experience of creating and maintaining UNIX/LINUX scripts
• 1+ year experience of providing support of ETL/ELT production processes to ensure timely completion and availability of data in data warehouse for reporting use.

The Ideal Qualifications

• Outstanding communication skills
• 1+ year experience of debug and tune data integration processes; analyze data warehouse architecture, normalized/de-normalized, troubleshoot and recommend improvements and alternate methodologies
• 1+ year experience of code reviews and ensure that all solutions are aligned to pre-defined architectural and requirement specifications
• 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
• 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
• 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

What to Expect as Part of MassMutual and the Team

• Weekly team meetings with the Wealth Management Technology Team
• Focused one-on-one meetings with your manager
• Access to mentorship opportunities
• Networking opportunities including access to Asian, Hispanic/Latinx, African American, women, LGBTQ, veteran and disability-focused Business Resource Groups
• Access to learning content
• Your ethics and integrity will be valued by a company with a strong and stable ethical business with industry leading pay and benefits
• Agile scrum 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 our team delivery model
• Conduct technical troubleshooting, maintenance, and operational support for production code
• Code! Code! Code!

#LI-RK1
MassMutual is an equal employment opportunity employer. We welcome all persons to apply.
If you need an accommodation to complete the application process, please contact us and share the specifics of the assistance you need.
Salary Range: $124,800.00-$163,800.00