What are the responsibilities and job description for the Lead ETL Informatica Developer with Oracle Exadata position at QSS?
Job Title: Lead ETL Informatica Developer with Oracle Exadata
Location: Kennesaw, GA
Duration: Full Time
Mus Have:
- 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
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
Job Type: Full-time
Work Location: On the road
