ETL Developer in Lincoln, RI at Amica

Date Posted: 4/10/2021

Job Snapshot

Job Description

ETL Developer
Corporate Information Systems
Job Site: 25 Amica Way, Lincoln, RI 02865

Want to join a company where doing good is what we do?
The feeling is mutual.

Our Lincoln, RI is seeking an ETL Developer to develop code, test and debug Extract Transform and Load (ETL) solutions using existing and emerging data integration methods and tools.


  • Develop, code, test and debug Extract Transform and Load (ETL) solutions using existing and emerging data integration methods and tools. 
  • Develop data transformations for integration solutions according to specifications.               
  • Participates in design, development, test and implementation of data transformation objects using current tools and software.  
  • Troubleshoot technical issues related to data transformation, process flows and transformation issues. 
  • Assist in preparing detailed system specifications from which integrations will be developed.
  • Manage assigned work through all phases of the Application Development Life Cycle. Utilize and maintain technical and applications expertise, including the use of technologies, tools, programming standards, established processes, and concepts necessary to develop quality IT solutions. 
  • Assist with maintaining, updating and monitoring the team’s incidents, problems, defects and all work requests.  Provide mentoring regarding setup and development of data integration technologies and configurations.


Bachelor’s degree in Computer Science, Technology, Informatics or a closely related field plus 4 years experience developing and maintaining Data Warehouse and ETL applications. Experience, which may be gained concurrently, to include each of the following:

  • 2 years experience utilizing IBM DataStage Designer and Director for development, administration, and maintenance of data warehouse applications.
  • 2 years experience implementing complex ETL transformations using complex queries and stored procedures.
  • 2 years experience preparing detailed system specifications for development of data integrations and migrations.
  • 2 years experience performing extraction and loading using SQL, DB2 and Teradata Databases.
  • 2 years experience with scripting to automate file preparation and database tools Capability to understand requirements and convert to design.

** This position is eligible for Employee Referral Program award bonus.

About Amica

Amica Mutual Insurance Company is America’s oldest mutual insurer of automobiles. A direct national writer, Amica also offers home, marine and umbrella insurance. Amica Life Insurance Company, a wholly owned subsidiary, provides life insurance and retirement solutions. Amica was founded on the principles of creating peace of mind and building enduring relationships for and with our exceptionally loyal policyholders, a mission that thousands of employees in offices nationwide share and support.

Equal Opportunity Policy: All qualified applicants who are authorized to work in the United States will receive consideration for employment without regard to race, color, religion, sex, gender, gender identity, gender expression, sexual orientation, family status, ethnicity, age, national origin, ancestry, physical and/or mental disability, mental condition, military status, genetic information or any other class protected by law. The Age Discrimination in Employment Act prohibits discrimination on the basis of age with respect to individuals who are 40 years of age or older. Employees are subject to the provisions of the Workers' Compensation Act.