Urgent Role - Sr ETL developer || Boston, MA || USC, GC
Urgent Role - Sr ETL developer || Boston, MA || USC, GC
Steneral Consulting
Boston, MA
See who Steneral Consulting has hired for this role
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.
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.
-
Seniority level
Mid-Senior level -
Employment type
Full-time -
Job function
Business Development and Sales -
Industries
IT Services and IT Consulting
Referrals increase your chances of interviewing at Steneral Consulting by 2x
See who you knowGet notified about new Senior ETL Developer jobs in Boston, MA.
Sign in to create job alertSimilar jobs
People also viewed
-
Business Intelligence Developer/Database Administrator
Business Intelligence Developer/Database Administrator
-
Business Intelligence Developer Lead, VP
Business Intelligence Developer Lead, VP
-
Urgent requirement of Power BI Developer / Lead & Architect @ 100% Remote (Full Time Only)
Urgent requirement of Power BI Developer / Lead & Architect @ 100% Remote (Full Time Only)
-
Epic BI Developer (Medicare Advantage & Tapestry) ** 100% Remote **
Epic BI Developer (Medicare Advantage & Tapestry) ** 100% Remote **
-
Business Intelligence Developer (Construction Software)
Business Intelligence Developer (Construction Software)
-
Onsite Work - Need Tableau Developer in Charlotte NC
Onsite Work - Need Tableau Developer in Charlotte NC
-
MSBI developer with SSRS & loan Management Service background
MSBI developer with SSRS & loan Management Service background
-
Data Technical Lead (SSIS/ETL/Snowflake)
Data Technical Lead (SSIS/ETL/Snowflake)
-
Onsite Work - Need Tableau Developer in Charlotte NC
Onsite Work - Need Tableau Developer in Charlotte NC
-
Lead ETL Techno Functional Consultant -Bellevue/Seattle(Hybrid)
Lead ETL Techno Functional Consultant -Bellevue/Seattle(Hybrid)
Looking for a job?
Visit the Career Advice Hub to see tips on interviewing and resume writing.
View Career Advice Hub