Description

You will design, develop, and maintain ETL workflows to support complex data integration needs.

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 process documentation.

Required Skills

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

Preferred Skills

• Knowledge of Insurance, Guidewire Policy Center, and Policy Migration Tool.

Key Skills

Education

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