This site uses cookies. To find out more, see our Cookies Policy

Associate ETL Developer in Lincoln, RI at Amica

Date Posted: 5/29/2019

Job Snapshot

Job Description

Associate ETL Developer
25 Amica Way, Lincoln, RI 02865

Believe that IT works best when it makes a difference in people’s lives?
The feeling is mutual.

Responsible for various data migration efforts to support modernizing legacy systems efforts
Participates in all activities associated with design, development, test and implementation of data transformation objects using current tools and software.
Develop data integration processes combining diverse data sources into a unified view to support analytics and reporting requirements
Prepares detailed system specifications from which data integrations or migrations will be developed.
Deliver projects using the latest tools/technologies within an agile environment.
Troubleshoot technical issues related to data transformation, process flows, transformations and product issues.
Assist in establishing processes and procedures, customizations, configurations and administration of ETL projects and tool solutions.
Provide technical guidance on the deployment of architecture, development guidelines.
Design and implement technology best practices, guidelines and repeatable processes.

Bachelor's degree and minimum of 1+ years’ experience in Data Integration tools and experience developing scalable and comprehensive enterprise data solutions or an equivalent combination of education and experience sufficient to successfully perform the essential functions of the job.
Knowledge of IBM DataStage Designer and Director.
Strong SQL knowledge working with complex queries and stored procedures.
Experience with scripting to automate file preparation and database tools
Capability to understand requirements and convert to design.
Strong analytical abilities and interpersonal skills needed to effectively gather and identify requirements.
Ability to work independently and within a team environment, with limited supervision while also managing multiple priorities under tight deadlines.
Exposure to Python, R or iPython or any other Scripting language.
Experience with NoSQL databases, such as MongoDB and relational databases such as DB2, Teradata, and SQL Server.
Familiarity with XML/JSON schemas
Experience working in Linux OS, bash scripting, PuTTy
Familiarity with ETL, Big data, Spark and Kafka is a plus
Understanding of web services technologies such as REST, SOAP, HTTP, JSON
Requires solid DataStage Developer experience and implementing complex ETL transformations
Prior experience with data migration, modernization, or Data Warehousing projects a major plus

Perks and Benefits
Paid vacation, holidays and sick days
Generous leave programs, including paid parental bonding leave
Medical, dental, vision coverage, short- and long-term disability, and life insurance
Generous retirement benefits
Opportunities for advancement in a successful and growing company

Equal Opportunity Policy: All qualified applicants who are authorized to work in the United States will receive consideration for employment without regard to race, religion, sex, color, national origin, ethnicity, age, genetic information, disability or sexual orientation. 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.