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.

Education

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