Description

Lead the design, development, and maintenance of ETL processes and data vault architectures within the insurance domain.

This role is on-site.

Responsibilities

• Design and maintain ETL processes using Informatica Power Center, DBT, and Snowflake.
• Develop data vault architecture and Snowflake database solutions.
• Extract, transform, and load data using DB2 and Snowflake databases.
• Write and optimize SQL queries for efficient data processing.
• Collaborate with stakeholders to translate insurance business requirements into technical solutions using SAFe Agile and Rally.

Required Skills

• 10+ years of experience in ETL development.
• Expertise in Informatica Power Center.
• Strong proficiency in SQL and database management.
• Hands-on experience with DB2 and Snowflake databases.
• Practical knowledge of DBT and data vault architecture.
• Experience working within the SAFe Agile framework.
• Proficiency using Rally for project task and user story management.
• Domain knowledge of insurance business processes and data.

Preferred Skills

• Experience managing complex data workflows in an Agile environment.

Key Skills

Education

Any Graduate