ETL Developer
3B Staffing LLC, Charlotte, NC, United States
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
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