hero

Mass Fintech Careers

Discover the opportunities across the Mass Fintech Community

ETL Developer

MassMutual

MassMutual

Software Engineering
Springfield, MA, USA
Posted on Tuesday, December 12, 2023

ETL Developer

Springfield, Massachusetts Technology Job ID R14704

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

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.
Salary Range: $113,100.00-$148,400.00 Apply