Job Tite : ETL Informatica Architect

Location : PA(Onsite)

Duration : Long Term

Visa Restrictions : No H1B, No H1T, No OPT, CPT

Must-Have Experience with Guidewire

Roles and Responsibilities :

Design, develop, and implement Informatica ETL workflows and solutions tailored to support Guidewire integrations.

Architect scalable and efficient ETL frameworks for extracting, transforming, and loading data between Guidewire and external systems.

Collaborate with cross-functional teams, including Guidewire developers, business analysts, and IT stakeholders, to define data integration strategies.

Define and document ETL architecture standards, guidelines, and best practices.

Provide mentorship and guidance to junior developers and ETL teams.Lead efforts in data migration from legacy systems to Guidewire using Informatica tools.

Ensure data quality and integrity during migration by designing robust validation and cleansing processes.

Provide support for data transformation strategies and ensure alignment with business objectives.

Required Skills:

Proven experience as an Informatica Architect, with deep knowledge of PowerCenter, Informatica Cloud, and other related tools.

Proficiency in designing high-performance ETL solutions for large-scale enterprise systems.

Experience with SQL and database systems (e.g., Oracle, SQL Server, PostgreSQL).

Knowledge of cloud platforms (e.g., AWS, Azure, Guidewire Cloud) and deploying ETL workflows in cloud environments.

Excellent problem-solving and analytical abilities.

Strong communication and collaboration skills to work with cross-functional teams.

Ability to manage multiple priorities and deadlines effectively