Description

Design, develop, and maintain ETL workflows for complex data integration using Informatica and Azure SQL. This role is on-site.

Responsibilities

• Create and manage ETL workflows using Informatica PowerCenter and Power Exchange.
• Translate business requirements into technical specifications for efficient data integration.
• Optimize ETL processes for performance, throughput, and minimal downtime.
• Implement data validation and cleansing routines to ensure data quality and integrity.
• Conduct unit and integration testing, troubleshoot production issues, and maintain documentation.

Required Skills

• 5-8 years of ETL development experience with Informatica PowerCenter and related products.
• Strong SQL skills with experience in Azure DB and SQL Server.
• Proficiency in UNIX/Linux scripting and scheduling tools.
• Knowledge of data warehousing concepts, BI architecture, and data modeling (star/snowflake schemas).
• Bachelor's or master's degree in computer science, Information Systems, or a related field.

Preferred Skills

• K knowledge of Insurance domain, Guidewire Policy Center, and Policy Migration Tool.

Key Skills

Education

Bachelor's or master's degree in computer science, Information Systems