Oracle Developer with Informatica
ideaVat LLCSan Diego, California, United States
Posted March 23, 2017
Full Time
About the Company
We recruit for product development teams as well as IT teams; we understand the difference in skill sets and personnel needed for both back-end and front-end.
Job Description
OUR DIRECT CLIENT IS A MULTI BILLION DOLLAR GLOBAL NAME WITH OFFICES ALL OVER THE US IS LOOKING FOR ORACLE DEVELOPER WITH INFORMATICA. This contract-to-hire position is for a Oracle Developer with Informatica experience.
Requirements
- 8 years of overall IT/software development experience
- 4+ years of recent experience as an Oracle developer
- Strong development experience with Oracle PL/SQL
- Experience with working on large Oracle databases using SDLC methodologies
- Experience in performance tuning, application monitoring and support of production applications
- Experience with writing detailed technical specifications for developers
- Working knowledge of SQL Server and experience in automotive marketing and/or CRM applications preferred
- Oracle Certifications a plus
- Detailed and up-to-date knowledge of Informatica Power Center workflows and mapping components
- Ability to tune Informatica workflows; knowledge of optimal mapping techniques
- In-depth experience developing comprehensive Informatica solutions to run against large OLTP systems or data warehouses
- Working knowledge of file transfer protocol (FTP) in Unix
- Knowledge of database architecture and best practices for Oracle SQL and PL/SQL coding style and application tuning
- 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
- Excellent impact-analysis skills and discipline
- Development experience in Oracle PL/SQL with good software methodology/practices
- Working knowledge of SQL Server preferred
- Development experience in Unix Korn shell scripting
- Experience working on large Oracle databases (preferably over 1TB)
- Experience in performance tuning, application monitoring and support of production applications
- Experience working with offshore teams preferred
- Experience in automotive marketing and/or CRM applications preferred
- Experience with source control systems (VSS, TFS, etc.) preferred
Benefits
- Visa sponsorship for US citizen or green card holder candidates