ETL Developer

MassMutual - Springfield, MA3.7

Since 1851, MassMutual's commitment has always been to help people protect their families, support their communities, and help one another. This is why we want to inspire people to Live Mutual. We're people helping people.

A career with us means you will work alongside exceptional people and be empowered to reach your professional and personal goals. Our employees are the foundation of what makes MassMutual a strong, stable and ethical business. We seek and value unique and varied perspectives and experiences because we believe we are stronger when all voices are heard. We invite you to bring your bright, innovative ideas to MassMutual as we continue to help millions of Americans rely on each other.

Together, we're stronger.


Responsibilities :
Engage Agile team members and be an active contributor in stand-ups, sprint planning, demos etc.
Focus on continuous improvement and learning
Learn existing applications and enhance/improve code base
Complete design and development tasks independently
Innovator thinker and isn't afraid to take risks
Analyze legacy/existing code and modify to ensure compliance with upgrades.
Leads efforts to analyze legacy code and mentors team to build skills.
Apply advanced knowledge of UNIX/Linux with hands-on experience developing and maintaining Shell scripts.
Demonstrate strong knowledge of Data Warehousing and ETL concepts, standards and best practices. Convert business rules into transformation rules, design and develop ETL mappings.
Ability to architect an ETL solution and required data conversion strategies.
Project experience with dimensional and relational data models.

Basic Qualifications:
BA or BS - Degree in Computer Science or related field preferred.
8+ years' experience supporting an environment with legacy applications.
Analyze and develop specifications for the enhancement, maintenance and problem solving for complex applications or operating system(s).
Provide in-depth consulting to IT management and staff at the highest technical level in the identification and resolution of an application or the overall operating system(s) problems or difficulties.
Experience collaborating with a team of developers with varying skill sets
Strong familiarity with mainframe applications.
Demonstrated ability to learn new programming languages.
Strong knowledge of at least 4 of the following programming languages: SQL, Java, .Net, COBOL, VB, Informatica, WebMethods
Strong knowledge of financial products, services and solutions
Development experience in a true Agile (Scrum/Kanban) environment.
Systems experience with Actuarial Valuation & Modeling Systems including Polysystems, Axis, CASE (ArcVal), Triton, Prophet, SE2, SynGIC.
Working knowledge of Stochastic and Seriatim valuations - policy level detail.
Experience with DAC, PBR, AG43, FAS91, Hedging, Assumptions and Experience studies.
Installation/administration and support of Informatica in new environments, including working expertise with server, workflow and session performance tuning methods, tools and monitoring.
Authorized to work in the US with or without sponsorship.

Preferred Qualifications:
Knowledge of working in a Cloud environment such as Amazon Web Services.
Knowledge of certain tools and technology - Microstrategy, Alteryx, Tableau, PySpark, Vertica.
Demonstrated skills in automating manual processes with the valuation and modeling end to end flow using technology.
Job scheduling knowledge on TWS Maestro.
Recognized as subject matter expert in Informatica field.
Informatica PowerCenter Architecture and Development experience from release 9.1.0 and above.
8+ years of work experience in databases Oracle, Teradata, SQL Server and DB2 including business experience in the development, maintenance and enhancement of Informatica Mappings, Workflows and Processes.

Ranked No. 93 in the annual FORTUNE ® 500 Ranking (FORTUNE ® Magazine, June 2018) and recognized as a World's Most Ethical Company by Ethisphere, MassMutual is guided by a single purpose: 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.


Focus on the Customer: We understand our customers well and look for every opportunity to deliver an experience that is clear, easy, personal, human, empowering and trustworthy.

Act with Integrity: We deliver on our promises by being open, honest and humble and by adhering to the letter and spirit of applicable laws, rules, regulations and company policies.

Value People: We respect and learn from each other's diverse backgrounds, experiences and ideas. We engage and develop people to their greatest potential.

Work Collaboratively: We work together to achieve results by actively listening, seeking, understanding and creating solutions as a unified team driving toward one company, one culture, one brand.

Achieve Results: We focus on winning by exceeding expectations and getting better - everyone, every day.

For more information, visit or find us on Facebook, Twitter, LinkedIn, YouTube, Google+, Instagram and Pinterest.

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.