ETL Developer Job at Arbella Insurance Group, Quincy, MA

WTFXaCtyQ3l2eWJOaGpyWFgvMjY3dnVFVWc9PQ==
  • Arbella Insurance Group
  • Quincy, MA

Job Description

Why Arbella?

At Arbella, we're focused on people. We work hard to attract and retain the best. That means providing a great work environment, encouraging work/life balance, offering flexible work arrangements, competitive salaries and exceptional benefits packages. We invest in our employees and encourage them to grow so that we, too, can grow as a company.

Other perks include:

•On-site gym and fitness classes and one-on-one personal training
•On-site nurse, nutritional counseling, and mental health resources
•Full-service cafeterias
•Free shuttle service to Quincy Adams T Station
•Tuition assistance programs
•Opportunities to get involved: Arbella Activities Committee, Diversity and
Inclusion Council, and more
•A company committed to community: volunteer opportunities, employee-
led community efforts, and the Arbella Insurance Foundation
•Robust training, mentorship, and professional/personal development
programs
•Colleagues who genuinely care about each other

Arbella is committed to building a workplace that's diverse, inclusive, and equitable for everyone. We've created a culture that supports a diverse workplace where all are valued for their talents and are empowered to reach their full potential.

It's no wonder our employees have voted Arbella one of the Boston Business Journal's "Best Places to Work" every year since 2009, and #1 in 2023!

The Arbella ETL Developer III will be responsible for creating and updating Extract Transform Load (ETL) related programs and processes for Arbella's diverse personal insurance environment, which includes multiple policy, billing and management reporting applications. These applications run in the Arbella datacenter as well as in our expanding Microsoft Azure subscriptions. The role will provide support for existing ETL processes that run on an hourly, daily and monthly basis to move critically important data among our systems. This will involve resolving technical issues of varying complexity in a timely manner through an in depth understanding of ETL and an increasing knowledge of Arbella's environment.
The ETL Developer III will also assist in reviewing business requirements while developing functional and technical specifications to support our migration to new modern cloud based policy and payment processing systems. This work will be done by using the Informatica Powercenter application along with other common data moving tools such as Talend, SQL Loader and Python. The position is part of a diverse team located in the Arbella home office in Quincy MA with a flexible work environment allowing for a schedule that includes a great office environment and multiple days a week working from home.

Key Requirements:
  • Design, customize, and implement ETL workflows and processes.
  • Serve as a Subject Matter Expert (SME) within all aspects of the ETL environment
  • Perform application testing of configurations and customizations.
  • Participate in analysis sessions to determine application requirements
  • Assist in leading small and medium sized development efforts.
  • Application code programming (including testing and debugging code at the unit test level)
  • Application support (including after hours and on-call 24/7 coverage on a rotational basis)
  • Maintain proficiency in the applicable programming languages and development tools
  • Maintain updated system configuration artifacts and process documentation
  • Production Implementation support

Key Requirements:
  • 5 + years of experience as an ETL developer
  • 3 + years of experience with Informatica Powercenter and Python
  • Oracle and SQL Server relational database experience


Preferred Experience:
  • Agile development experience (SCRUM, SAFe...)
  • Experience with Microsoft Azure or other cloud environments
  • Experience working with mainframe environments
  • Property and Casualty Insurance domain experience
#LI-MG1

Job Tags

Hourly pay, Home office, Flexible hours,

Similar Jobs

Novant Health

Registered Nurse, Pelvic Specialty Job at Novant Health

What We Offer: The Registered Nurse serves as a leader of the healthcare team at Novant Health by establishing an authentic personalized...  ...nursing required. If your RN nursing license has been inactive, retired or lapsed for five years or more and you have not been licensed... 

Metropolitan Market

Meat/Seafood Assistant Team Leader Job at Metropolitan Market

 ...THE ROLE As a key member of the Meat/Seafood department leadership team, the Meat/Seafood Assistant Team Leader has a breadth of responsibilities spanning from team member development and sales generation, to product management and merchandising. In this role, you... 

The AES Corporation

Legal Counsel Job at The AES Corporation

 ...committed to meeting the Paris Agreements goals by 2050. Legal Counsel Clean Energy Provide advice and counsel to...  ...relevant legal experience, preferably at a major law firm or in?house. R enewable energy experience; wind energy, battery storage or...