MassMutual's Wealth Management Technology Team needs an ETL Developer to support complex and dynamic business operations, including product delivery, financial planning, lending, and investment operations. The role involves ensuring timely data availability for reporting, resolving defects, and supporting regulatory requests, all while adopting leading-edge technologies and data management standards.
Requirements
- 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.
- 1+ year experience of debug and tune data integration processes
Responsibilities
- Conduct technical troubleshooting, maintenance, and operational support for production code
- design, develop and maintain Informatica cloud data integration processes using the appropriate data load techniques
- design, develop and maintain database objects (tables, views, stored procedures, etc.) and SQL scripts.
- creating and maintaining UNIX/LINUX scripts
- providing support of ETL/ELT production processes to ensure timely completion and availability of data in data warehouse for reporting use.
- debug and tune data integration processes
- analyze data warehouse architecture, normalized/de-normalized, troubleshoot and recommend improvements and alternate methodologies
Other
- 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).
- Outstanding communication skills
- Can do attitude, with the ability to drive to success in both independent and group projects
- Able to be agile in thinking and approach to solve the problem at hand.
- Demonstrated experience and ability to deliver results quickly in a fast-paced environment on multiple projects
