Oracle with Informatica B2B Developer

<p><span>OUR DIRECT CLIENT IS A MULTI BILLION DOLLAR GLOBAL NAME WITH OFFICES ALL OVER the US;</span></p><p><span>US CITIZENS, GREEN CARD AND EAD GREEN CARD HOLDERS ONLY</span></p><p><span>Required Skills:* Candidates should have as many of these skills as possible:</span></p><p><span>9 to 10+ years of overall IT/software development experience.</span></p><p><span>5+ years of recent experience as a senior Oracle developer.</span></p><p><span>Strong development experience with Oracle PL/SQL: construction of packages, triggers and PL/SQL blocks and Unix Korn shell scripting.</span></p><p><span>Experience with working on large Oracle databases using SDLC methodologies (agile, waterfall).</span></p><p><span>Experience in performance tuning, application monitoring and support of production applications with distributed teams</span></p><p><span>Experience with writing detailed technical specifications for developers; design, validate and execute software test plans.</span></p><p><span>Working knowledge of SQL Server and experience in automotive marketing and/or CRM applications preferred.</span></p><p><span>Oracle Certifications a plus.</span></p><p><span>Detailed and up-to-date knowledge of Informatica Power Center workflows and mapping components.</span></p><p><span>Ability to design and develop sophisticated workflows and data transformations involving Informatica B2B components – DX (Data Exchange) and DT (Data Transformation).</span></p><p><span>Ability to tune Informatica workflows; knowledge of optimal mapping techniques.</span></p><p><span>In-depth experience developing comprehensive Informatica solutions to run against large OLTP systems or data warehouses.</span></p><p><span>Working knowledge of file transfer protocol (FTP) in Unix.</span></p><p><span>Knowledge of database architecture and best practices for Oracle SQL and PL/SQL coding style and application tuning.</span></p><p><span>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.</span></p><p><span>Recent and relevant experience as a Senior Oracle Developer</span></p><p><span>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.</span></p><p><span>Development experience in Oracle PL/SQL with good software methodology/practices.</span></p><p><span>Working knowledge of SQL Server preferred.</span></p><p><span>Development experience in Unix Korn shell scripting.</span></p><p><span>Experience working on large Oracle databases (preferably over 1TB).</span></p><p><span>Experience in performance tuning, application monitoring and support of production applications.</span></p><p><span>Experience working with offshore teams preferred.</span></p><p><span>Experience in automotive marketing and/or CRM applications preferred.</span></p><p><span>Experience with source control systems (VSS, TFS, etc.) preferred.</span></p> <p><span><b><u>US CITIZENS, GREEN CARD AND EAD GREEN CARD HOLDERS ONLY</u></b></span></p> <p>All your information will be kept confidential according to EEO guidelines.</p>