The company needs to integrate data from various sources into their insurance data warehouse and analyze Personal, Commercial, and Farm insurance data to support business intelligence and reporting needs.
Requirements
- 5+ years of experience in ETL development using Informatica PowerCenter, SQL Server Integration Services, Python, or equivalent required.
- Strong SQL skills and proficiency in relational databases such as Oracle, SQL Server, or MySQL required.
- Experience with data integration technologies such as REST, SOAP, XML, and JSON required.
- Some cloud exposure, preferably Azure and/or Snowflake required.
- Familiarity with agile software development methodologies preferred.
Responsibilities
- Design and develop ETL workflows to extract data from various internal and external sources, transform it according to business rules, and load it into Insurance focused data repositories, ensuring data integrity and quality.
- Develop mapping requirements, documenting data movement and transformation rules.
- Design, architect, and implement data marts for Personal, Commercial, and Farm insurance data.
- Develop and maintain technical documentation for ETL processes, data models, and other related artifacts.
- Optimize ETL processes for performance and scalability.
- Participate in code reviews and contribute to best practices for ETL development.
- Troubleshoot and resolve ETL-related issues and defects.
Other
- Collaborate with business users, IT, and other stakeholders to understand business requirements, develop architectural requirements and translate them into technical solutions.
- Support the IT team with other duties as assigned.
- Perform other duties as assigned by supervisor.
- 3+ years of experience in Property & Casualty insurance preferred.
- Ability to self-manage and stay on track with commitments; resourceful in solving problems and removing impediments required.
