ETL Developer
About MassMutual
Massachusetts Mutual Life Insurance Company (MassMutual) is a leading mutual life insurance company that is run for the benefit of its members and participating policy owners. MassMutual offers a wide range of financial products and services, including life insurance, disability income insurance, long-term care insurance, annuities, retirement plans and other employee benefits. MassMutual is headquartered in Springfield.
Responsibilities:
• Design and Develop ETL solutions per business requirements.
• Track batch related issues and suggest improvements.
• Generate reports and metrics.
• Performance tune queries.
• Work on ETL data configuration changes, server migrations.
• Support Informatica, Vertica, Teradata upgrades
Skillset:
• Minimum of 4 years’ of relevant experience.
• Extensive experience using Informatica PowerCenter and Informatica Cloud
• Current Teradata experience (Teradata version 12+)
• Strong Unix skills to maintain scripts
• Strong knowledge/experience of Data & Data Warehousing concepts and strong Teradata SQL skills, a must
• Strong ETL knowledge/experience a must – experience with SCD/Type II History processing
• Candidates must be qualified to work in the United States without sponsorship now or in the future
Experience:
• 5-8years