ETL Developer

Responsibilities

• Global Procurement development lead to support ETL for VRPM and BICS applications

• Responsible for coordination of offshore development to assist in build efforts, including meeting with the offshore team on a daily basis to discuss ongoing work

• Responsible for reviewing and understanding requirements and translating them into high-level and low-level documentation including source to target mappings

• Responsible for build of data mappings, sessions, and workflows to meet requirements (Informatica 10.x or above)

• Responsible for development of job schedules that integrate with upstream and downstream systems (AutoSys jobs)

• Responsible for unit testing, debugging, and performance testing, with key focus on data accuracy and integrity

• Accountable for on-time delivery of all documentation, design, build, testing, and deployment

• Work with the production support teams as needed to support production activities, including production migrations, L3 support, continuity testing, and environment migration activities

Requirements

• Minimum of 5+ years with Informatica Power Center 10.x or above designing, developing, testing, and debugging

• Minimum of 5+ years of development experience in Oracle, Oracle Exadata, SQL Server, or another industry accepted database platform

• Minimum of 2+ years of Linux/shell scripting complementary with Informatica

• Proactive self-starter hungry to learn and take ownership of the ETL work in two applications within Global Procurement

• Excellent written and verbal communication skills down to the mapping documentation level

• A 'can do' attitude

• Desired Skills:

• Experience with Informatica Cloud