Description

You will design and implement ETL workflows to move data from source to target systems using Informatica PowerCenter.

Responsibilities

• Author technical designs, create mappings, and build workflows in Informatica PowerCenter.
• Develop database storage structures, objects, and error handling procedures.
• Execute unit testing, peer code reviews, and assist in performance tuning for high data volumes.
• Manage deployments by migrating database objects, parameter files, and shell scripts to production.
• Collaborate with vendors and internal IT to set up SFTP and REST APIs for file transfers.

Required Skills

• 5+ years of experience in ETL development.
• Expertise with Informatica PowerCenter.
• Hands-on experience with REST APIs and SFTP integration.
• Proficiency in creating technical designs and mapping workflows.
• Experience with database object creation and maintenance.
• Ability to perform peer-to-peer code reviews and provide technical direction.
• Bachelor’s degree in Computer Science, IT, Computer Information Systems, or equivalent experience.

Key Skills

Education

Bachelor's Degree