TITLE: Senior ETL Developer
JOB ID: 426412
LOCATION: Donegal Mutual Insurance Company, 1195 River Rd, Marietta PA 17547
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%.
EDUCATION/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
What We Do
Our family of property and casualty insurance companies provides full lines of personal, farm and commercial insurance products across multiple regions of the United States. We are proud of our heritage, which spans nearly 130 years in the insurance business.
