Oracle with Informatica B2B Developer

Company:  ideaVat
Location: San Diego
Closing Date: 02/11/2024
Salary: £150 - £200 Per Annum
Hours: Full Time
Type: Permanent
Job Requirements / Description

Job Description

OUR DIRECT CLIENT IS A MULTI BILLION DOLLAR GLOBAL NAME WITH OFFICES ALL OVER THE US;

US CITIZENS, GREEN CARD AND EAD GREEN CARD HOLDERS ONLY

Required Skills:

  1. 9 to 10+ years of overall IT/software development experience.
  2. 5+ years of recent experience as a senior Oracle developer.
  3. Strong development experience with Oracle PL/SQL: construction of packages, triggers and PL/SQL blocks and Unix Korn shell scripting.
  4. Experience with working on large Oracle databases using SDLC methodologies (agile, waterfall).
  5. Experience in performance tuning, application monitoring and support of production applications with distributed teams.
  6. Experience with writing detailed technical specifications for developers; design, validate and execute software test plans.
  7. Working knowledge of SQL Server and experience in automotive marketing and/or CRM applications preferred.
  8. Oracle Certifications a plus.
  9. Detailed and up-to-date knowledge of Informatica Power Center workflows and mapping components.
  10. Ability to design and develop sophisticated workflows and data transformations involving Informatica B2B components – DX (Data Exchange) and DT (Data Transformation).
  11. Ability to tune Informatica workflows; knowledge of optimal mapping techniques.
  12. In-depth experience developing comprehensive Informatica solutions to run against large OLTP systems or data warehouses.
  13. Working knowledge of file transfer protocol (FTP) in Unix.
  14. Knowledge of database architecture and best practices for Oracle SQL and PL/SQL coding style and application tuning.
  15. Ability to construct well-conceived, reusable PL/SQL packages, database triggers and PL/SQL blocks in Oracle, and Korn shell scripts as needed to support Informatica workflows and related file transfer processes.
  16. Recent and relevant experience as a Senior Oracle Developer.
  17. Excellent impact-analysis skills and discipline. Carefully analyzes the existing code base as part of each design effort, to avoid redundancy and inconsistency and maximize code reuse.
  18. Development experience in Oracle PL/SQL with good software methodology/practices.
  19. Working knowledge of SQL Server preferred.
  20. Development experience in Unix Korn shell scripting.
  21. Experience working on large Oracle databases (preferably over 1TB).
  22. Experience in performance tuning, application monitoring and support of production applications.
  23. Experience working with offshore teams preferred.
  24. Experience in automotive marketing and/or CRM applications preferred.
  25. Experience with source control systems (VSS, TFS, etc.) preferred.

Qualifications

US CITIZENS, GREEN CARD AND EAD GREEN CARD HOLDERS ONLY

Additional Information

All your information will be kept confidential according to EEO guidelines.

#J-18808-Ljbffr
Apply Now
Share this job
ideaVat
  • Similar Jobs

  • Oracle Developer with Informatica

    San Diego
    View Job
  • Oracle Developer

    San Diego
    View Job
  • Senior level ETL/Informatica Developer

    San Diego
    View Job
  • Intermediate Oracle Database Developer

    San Diego
    View Job
  • Senior Developer (Oracle and Unix)

    San Diego
    View Job
An error has occurred. This application may no longer respond until reloaded. Reload 🗙