Description

You will build and manage data integration processes using Informatica PowerCenter and SQL.

Responsibilities

• Develop Informatica ETL code, including mappings, transformations, mapplets, and workflows.
• Design, code, and unit test ETL packages, triggers, stored procedures, views, and SQL transactions.
• Manage and administer ETL jobs using Informatica Repository Manager, Designer, Workflow Manager, and Workflow Monitor.
• Execute and monitor scheduled ETL jobs with integrated exception handling and control measures.
• Perform troubleshooting, debugging, and performance tuning of data processes.

Required Skills

• Informatica PowerCenter experience.
• Strong SQL skills, including queries for data profiling and management.
• Hands-on ETL development experience.
• Proficiency in SQL transactions.
• Experience moving data from staging tables to target tables.
• Knowledge of SDLC and development standards.
• Any graduate degree.

Preferred Skills

• Business Objects (BO).
• Crystal Reports.

Key Skills

Education

Any graduate