Senior ETL Developer Job in Portsmouth 03804, New Hampshire Us
About Liberty Mutual Group
“Helping people live safer, more secure lives” since 1912, Boston-based Liberty Mutual Group is a diversified global insurer and third largest property and casualty insurer in the U.S. based on A.M. Best Company’s report of 2010 net written premium.
The Group also ranks 82nd on the Fortune 100 list of largest corporations in the U.S.
based on 2010 revenue. As of December 31, 2010, Liberty Mutual Group had $112.4 billion in consolidated assets, $95.4 billion in consolidated liabilities, and $33.2 billion in annual consolidated revenue.
Liberty Mutual Group offers a wide range of insurance products and services, including personal automobile, homeowners, workers compensation, property, commercial automobile, general liability, global specialty, group disability, reinsurance and surety.
Liberty Mutual Group (www.libertymutualgroup.com) employs over 45,000 people in more than 900 offices throughout the world.
Liberty Mutual Personal Markets has an immediate need for a Senior ETL Informatica Developer with experience in administration. The preferred candidate must also be willing and enthusiastic to be part of an on call 24/7 support rotation on our Production Support team.
If you have a solid technical background and excellent problem-solving and organizational skills, this is a great opportunity to work on development projects while performing functions of a systems administrator and being exposed to a variety of technologies. You will assist in fueling the growth of our Liberty Mutual Personal Markets organization by administering systems that power our Enterprise Data Warehouse.
General Responsibilities:
Work on Development projects for the Life Company division:
· Provide systems administration, operational support and problem resolution for large systems along with providing ETL Informatica Development.
· UNIX Scripting and troubleshooting
· SQL queries
· Hyperion report development
· Troubleshoot hardware and software problems, take appropriate corrective action, interact with IT staff and vendors in performing complex testing, support and troubleshooting functions. Communicate and document findings
· Support production and non-production environments
· Develop performance, SLA, and service quality reporting
· Perform software installation and upgrades
· Monitor system performance and capacity; report changes in usage
· Manage security administration and deployments
· Document standards and operating procedures for a large system and act as a technical resource to IT staff and systems users
· Lead upgrade projects
· Analyze complex technical problems and design and implement effective solutions.
· Proactively provide technical and process-oriented suggestions for improvements and enhancements.
· Participate on 24X7 on-call Production Support rotation
Qualifications:
· Strong ETL skills required (Informatica)
· Strong Unix skills required
· Strong SQL skills required
· Teradata Database experience a plus
· 8+ years of overall IS experience required
· Experience in large volume data warehouse environment preferred
· Strong oral and written communication skills
· Bachelor's Degree in Computer Science or related area of study
· Solid time management and project management skills, and detail-oriented
· Must work well independently and in a collaborative team environment.
Benefits:
We recognize that talented people are attracted to companies that provide competitive pay, comprehensive benefits packages and outstanding advancement opportunities. For this reason we offer a Comprehensive Benefits Plan that includes the following:
- 401K and Company paid pension plan
- Medical coverage
- Dental coverage
- Paid time-off
- Pay-for-Performance
- Discounts on automobile and homeowner's insurance
- Discount fitness memberships
- Flexible spending accounts
- Tuition reimbursement
- Vision care coverage
- Work/Life resources
- Credit Union membership
- Employee and Dependent life insurance
- Disability insurance
- Long-term care insurance
Overview:
We believe strongly that commercial success can be achieved in a manner consistent with principles and ideals that bind us together as one company, that set us apart from our competitors, and that in the end will allow us to say we have succeeded commercially by doing the right thing the right way.
We believe that the Company's success is inextricably linked to our employees' satisfaction and success: satisfaction that they work for an industry leader committed to improving safety, satisfaction that they work for a company that does the right thing, and satisfaction that the company will reward them for their contributions and provide opportunities for personal growth and success.
We believe our employees take pride in knowing that they help people live safer more secure lives everyday.