Description

Build and maintain ETL processes to move data from staging to target tables.

Responsibilities

• Design, code, and unit test ETL packages, triggers, stored procedures, views, and SQL transactions.
• Develop Informatica PowerCenter mappings, including transformations, mapplets, and workflows.
• Schedule, execute, and monitor ETL jobs with integrated exception handling and balance and control measures.
• Perform troubleshooting, debugging, and performance tuning while refining SQL queries for data profiling.
• Manage and administer ETL jobs using Informatica repository manager, designer, workflow manager, and workflow monitor.

Required Skills

• 5+ years of experience in ETL development.
• Proficiency with Informatica PowerCenter (Designer, Workflow Manager, Workflow Monitor).
• Strong SQL skills for data management and query optimization.
• Experience following SDLC development standards.
• Ability to manage data movement from staging to target tables.
• Experience with Informatica repository manager.
• Degree in any graduate field.

Preferred Skills

• Experience with data profiling techniques.

Key Skills

Education

ANY GRADUATE