Urgent Role - Sr ETL developer || Boston, MA || USC, GC

Job Description

Role: Sr ETL developer

Location: Boston, MA

Duration: 3+ Months CTH

Position Details

Manager Is Adding The Following Requirements

All the same skills still apply to what the team at PRAC is using now but they may be going into some newer tools that the manager would like candidates to have exposure to, specifically: DBT, FiveTran, Python, AWS S3, Parquet files, Snowflake. (snowflake was already out there).

When asked what is most important, manager said “Ideally all are important, but I really would like to find someone with experience with Fivetran and DBT to Snowflake.”

Location Details: MUST work onsite 4 days a week. Office is located across the street from South Station. PTO doesn’t count towards the 1 day remote and they offer flex for illnesses. Must be onsite between 9am-3pm, but open to a start between 7am-9am and an end between 3pm-5pm.

Subvending Allowed? YES – the manager wants to convert the resource to a perm employee in the future and will sponsor if the consultant is on a visa. Please obtain a 3 month release from the vendor. Our conversion terms with the client are 3 months, no fee

Must Haves

Informatica Powercenter

Five Tran, DBT, Snowflake

DB2 and SQL on prem

Cloud and AWS environment

IICS

Plus

P+C industry exp

Day To Day

This team supports the regulatory insurance team and supplies data to state departments like the DMV on how and when they write insurance policies. They also report on losses of data and types of policies written. This data goes into a shared data source, and the company has approximately 2,000 submissions on a yearly basis. All of this is done in ETL. There is a datamart around previous year’s insurance data that can be audited, analyzed and edited over the previous 3 years. The company has ramifications, and is possibly fined, if the data is late or wrong, and each state has their own rules around these policies and data reporting.

These ETL Developers will be responsible for developing and maintaining interfaces. They will also work on new features from an internal or external change such as layout modifications and/or providing more or less data. They will partner closely with the Data Analyst group and the testing team to get these modifications successfully developed and deployed into the environment. The environment is on prem as of today and is hosted in their data center. The 5 year goal is to migrate these platforms and data to the cloud.

The current environment is DB2 and SQL on prem, moving to AWS in the future so knowledge of current and new technologies is key. They are on Powercenter, moving to IICS in 2 yrs. Leaning towards Snowflake for ETL.