Position: ETL Development Lead

Location: Kennesaw: GA & Richmond: VA (Hybrid-onsite 3x a week)

Job Description:

MUST HAVES:

• Informatica PowerCenter
• Oracle Exadata
• UNIX/SHELL SCRIPTS

Role

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

Ideal Candidate

• Proactive, self-starter hungry to learn and take ownership of the ETL work in two applications within Global Procurement. A 'can do' attitude is a must.

Responsibilities

• 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
• Excellent written and verbal communication skills down to the mapping documentation level

Required Skills

• 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
• Experience with Informatica Cloud is very desirable