Senior ETL Developer

Senior ETL Developer

MARIETTA, PA

6 DAYS AGO 22520533 Summary

MARIETTA, PA

Hybrid Competitive Salary 4 Years Experience Bachelor's degree No Commission 40.00 hours per week / Day Shift / Full-Time Description Donegal Mutual Insurance Company seeks Senior ETL Developer.

DUTIES:

Responsible for designing overall data storage, data files, and reporting structures for company's internal customer business, regulatory, and product performance needs. Responsible for all phases of solution delivery from initial requirements analysis, solution estimation, coordination of development, testing and delivery to production while applying knowledge of the Personal and Commercial lines of insurance. Use Informatica ETL Software to design, load, and query dimensional and relational data models in data warehouse environments. Read PL/SQL for ETL relating to data warehousing and integration. Read and create entity relationship (ER) diagrams and illustrating process flows. Use Oracle for database modeling. Work with Guidewire Policy Center and DataHub. Translate requirements from the mapping specs into technical code. Collaborate with ETL, Database Administration, Business Intelligence and Data Modeling teams to prioritize and coordinate work in various stages. Create, implement, maintain, and extend common reusable data integration components. Monitor and promote data integration best practices across all work-streams. Ensure all data integration processes are documented and recoverable as it pertains to disaster recovery. Provide technical mentoring to peers. Provide documented project and task updates to all concerned parties in a timely manner. Remote work available up to 50%; must work at Donegal Mutual Insurance Company's office in Marietta, PA at least 50%.

REQUIREMENTS

Bachelor's degree (or foreign equivalent) in Computer Science, Business Systems, or related industry fields, plus 4 years of experience using Informatica ETL Software to design, load, and query dimensional and relational data models in data warehouse environments.

Experience must include the following:

3 years of experience using PL/SQL for ETL relating to data warehousing and integration; reading and creating entity relationship (ER) diagrams and illustrating process flows; and using Oracle for database modeling. And 2 years of experience working with Guidewire Policy Center or DataHub; and working in either the Personal or Commercial line of the insurance industry. Remote work available up to 50%; must work at Donegal Mutual Insurance Company's office in Marietta, PA at least 50%.

Please apply at https:

//www.donegalgroup.com/careers. Job

ID 426412.

Additional Details How To Identify Potential Job Scams

APPLY ON EMPLOYER'S WEBSITE

Save Job Print Share This Job Copyright©2026Commonwealth of Pennsylvania Governor Josh Shapiro SSR 849: JobPostingDetails |

Build:

19.3.5.65 (4/23/2026 12:14:05 PM) |

Server:

LIEDCPRWBCWD002

|

Database:

Database Instance