| ETL Developer: Boston MA Hybrid :: LOCAL or Nearby at Boston, Massachusetts, USA |
| Email: [email protected] |
|
http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=1136873&uid= From: Pritam singh, KPG99 [email protected] Reply to: [email protected] Role: Sr ETL Developer Location: 695 Atlantic Ave Boston Onsite 4x per week Duration: 3 months to Hire Visa: USC/GC ONLY Location Details: MUST work onsite 4 days a week. Office is located across the street from South Station. PTO doesnt 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. Locals Onsite from day 1 in Boston 4x per week 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. 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 years 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. Thanks and Regards, Pritam Singh Sr. Technical Recruiter | KPG99 .INC Keywords: cprogramm sthree green card http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=1136873&uid= |
| [email protected] View All |
| 09:55 PM 20-Feb-24 |