IdeaVat


Oracle with Informatica B2B Developer
Skill PL/SQL, Oracle,SDLC,B2B
Location San Diego, CA
Total Experience 8 yrs.
Max Salary $ DOE Per Hour
Employment Type Contract Jobs (Temp/Consulting)
Job Duration Long Term
Domain Any
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:* Candidates should have as many of these skills as possible:
9 to 10+ years of overall IT/software development experience.
5+ years of recent experience as a senior Oracle developer.
Strong development experience with Oracle PL/SQL: construction of packages, triggers and PL/SQL blocks and Unix Korn shell scripting.
Experience with working on large Oracle databases using SDLC methodologies (agile, waterfall).
Experience in performance tuning, application monitoring and support of production applications with distributed teams
Experience with writing detailed technical specifications for developers; design, validate and execute software test plans.
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 design and develop sophisticated workflows and data transformations involving Informatica B2B components – DX (Data Exchange) and DT (Data Transformation).
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.
Recent and relevant experience as a Senior Oracle Developer
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.
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.