Description

You will design, develop, and deploy Informatica PowerCenter workflows for enterprise systems, managing production releases and file scheduling.

This role is on-site.

Responsibilities

• Design and implement ETL solutions with optimized performance, ensuring effective job recovery, failover, logging, and alerting.
• Develop, modify, troubleshoot, and optimize complex SQL queries and stored procedures.
• Execute data mapping design, integration, migration, and warehousing tasks using relational and dimensional data modeling.
• Deploy Informatica solutions to production environments and manage file scheduling in accordance with integration requirements.

Required Skills

• 5+ years of experience in a medium or large operating environment supporting Informatica.
• 4+ years of SQL experience, including database building and management.
• Proficiency with Informatica PowerCenter for workflow design and development.
• Strong knowledge of DB2, SQL, PL/SQL, and JDBC.
• Understanding of ETL development standards for performance optimization and error handling.
• Experience with Java and J2EE development.
• Experience developing with Azure Data Factory.

Preferred Skills

• Previous experience in the banking and insurance industry.

Key Skills

Education

Any Gradute